PassLeader now are offering 100% pass ensure 1Z0-064 dumps! All 1Z0-064 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-064 VCE dumps and PDF dumps: https://www.passleader.com/1z0-064.html (90 Q&As)
BTW: Download PassLeader 1Z0-064 dumps from Google Drive for free: https://drive.google.com/open?id=1ZJ8IAgupu8ZxjCosUsnrIai3zsPlhNd2
QUESTION 43
Which two statements are true regarding the database control file? (Choose two.)
A. Control files must be multiplexed on different disks.
B. A database must have a minimum of two control files.
C. It is used to create the instance when the database is started.
D. The locations of control files are stored in the initialization parameter files.
E. It stores the current names and locations of the d.ita files and redo log files.
Answer: DE
QUESTION 44
You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight. How would you achieve this? (Choose the best answer.)
A. Create AWR baselines.
B. Create SQL plan baselines.
C. Create repeating baseline templates.
D. Create database services and make sure that user connections use them to connect to the database instance.
E. Create a single baseline template.
Answer: D
QUESTION 45
You are administering a database that supports an OLTP workload. CURSOR_SHARING is set to EXACT for the instance. An application is frequently executing almost identical queries that vary in literal values in the WHERE clause, causing a large number of hard parses to occur. Which four statements would be true if you use bind variables for these queries? (Choose four.)
A. Mutex contention in the library cache will be reduced.
B. The optimizer will use one parent cursor and one child cursor for each SQL statement with different literal values.
C. Hard parses will be reduced for the queries.
D. The optimizer will use bind peeking and subsequent execution of the queries will always generate the same plans irrespective of the cardinality.
E. The optimizer will generate the same plan for all bind values if no histograms exist on the columns used in the WHERE clause of these queries.
F. The optimizer will use bind peeking and use the literal value to determine the execution plan for these queries.
Answer: ACDE
QUESTION 46
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 enabled for all modules and actions for sessions mapped to the ORCL1 service.
C. An SQL trace file is generated for each session that maps to the ORCL1 service.
D. An SQL trace file is generated for each of the modules using the ORCL1 service.
E. SQL trace is not enabled for the service because a module name is not specified.
Answer: BC
QUESTION 47
Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.)
A. setting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors
B. coding the application such that a frequently executed statement is parsed only once and executed repeatedly as required
C. setting the CURSOR_SHARING parameter to EXACT
D. avoiding the granting of privileges on objects associated with cursors during peak load
E. enabling Automatic Memory Management and allocating at least 50% of the available memory for SHARED_POOL_SIZE
F. configuring shared server connections
Answer: BE
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm
QUESTION 48
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 an 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. Create an STS and submit as input to the SQL Performance Analyzer to get recommendations about improving the performance of queries.
D. Use the DBMS_ADVISOR.TUNE_MVIEW procedure to get recommendations about rewriting materialized views.
E. Use the DBMS_ADVISOR.QUICK_TUNE procedure to analyze queries based on the usage of query rewrite with materialized views.
Answer: ACE
PassLeader now are offering 100% pass ensure 1Z0-064 dumps! All 1Z0-064 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-064 VCE dumps and PDF dumps: https://www.passleader.com/1z0-064.html (90 Q&As)
BTW: Download PassLeader 1Z0-064 dumps from Google Drive for free: https://drive.google.com/open?id=1ZJ8IAgupu8ZxjCosUsnrIai3zsPlhNd2