File Info
| Exam | Oracle Database 12c: Performance Management and Tuning |
| Number | 1z0-064 |
| File Name | Oracle.1z0-064.PracticeTest.2018-11-02.50q.tqb |
| Size | 2 MB |
| Posted | Nov 02, 2018 |
| Download | Oracle.1z0-064.PracticeTest.2018-11-02.50q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
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.)
- setting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors
- coding the application such that a frequently executed statement is parsed only once and executed repeatedly as required
- setting the CURSOR_SHARING parameter to EXACT
- avoiding the granting of privileges on objects associated with cursors during peak load
- enabling Automatic Memory Management and allocating at least 50% of the available memory for SHARED_POOL_SIZE
- configuring shared server connections
Correct answer: CE
Explanation:
Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm
Question 2
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 single trace file is generated for all sessions mapped to the ORCL1 service.
- SQL trace is enabled for all modules and actions for sessions mapped to the ORCL1 service.
- An SQL trace file is generated for each session that maps to the ORCL1 service.
- An SQL trace file is generated for each of the modules using the ORCL1 service.
- SQL trace is not enabled for the service because a module name is not specified.
Correct answer: AC
Question 3
In which three situations can dynamic statistics be used? (Choose three.)
- when the sampling time is a small fraction of the total time for a query
- when an execution plan is suboptimal because of complex predicates
- when extended statistics are not available for SQL statements that use complex predicates
- when a query is on a partitioned table with a global index
- when index statistics are missing on a column that is used in SQL statements with highly selective filters
Correct answer: BCD
Explanation:
Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL341 Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL341
