1Z0-060 무료 덤프문제 온라인 액세스

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

• A.Parallel recompilation of Java code
• B.Sequential recompilation of only the stored PL/SQL code
• C.Parallel compilation of only the stored PL/SQL code
• D.Sequential recompilation of any stored PL/SQL code
• E.Parallel recompilation of any stored PL/SQL code
• F.Sequential recompilation of Java code

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

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 TOP-N query is created 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.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.
• D.A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows

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

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

Examine the following parameters for a database instance:

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

• A.DB_16K_CACHE_SZIE
• B.STREAMS_POOL_SIZE
• C.DB_KEEP_CACHE_SIZE
• D.JAVA_POOL_SIZE
• E.SORT_AREA_SIZE
• F.LOG_BUFFER