Download Oracle.1z0-064.PracticeTest.2018-11-02.50q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-064 |
| Exam Name: | Oracle Database 12c: Performance Management and Tuning |
| Date: | Nov 02, 2018 |
| File Size: | 2 MB |
| Downloads: | 1 |
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
