Which statement is true concerning dropping a pluggable database (PDB)?
A.
The PDB must be open in read-only mode.
B.
The PDB must be in mount state.
C.
The PDB must be unplugged.
D.
The PDB data files are always removed from disk.
E.
A dropped PDB can never be plugged back into a multitenant container database (CDB).
Explanation:
The best question! definitely 2 correct answers!
From http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_8027.htm#SQLRF55700
The PDB you want to drop must be in mounted mode or it must be unplugged.
I agree, both B and C are correct!
B is better
B is correct.
Database needs to be closed, not unplugged.
The given answer, C is wrong. It is wrong only because there is more one correct answer.
A is wrong. You cannot drop a PDB which is open read only (or read write).
B is correct. You can drop a PDB which is MOUNTED.
C is correct. You can drop a PDB which has been UNPLUGGED.
D is wrong. When dropping a PDB, the default is to KEEP DATAFILES. You have the option to use the INCLUDING DATAFILES option as well.
E is correct. As long as you still have access to the XML metadata file and all the PDB datafiles, you can plug a PDB back into a CDB.
So, correct statements are B,C,E.
H*T*H
“A dropped PDB CAN NEVER be plugged back into a multitenant container database (CDB).”
X
“E is correct. As long as you still have access to the XML metadata file and all the PDB datafiles, you CAN plug a PDB back into a CDB.”
So, H*T*H… E is wrong! Or Incorrect!
A is not true; pdb2 doesn’t have to be in read-only mode
B is true; must be in this mode
C is true; or must be in this mode
D is not true; datafiles can be reused
E is not true,; dropped pdb can be used in another cdb
Based on the reference:
“The PDB you want to drop must be in mounted mode or it must be unplugged.”
mount mode is first, so the correct answer is B.
References:
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#BAJEFEHI
Both B and C are correct, other answers are incorrect
A: To drop PDB it must be in mounted mode or it must be unplugged.
D: you have to explicitly add “INCLUDING DATAFILES” to the command to delete datafiles as well.
E: Sure you can if the datafiles are still there and you have the xml file.
If I have to choose one answer only, I would go with ‘B’.
B Plumbum explained it formidable!
Here are several of the web sites we suggest for our visitors.
check beneath, are some absolutely unrelated internet websites to ours, on the other hand, they may be most trustworthy sources that we use
check beneath, are some entirely unrelated web-sites to ours, nevertheless, they are most trustworthy sources that we use
always a significant fan of linking to bloggers that I enjoy but really don’t get a great deal of link enjoy from
just beneath, are various entirely not related sites to ours, nevertheless, they are surely worth going over
Wonderful story, reckoned we could combine a few unrelated information, nonetheless seriously worth taking a look, whoa did 1 learn about Mid East has got a lot more problerms as well
C