Free Oracle 1Z0-060 Exam Dumps Questions & Answers

You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema.
Examine the following steps:
1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (`SH',
`CUSTOMERS') FROM dual statement.
2. Execute the DBMS_STATS.SEED_COL_USAGE (null, `SH', 500) procedure.
3. Execute the required queries on the CUSTOMERS table.
4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (`SH', `CUSTOMERS')
FROM dual statement.
Identify the correct sequence of steps.

• A.  2, 3, 4, 1
• B.  3, 2, 1, 4
• C.  4, 1, 3, 2
• D.  3, 2, 4, 1

Identify three benefits of Unified Auditing.

• A.  Decreased use of storage to store audit trail rows in the database.
• B.  It automatically audits Recovery Manager (RMAN) events.
• C.  It improves overall auditing performance.
• D.  The audit trail cannot be easily modified because it is read-only.
• E.  It guarantees zero-loss auditing.

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKMprivilege to the password file?

• A.  Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to Yes.
• B.  Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• C.  Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• D.  Re-create the password file in the Oracle Database 12c format.
• E.  Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?

• A.  Only DDL commands that resulted in errors are logged in the alert log file.
• B.  None of the data definition language (DDL) statements are logged in the trace file.
• C.  A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
• D.  Only DDL commands that resulted in the creation of new database files are logged.

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

• A.  The buffers are being read into the buffer cache, but some other session is changing the buffers.
• B.  The size of the shared pool is too small.
• C.  Cursors are not being shared.
• D.  There are frequent logons and logoffs.
• E.  A large number COMMITS are being performed.