Online Access Free 1Z1-060 Practice Test

Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (`batch_job' ,
FORCED_TRACKING => `Y');
Which two statements are true?

• A.Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
• B.All subsequent statements in the session will be treated as one database operation and will be monitored.
• C.Only DML and DDL statements will be monitored for the session.
• D.Database operations for all sessions will be monitored.
• E.Database operations will be monitored only when they consume a significant amount of resource.

Which two are true concerning a multitenant container database with three pluggable database?

• A.All administration tasks must be done to a specific pluggable database.
• B.The pluggable databases are patched together.
• C.The pluggable databases increase patching time.
• D.Pluggable databases are only used for database consolidation.
• E.The pluggable databases reduce administration effort.

Your database supports a DSS workload that involves the execution of complex queries:
Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

• A.Run the Automatic Workload Repository Monitor (ADDM).
• B.Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
• C.Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
• D.Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task?

• A.RMAN CONVERT command
• B.Data Pump Export and import
• C.Conventional Export and Import
• D.The BACKUP AS COPY DATABASE . . . command of RMAN
• E.DBMS_FILE_TRANSFER with transportable tablespace

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

• A.Active Session History (ASH) report
• B.Compare Period ADDM report
• C.Taking a new snapshot and comparing it with a preserved snapshot
• D.AWR Compare Period report