Passing exam with 1Z0-060 latest training materials

You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

• A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.
• B. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
• C. A TOP-N query is created during execution and a filter is added to the query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.
• D. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.

You notice a performance change in your production Oracle 12c database and you want to know what change caused 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 gives information about statistics collection in both time periods.
• B. It detects any configuration 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 detects the top wait events causing performance degradation.
• E. It identifies any workload change that caused a performance difference in both time periods

You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

• A. Recovery the table sing Database Point In Time Recovery.
• B. Recover the table using Automated Tablespace Point In Time Recovery.
• C. Recover the table using traditional Tablespace Point In Time Recovery.
• D. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
  EXAM_RESULTS; connected as the OCP user.
• E. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
  OCP.EXAM_RESULTS; connected as SYSTEM.

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges:

Which statement is true about the common user created by the command?

• A. The user can connect to the root and all PDBs.
• B. The user can connect only to the root database.
• C. The user cannot connect any database because the CONTAINER clause is missing.
• D. The user cannot connect to any database because the CREATE ANY SESSION privilege must be granted.

You connect to the root container of a multitenant container database (CDB) with SYSDBA privileges by using SQL*Plus.
The CDB has several pluggable databases (PDBs) open in read/write mode.
There are ongoing transactions in both the CDB and the PDBs.
What happens after issuing the SHUTDOWN TRANSACTIONAL statement?

• A. the shutdown proceeds immediately
• B. the statement results in an error because there are open PDBs
• C. the shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
• D. the shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled back.