Free Oracle 1Z1-060 Exam Dumps Questions & Answers

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.  Sequential recompilation of any stored PL/SQL code
• B.  Sequential recompilation of Java code
• C.  Parallel recompilation of any stored PL/SQL code
• D.  Parallel recompilation of Java code
• E.  Parallel compilation of only the stored PL/SQL code
• F.  Sequential recompilation of only the stored PL/SQL code

You notice that the performance of your production 24/7 Oracle database significantly degraded.
Sometimes you are not able to connect to the instance because it hangs.
You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

• A.  Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
• B.  Enable Memory Access Mode, which reads performance data from SGA.
• C.  Use emergency monitoring to fetch data directly from SGA analysis.
• D.  Run ADDM in diagnostic mode.
• E.  Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

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.  A large number COMMITS are being performed.
• C.  There are frequent logons and logoffs.
• D.  The size of the shared pool is too small.
• E.  Cursors are not being shared.

Which three operations can be performed as multipartition operations in Oracle?

• A.  Drop partitions of a list partitioned table
• B.  Merge partitions of a reference partitioned index
• C.  Merge partitions of a list partitioned table
• D.  Coalesce partitions of a hash-partitioned global index.
• E.  Move partitions of a range-partitioned table
• F.  Rename partitions of a range partitioned table

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