1z0-083 Practice Test

1z0-083 Practice Test practice questions, page 5 of 8, with answer review and explanations.

Question 21

A user complains about poor database performance. You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

  1. V$SESSION_EVENT
  2. V$SESSTAT
  3. V$SESSION_WAIT
  4. V$SESSION_WAIT_CLASS
  5. V$SESSION

Question 22

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

  1. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
  2. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
  3. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
  4. System statistics can be gathered only while connected to CDB$ROOT.
  5. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Question 23

Examine this output: Which two are true? (Choose two.)

  1. Any PDB not specified in the plan will be unable to execute statements in parallel.
  2. PDB3 can use all available parallel execution processes at times.
  3. PDB1 is always limited to 40% of the available system resources regardless of demand.
  4. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
  5. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
  6. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Question 24

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

  1. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
  2. root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
  3. The sudo password can be specified in a response file.
  4. root.sh can be executed automatically by the Database installer only by using sudo credentials.
  5. The sudo password must be specified in a response file.
  6. The root password cannot be specified in a response file.

Question 25

Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

  1. Run the SQL Access Advisor.
  2. Run the Memory Advisor for the shared pool.
  3. Run the SQL Tuning Advisor.
  4. Run the Memory Advisor for the Program Global Area.
  5. Run the Memory Advisor for the System Global Area.