Exam 1z0-063 topic 2 question 18 discussion

Actual exam question from Oracle's 1z0-063

Question #: 18
Topic #: 2

Your multitenant container database (CDB) CDB1, has no startup triggers and contains multiple pluggable databases (PDBs).
It was started up by using the command which executed successfully with no errors:

SQL> STARTUP MOUNT -
Which two statements are true? (Choose two.)

A. All redo logs are opened.
B. All control files are opened.
C. All tempfiles are opened.
D. CDB$ROOT is opened.
E. The SPFILE is opened.

Show Suggested Answer

Suggested Answer: AD 🗳️

by Djuka at March 11, 2020, 11:33 p.m.

Comments

Submit Cancel

chitter

3 years, 2 months ago

Status MOUNT: e) instance is started => spfile has been read b) database structure is known (e.g. for offline backup when db is in NOARCHIVELOG) => controlfile has been read Nothing else is opened at this point

upvoted 2 times

chitter

3 years ago

I take this back, recommended anser is right.. the CDB$SEED is open

upvoted 1 times

chitter

3 years ago

see Question #77

upvoted 1 times

chitter

3 years ago

And Question #195

upvoted 1 times

...

Sugar

4 years, 11 months ago

B E is my bet here. Prior to 12.1.0.2, when the CDB is started, all PDBs remain in mounted mode. There is no default mechanism to automatically start them when the CDB is started. The way to achieve this is to use a system trigger on the CDB to start some or all of the PDBs.

upvoted 4 times

...

SKY_ming

5 years ago

BE is right

upvoted 2 times

...

NorthKorean

5 years, 1 month ago

A,D is right

upvoted 3 times

...

Djuka

5 years, 2 months ago

I think BE

upvoted 3 times

...