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?

• A.V$SESSION_EVENT
• B.V$SESSTAT
• C.V$SESSION_WAIT
• D.V$SESSION_WAIT_CLASS
• E.V$SESSION

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:

To recover from this critical failure, you execute these commands:

What will be the outcome?

• A.Option
  
• B.Option
  
• C.Option
  
• D.Option
  
• E.Option
  

Comment: *

Name: *

Email: *

Verification: *

Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

• A.Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
• B.Set only the PDB_FILE_NAME_CONVERT parameter.
• C.Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• D.Enable only OMF.
• E.Add only the CREATE_FILE_DEST clause to the statement.
• F.Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

• A.A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
• B.Existing Oracle Database instances must be shut down before starting the upgrade.
• C.The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
• D.Only the grid user can perform the upgrade.
• E.An existing Oracle base can be used.
• F.The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

• A.Create an adaptive execution plan for each of the regressed statements
• B.Create SQL plan directives for each of the regressed statements.
• C.Use the SQL Access Advisor for each of the regressed statements.
• D.Use The SQL Tuning Advisor for each of the regressed statements.

Comment: *

Name: *

Email: *

Verification: *