Question 1

Which three statements are true about Flashback Data Archive?

Options :

A : To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

B : To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database

C : While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.

D : A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

E : Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

Answer: A,C,D

Question 2

Choose three. Which three are true about recovering tables using RMAN?

Options :

A : RMAN can recover tables owned by the SYSTEM user.

B : RMAN can recover tables owned by the SYS user.

C : RMAN can recover tables in the SYSTEM tablespace.

D : RMAN always uses an auxiliary instance.

E : RMAN can recover a table after a DDL operation has altered the table structure

F : RMAN can recover tables in the SYSAUX tablespace.

G : RMAN can recover tables in a standby database.

Answer: A,D

Question 3

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)

Options :

A : CDB1 and CDB2 must be in shared undo mode.

B : A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C : All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D : Cloning HR_ROOT automatically clones HR_PDB1.

E : The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.

Answer: A,D

Question 4

Examine the RMAN command: RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE sbt; ALLOCATE CHANNEL c2 DEVICE TYPE sbt; ALLOCATE CHANNEL c3 DEVICE TYPE sbt; BACKUP INCREMENTAL LEVEL = 0 (DATAFILE 1,4,5 CHANNEL c1) (DATAFILE 2,3,9 CHANNEL c2) (DATAFILE 6,7,8 CHANNEL c3); SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } Which statement is true about the command?

Options :

A : It uses multisection backup.

B : It uses parallelization for the backup set.

C : It uses asynchronousI/O for the backup.

D : It creates compressed backup sets.

Answer: B

Question 5

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

Options :

A : Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces

B : The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

C : SPFILE backups can be created while connected to an application root PDB.

D : The BACKUP DATABASE PLUS ARCHIVE LOG command will back up archive logs when RMAN is connected to a PDB.

E : The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

Answer: A,B

Free 1Z0-083 Mock Exam – Practice Online Confidently

Buying Options: