Free Access to Oracle.1Z0-083.v2025-12-01.q154 with Valid Practice Test (Page 17)

Question 76

Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?

A.Test tuned SQL statements one at a time for all statements in the application.
B.Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
C.Test the application as a whole using tuned SQL statements.
D.Tune individual SQL statements using the SQL Tuning Advisor.
E.Identify poorly tuned SQL statements using the SQL Tuning Advisor.
F.Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.

Question 77

Which two are true about the Oracle dataabsemethodology? (Choose two.)

A.Tuning activities should stop once the user is satisfied with performance.
B.The alert log should be used to find the database and instance areas most in need of tuning.
C.The database instance memory should always be tuned before tuning any file systems.
D.Tuning activities should stop onceagreed service levels for performance have been met.
E.SQL statements should always be tuned before tuning any file systems.
F.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

Question 78

Which two are true about gathering optimizer statistics? (Choose two.)

A.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
B.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
C.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
D.System statistics can be gathered only while connected to CDB$ROOT.
E.Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Question 79

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?

A.PDB2 will be opened READ WRITE.
B.PDB1 will be opened READ WRITE.
C.PDB$SEED will be MOUNTED
D.PDB1 will be MOUNTED.
E.PDB2 will be MOUNTED.
F.PDB$SEED will be opened READ ONLY.

Question 80

Which two are true about instance recovery?

A.It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
B.It is performed automatically while the database remains in mount state. Then the database is opened.
C.Setting fast_start_mttr_target to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.
D.It is not possible if an archived log is missing.
E.It is performed by the Recovery Writer (rvwr) background process.
F.Setting fast_start_mttr_target to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

Question 76

Question 77

Question 78

Question 79

Question 80

Download PDF File