Exam 1z0-083 topic 1 question 163 discussion

Actual exam question from Oracle's 1z0-083

Question #: 163
Topic #: 1

Examine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
3. Each PDB has several tables with referential integrity constraints.
4. FLASHBACK DATABASE is ON.
5. UNDO RETENTION GUARANTEE is enabled.

Multiple undesired multitable changes were made in all the PDBs.

Which method can be used to undo the changes using a single command?

A. restore and recover database
B. flashback transaction
C. flashback database
D. flashback table
E. flashback table and transaction

Show Suggested Answer

Suggested Answer: C 🗳️

by ilputto at Jan. 6, 2023, 1:50 p.m.

Comments

Submit Cancel

_gio_

6 months, 3 weeks ago

Selected Answer: C

Sure of flashback database: flashback database "For CDBs, rewinds the entire CDB including all its PDBs." https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/FLASHBACK-DATABASE.html#GUID-584AC79A-40C5-45CA-8C63-DED3BE3A4511

upvoted 1 times

...

ScottL

9 months, 1 week ago

Selected Answer: C

C - "one command"

upvoted 1 times

...

frankkk

1 year ago

Selected Answer: C

C is Correct

upvoted 3 times

...

hilaire

1 year ago

C is correct

upvoted 3 times

...

ilputto

1 year ago

Selected Answer: C

C IN MY OPINION

upvoted 3 times

...

Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 163 discussion

Comments

_gio_

ScottL

frankkk

hilaire

ilputto

SY0-701