Oracle 1z1-064 Value Pack (Frequently Bought Together)

Examine the query and its output:

Which two statements are true? (Choose two.)

• A. Session 2832 had to wait 2029 seconds for a message to arrive because of a network bottleneck.
• B. Session 4208 is either idle or experiencing poor response time due to a network or resource bottleneck on the client process.
• C. Session 4208 is definitely idle and should be killed to free network resources.
• D. Session 3346 is in wait state because either it is waiting to update a row that is locked by another session or another session is trying to insert the same key value in a UNIQUE index.
• E. Session 3346 is in wait state because it wants to lock a row in a block in which other sessions have already locked rows, and there is no free ITL slot available in this block.

Your database supports an OLTP workload where a large number of syntactically similar queries are executed. Examine the Instance Efficiency Percentages in the Automatic Workload Repository (AWR) report of the last hour:

Which two inferences can be drawn from the report?

• A. Cursors are not getting shared in the library cache.
• B. The database buffer cache is undersized and is causing contention.
• C. The optimizer is waiting for resources during parsing of the queries.
• D. The CPU is spending more time on pinning cursors in the library cache.

You are administering a database that supports multiple applications, which make dedicated connections to the database instance by using different services.
You execute the command to enable tracing of the ORCL1 service:

Which two statements are true? (Choose two.)

• A. A single trace file is generated for all sessions mapped to the ORCL1 service.
• B. SQL trace is not enabled for the service because a module name is not specified.
• C. A SQL trace file is generated for each session that maps to the ORCL1 service.
• D. A SQL trace file is generated for each of the modules using the ORCL1 service.
• E. SQL trace is enabled for all modules and actions for sessions mapped to the ORCL1 service.

Which two statements are true about Compare Period ADDM? (Choose two.)

• A. It is automatically invoked whenever the AWR Compare Period report is invoked.
• B. It verifies if there is any change in the workload or average resource consumption by the SQL executed during the two specified time periods, to ensure 100% accuracy.
• C. It can be used to create a comparison report between the Database Replay workload capture report and the replay report.
• D. It is automatically invoked whenever ADDM is run by default.

Your database supports a DSS workload. In an application, a few complex queries that contain multiple functions and expressions are using materialized views. You notice that some queries are performing poorly because they are not benefiting from query rewrites.
Which three actions would you take to improve the performance of queries? (Choose three.)

• A. Use the DBMS_ADVISOR.QUICK_TUNE procedure to analyze queries based on the usage of query rewrite with materialized views.
• B. Create an STS and submit as input to the SQL Performance Analyzer to get recommendations about improving the performance of queries.
• C. Use the DBMS_MVIEW.EXPLAIN_REWRITE procedure to analyze why a query failed to rewrite.
• D. Use the DBMS_ADVISOR.TUNE_MVIEW procedure to get recommendations about rewriting materialized views.
• E. Create a SQL Tuning Set (STS) and submit as input to the SQL Access Advisor to generate recommendations about query rewrite and fast refresh for materialized views.