Question 1

Choose the best answer. Examine this configuration:
1. CDB1 is a container database.
2. There are several pluggable databases (PDBs) in CDB1.
5. Each PDB has several tables with referential integrity constraints.
6. FLASHBACK DATABASE is ON.
7. 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?

Options :

A : restore and recover database

B : flashback transaction

C : flashback database

D : flashback table and transaction

E : flashback table

Answer: C

Question 2

You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)

Options :

A : Flashback logs are not archived.

B : Flashback logs are maintained in redo log files.

C : Flashback logs are maintained in the Flash Recovery Area.

D : Flashback logs are used to maintain Flashback Database related errors.

E : Flashback logs need to be cleared manually after you disable Flashback Database.

Answer: A,C

Question 3

choose three Which three RMAN persistent settings can be set explicitly?

Options :

A : SPFILE backup duplexing

B : control file auto backup formats

C : archive log deletion policy

D : image copy duplexing

E : redo log backup duplexing

F : archive log backup duplexing

Answer: A,B,C

Question 4

Choose two. Which two are true about various Oracle security and auditing capabilities?

Options :

A : Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.

B : Application-common TSDP policies are always container specific.

C : Application-common OLS policies can be created only if all the PDBs in the application container are closed.

D : Unified auditing can be automatically synchronized to all application PDBs in an application container.

E : Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.

Answer: A,D

Question 5

T schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?

Options :

A : Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

B : Recovery catalog is resynchronized with the control files of the registered databases.

C : Imported databases are unregistered from the RC11 catalog.

D : Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

E : All databases registered in the RC11 catalog are registered in the RC12C catalog.

Answer: A,D