Online Access Free 1Z1-060 Exam Questions

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?

• A.It detects any configuration change that caused a performance difference in both time periods.
• B.It identifies any workload change that caused a performance difference in both time periods.
• C.It shows the resource usage for CPU, memory, and I/O in both time periods.
• D.It gives information about statistics collection in both time periods.
• E.It shows the difference in the size of memory pools in both time periods.
• F.It detects the top wait events causing performance degradation.

In your Oracle 12c database, you create two roles: AUDITORand AUDIT_ADMIN. You then execute the following commands:

To create a privilege analysis policy for the AUDIT_ADMINrole, you execute the following PL/SQLblock:

Which statement is correct about the procedure?

• A.It always captures the use of the CREATE VIEW and CREATE TABLE privileges.
• B.It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT module is used.
  PAYABLE
• C.It always captures the use of the privileges exercised through the AUDITOR and AUDIT_ADMIN roles.
• D.It captures the use of the privileges used through the AUDIT_ADMIN and AUDITOR roles when the module is used.
  ACCOUNT PAYABLE

Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

• A.Exadata I/O
• B.Parallel server limit
• C.CPU
• D.Maximum Undo per consumer group
• E.Maximum Idle time
• F.Local file system I/O

Which three are true about the large pool for an Oracle database instance that supports shared server connections?

• A.Contains stack space
• B.Allocates memory for shared and private SQL areas
• C.Contains a cursor area for storing runtime information about cursors
• D.Contains a hash area performing hash joins of tables
• E.Allocates memory for RMAN backup and restore operations

You execute the following commands to audit database activities:

Which statement is true about the audit record that generated when auditing after instance restarts?

• A.One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
• B.One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
• C.One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
• D.One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
• E.One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.