Question 1

Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

Options :

A : Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

B : After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME

C : Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.

D : The new extended data type capability must be enabled by running the utlrp.sql script

E : The Oracle Application Express configuration should be updated after upgrading Oracle Database.

Answer: A,B,E

Question 2

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

Options :

A : cloning a remote container database in interactive mode

B : cloning a remote pluggable database in silent mode

C : relocating a remote pluggable database in interactive mode

D : relocating a remote container database in silent mode

E : cloning a remote container database in silent mode

F : relocating a remote pluggable database in silent mode

G : relocating a remote container database in interactive mode.

Answer: A,B

Question 3

Which two are true about Oracle instance recovery? (Choose three.)

Options :

A : Recovery begins from the beginning of the CURRENT redo log group.

B : Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

C : Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.

D : Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.

E : Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).

F : Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.

Answer: A

Question 4

choose two Which two are true about RMAN image copies?

Options :

A : They can only be written to disk.

B : They can be encrypted using Transparent Data Encryption (TDE).

C : They can be used as a level 0 incremental backup.

D : They can be used as a level 1 incremental backup.

E : They are the only backup option available for databases in NOARCHIVELOG mode.

Answer: A,C

Question 5

Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands: $ export ORACLE_SID=CDB1 $ sqlplus / as sysdba SQL> STARTUP ....... Database opened. SQL> SHOW PDBS CON_ID CON_NAME --------------------------------------------------------------------OPEN MODE READ ONLY NO MOUNTED MOUNTED SQL> ALTER PLUGGABLE Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE; Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE; Pluggable database altered. SQL> ALTER PLUGGABLE A DATABASE pdb2 OPEN; Pluggable database altered. CDB1 is then restarted. Which three are true?

Options :

A : PDB2 will be opened READ WRITE.

B : PDB1 will be opened READ WRITE.

C : PDB1 will be MOUNTED.

D : PDB$SEED will be opened READ ONLY.

E : PDB$SEED will be MOUNTED

F : PDB2 will be MOUNTED.

Answer: A,B,D