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

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 3

You have configured RMAN SBT channels to write backups to medi
a. You then take an RMAN backup by using this command: Which three are true? (Choose three.)

Options :

A : The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

B : The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

C : All archive logs created after this backup are kept for two years.

D : The SPFILE is included in the self-contaied archival backup.

E : The control file is included in the self-contained archival backup.

F : The restore point is a label for the system change number (SCN) before the archival backup was taken.

Answer: A,B,D

Question 4

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

Options :

A : orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

B : root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

C : The sudo password can be specified in a response file.

D : root.sh can be executed automatically by the Database installer only by using sudo credentials

E : The sudo password must be specified in a response file.

F : The root password cannot be specified in a response file.

Answer: A

Question 5

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?

Options :

A : Enable Memory Access Mode, which reads performance data from SGA.

B : Use emergency monitoring to fetch data directly from SGA for analysis.

C : Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

D : Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

E : Run ADDM in diagnostic mode.

Answer: B