1z0-060 Free Practice Test

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1.Create a policy to capture the privilege used by a user for privilege analysis.
2.Generate a report with the data captured for a specified privilege capture.
3.Start analyzing the data captured by the policy.
4.Revoke the unused privileges.
5.Compare the used and unused privileges’ lists.
6.Stop analyzing the data.
Identify the correct sequence of steps.

1. A. 1, 3, 5, 6, 2, 4
2. B. 1, 3, 6, 2, 5, 4
3. C. 1, 3, 2, 5, 6, 4
4. D. 1, 3, 2, 5, 6, 4
5. E. 1, 3, 5, 2, 6, 4

Correct Answer: B

Examine the parameters for your database instance:
<>

1. A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
2. B. The optimizer can re optimize a query only once using cardinality feedback.
3. C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
4. D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enable
5. E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Correct Answer: ACD

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?

1. A. Use Oracle Managed Files (OMF).
2. B. Specify the SEED FILE_NAME_CONVERT clause.
3. C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
4. D. Specify the DB_FILE_NAMECONVERT initialization parameter.
5. E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

Correct Answer: ABC

Which two statements are true about variable extent size support for large ASM files?

1. A. The metadata used to track extents in SGA is reduce
2. B. Rebalance operations are completed faster than with a fixed extent size
3. C. An ASM Instance automatically allocates an appropriate extent size.
4. D. Resync operations are completed faster when a disk comes online after being taken offline.
5. E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

Correct Answer: AC

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?

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

Correct Answer: B