Exam 1z0-083 All Questions

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

Exam 1z0-083 topic 1 question 122 discussion

Actual exam question from Oracle's 1z0-083

Question #: 122
Topic #: 1

Examine this configuration:
1. CDB1 is a container database.
2. APP_ROOT is an application root in CDB1.
3. APP_PDB1 is an application PDB in APP_ROOT.
4. FLASHBACK DATABASE is ON.
You execute these commands:

Which table or set of tables will exist after the Flashback operation has completed?

A. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
B. CDB1_TAB and APP_PDB1_TAB
C. none of the tables, because all three tables will be dropped
D. CDB1_TAB only
E. CDB1_TAB and APP_ROOT_TAB

Show Suggested Answer

Suggested Answer: A 🗳️

by RinD at May 10, 2021, 3:54 a.m.

Comments

Submit Cancel

mporislav

Highly Voted 3 years, 2 months ago

B Performing a flashback operation on the application root reverts only the application root to the specified point in time.

upvoted 11 times

...

RinD

Highly Voted 3 years, 2 months ago

B correct

upvoted 5 times

...

_gio_

Most Recent 1 year ago

Selected Answer: B

https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing-flashback-dbpitr.html#GUID-66B1A12D-1C92-43B5-A204-AA8A6D177ABD

upvoted 1 times

...

vkra

1 year, 4 months ago

Selected Answer: B

B is correct, see comment from brolem

upvoted 1 times

...

hilaire

1 year, 6 months ago

B correct

upvoted 1 times

...

brolem

2 years, 3 months ago

B From <https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing-flashback-dbpitr.html#GUID-66B1A12D-1C92-43B5-A204-AA8A6D177ABD> To perform a flashback operation for an application container, you must perform flashback operations for the application root and all the individual application PDBs that are part of the application container. Performing a flashback operation on the application root reverts only the application root to the specified point in time.

upvoted 3 times

...

DBA007

2 years, 4 months ago

Hi Everyone, the question doesn't tell us about opening the app_root database 'alter pluggable app_root open resetlogs' in that case, app_root and app_pdb1 both are closed and cannot be confirmed about the existence of tables and Answer should be option D only.

upvoted 1 times

...

kvf

2 years, 6 months ago

I agree B, but when tested in my lab (oracle 19c, flashback on, local_undo_enabled is true), I got A in the end. Flashback completed, but alter pluggable database app_root open failed with ORA-01113: file 59 needs media recovery. Did a few media recoveries, and when the app_root finally opened, the table app_root_tab is back.

upvoted 1 times

kvf

2 years, 5 months ago

B is correct. Do alter pluggable approot open resetlogs - don't recover

upvoted 1 times

...

nobody347

2 years, 9 months ago

B, tested in lab

upvoted 1 times

...

ObserverPL

3 years, 2 months ago

Agree, B

upvoted 1 times

...