Question 1

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 2

Which two are true about creating RMAN backups for an Oracle container database?

Options :

A : Online Redo Log backups can be created while connected to CDB$ROOT

B : Control file backups can be created while connected to CDB$ROOT.

C : The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.

D : Archived Redo Log backups can be created while connected to PDB

E : Control file backups can not be created while connected to a PDB

Answer: A,B

Question 3

Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?

Options :

A : It has the same common users defined as does CDB1.

B : It has only local roles.

C : It has the same number of roles as CDB1.

D : Service PDB1 is created for remote logins to PDB1.

E : It is in mount state after creation.

F : It has no local users.

Answer: A,B,D

Question 4

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

Options :

A : FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.

B : FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.

C : FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.

D : FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.

E : FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.

F : FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Answer: A,B

Question 5

Examine this configuration: While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/ controlfile02.ctl'is accidentally deleted. To recover from this critical failure, you execute these commands:
What will be the outcome?

Options :

A : It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'

B : It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.

C : It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'

D : It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.

E : It will fail because there is no autobackup of the controlfiles.

Answer: C

Higher Test Marks with Free Online 1Z0-083 Exam Practice

Buying Options: