exam questions

Exam 1z0-060 All Questions

View all questions & answers for the 1z0-060 exam

Exam 1z0-060 topic 1 question 124 discussion

Actual exam question from Oracle's 1z0-060
Question #: 124
Topic #: 1
[All 1z0-060 Questions]

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:

SQL > SHUTDOWN IMMEDIATE -

SQL > STARTUP MOUNT -
SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12','MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashed back schema?

  • A. Only 1
  • B. Only 2
  • C. Only 3
  • D. 3 and 1
  • E. 1 and 2
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
http://www.oracle-base.com/articles/12c/multitentant-flashback-of-container-database-12cr1.php

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
ryuah
2 years, 9 months ago
D가 맞아 읽어봐 한글로 적을거야 이제 https://oracle-base.com/articles/12c/multitenant-flashback-of-container-database-12cr1
upvoted 1 times
...
yaqui
4 years, 6 months ago
The answer for this question is C. There is no need to do 1 after this flashback operation.
upvoted 2 times
Yoones
3 years, 11 months ago
Yes the answer is C because in this scenario opening the pluggable databases are not required. Because the question has not asked to connect to the PDBs.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago