Online Access Free 1Z0-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.Only DML and DDL statements will be monitored for the session.
• B.Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
• C.Database operations for all sessions will be monitored.
• D.Database operations will be monitored only when they consume a significant amount of resource.
• E.All subsequent statements in the session will be treated as one database operation and will be monitored.

On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON or-orders (customer_id,
sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?

• A.Both the indexes are created and used by the optimizer for queries on the ORDERS table.
• B.Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
• C.Only the ORD_CUSTOMER_IX1 index created.
• D.Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
• E.The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
• F.Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

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

Oracle Data Redaction is active on the SCOTT.EMPtable.
You queried the table twice.
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

Which is guaranteed to be true concerning the redaction policy?

• A.RANDOM redaction is active on the MGR column
• B.RANDOM redaction is active on the HIREDATE column
• C.FULL redaction is active on the SAL column
• D.PARTIAL redaction is active on the MGR column.
• E.PARTIAL redaction is active of the HIREDATE column.

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.