Free Oracle 1z0-064 Exam Dumps Questions & Answers

You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads.
Which action would you take to achieve this? (Choose the best answer.)

• A.  Create database services for the applications, assign individual sessions created by the applications to consumer groups, and then set a priority.
• B.  Create database services for the applications, create a job class associated with the service, batch the jobs, and then create jobs by using the job class.
• C.  Assign profiles to users running the batch operations and make sure that a priority is set for resource limits in profiles.
• D.  Create database services for the applications and assign different profiles to the sessions to set a relative priority for resource usage.

You execute this query twice in a session:

Then you query V$SQL_SHARED_CURSOR for details about child cursors as shown.

Which two statements are true? (Choose two.)

• A.  The second execution of the query was hard parsed because extended statistics were collected after the first execution of the query.
• B.  The second execution of the query was hard parsed because the estimated cardinality was inaccurate.
• C.  A subsequent execution of the query in this session is likely to undergo a soft parse.
• D.  No statistics were collected during the first execution of the query.
• E.  A subsequent execution of the query in this session will undergo a hard parse.

Which two result in the least internal fragmentation within segments and the least external fragmentation within tablespaces? (Choose two.)

• A.  dictionary managed tablespaces
• B.  locally managed tablespaces with uniform extent size
• C.  automatic segment space managed segments
• D.  freelist managed segments with one freelist
• E.  freelist managed segments with multiple freelists
• F.  locally managed tablespaces that were converted from dictionary managed tablespaces

Examine the Load Profile section of an AWR report:

Which two inferences can you derive from the details in this section? (Choose two.)

• A.  The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite often.
• B.  The values for DB Time and DB CPU imply that the database had a high proportion of idle time during the specified snapshot interval.
• C.  The values for Logical reads and Physical reads imply that the number of disk reads per second was less than the total number of DB block reads and consistent gets per second.
• D.  The values for SQL Work Area and User calls imply that only sort-based operations were performed.
• E.  The values for Redo size and Block changes imply that only updates were performed by transactions.

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.  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.
• B.  Use the DBMS_MVIEW.EXPLAIN_REWRITE procedure to analyze why a query failed to rewrite.
• C.  Use the DBMS_ADVISOR.TUNE_MVIEW procedure to get recommendations about rewriting materialized views.
• D.  Create an STS and submit as input to the SQL Performance Analyzer to get recommendations about improving the performance of queries.
• E.  Use the DBMS_ADVISOR.QUICK_TUNE procedure to analyze queries based on the usage of query rewrite with materialized views.