Which two statement is true concerning dropping a pluggable database (PDB)?

Which two statement is true concerning dropping a pluggable database (PDB)?

Which two statement is true concerning dropping a pluggable database (PDB)?

A.
A dropped PDB can never be plugged back into a multitenant container database (CDB).

B.
The PDB data files are always removed from disk.

C.
The PDB must be open in read-only mode.

D.
The PDB must be in mount state.

E.
The PDB must be unplugged.



Leave a Reply 11

Your email address will not be published. Required fields are marked *


Patty

Patty

BE

Patty

Patty

I was wrong all of then are incorrect.

Patty

Patty

All the answers are incorrect.
A is incorrect: You can plug in the database again passing in the XML metadata file that you get when you unplugged the database, if “KEEP DATAFILES” (default) was specified when you dropped it.
B. is incorrect: you can keep the data file with the option “KEEP DATAFILES” when you drop a PDB

C, D and E are incorrect. The PDB could be in unplug (to keep datafiles) OR unplug/mounted to include data files:
To specify KEEP DATAFILES (the default), the PDB you want to drop must be unplugged.
To specify INCLUDING DATAFILES, the PDB you want to drop must be in mounted mode or it must be unplugged.

Here the Oracle documentation:

DROP PLUGGABLE DATABASE Prerequisites

You must be connected to a CDB.

The current container must be the root, you must be authenticated AS SYSDBA or AS SYSOPER, and the SYSDBA or SYSOPER privilege must be either granted to you commonly, or granted to you locally in the root and locally in PDB you want to drop.

To specify KEEP DATAFILES (the default), the PDB you want to drop must be unplugged.

To specify INCLUDING DATAFILES, the PDB you want to drop must be in mounted mode or it must be unplugged.

parry teacher

parry teacher

In real exam we need to choose ONE option .
Best possible answer is :
E.The PDB must be unplugged

SQL> drop pluggable database pdb1d1 including datafiles;
drop pluggable database pdb1d1 including datafiles
*
ERROR at line 1:
ORA-65025: Pluggable database PDB1D1 is not closed on all instances.

So we need to close the data first and we have option to delete file or keep files
Hence BCE ruled out .

CC Noll

CC Noll

Hi, i have passed my Oracle 1Z0-060 exam last week, score of my 1Z0-060 exam: Section 1 = 90%; Section 2 = 92% (the passing score: Section 1 = 64%; Section 2 = 65%, both sections must be passed to pass 1Z0-060 exam). All 85 questions (Section 1 = 51q; Section 2 = 34q) were multiple choice questions, most of them were easy to answer, but few questions on Core Administration and Performance Management were a little difficult.

And, I learned valid 1Z0-060 dumps here: http://www.passleader.com/1z0-060.html (recommend to get FULL VERSION 1Z0-060 VCE dumps and PDF dumps for learning).

Good Luck!

Ahmed Alfizy

Ahmed Alfizy

D, E

alter pluggable database pd001 close ;

drop pluggable database pd001 ; ( note that default is keep datafiles )

drop pluggable database pd001 [ including datafiles ] ;