1z1-064 by Oracle Valid Free Exam Practice Test

Question 1

Which two statements are true about gathering statistics? (Choose two.)

A. If concurrent statistics gathering is done by using parallel execution, the Resource Manager should be used for efficient resource management. B. For each session that is accessing a global temporary table, the optimizer uses only the shared statistics. C. If an application has only SQL statements with bind variables, it is better to drop existing histograms, disable creation of histograms, and allow the optimizer to select the best execution plans. D. If end users query newly inserted data, it is possible to get a suboptimal execution plan even if the automatic statistics gathering job is enabled.

Correct Answer: A,B

Question 2

Which four statements are true about Consolidated Database Replay?

A. The number of replay clients must be equal to the number of captured workloads. B. Multiple database workloads can be replayed only if both the capture and replay databases are on the same operating system. C. Multiple database workloads can be replayed only if both the capture and replay databases have the same database version. D. Multiple replay schedules can be defined and any existing replay schedules can also be used. E. The replay starts simultaneously for all participating workload captures if no order is defined in the replay schedule. F. A subset of the captured workload can be replayed on a test system. G. Consolidated workloads from one or multiple databases can be replayed concurrently on a single system.

Correct Answer: D,E,F,G

Question 3

You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain about poor performance of these queries.
You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar.
Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)

A. Configure the KEEP pool and cache the queried tables used in the KEEP pool. B. Set the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value. C. Use bind variables for similar queries instead of literals. D. Set the RESULT_CAHCE_MODE parameter to FORCE for the instance. E. Use the result cache hint in the queries.

Correct Answer: D,E

Question 4

In your database, the locally managed tablespace, USERS, has the default space usage alert set to 85% for the warning level and 97% for the critical level.
Which two statements are true? (Choose two.)

A. Alerts are triggered when the space usage reaches the warning level, again when it reaches the critical level, and yet again when the space usage falls below the critical level. B. Alert settings for the warning and critical levels must be disabled before taking the USERS tablespace offline. C. Alerts that are triggered are automatically recorded in DBA_ALERT_HISTORY after they are cleared. D. Alerts are recorded in both Oracle Enterprise Manager Cloud Control and DBA_OUTSTANDING_ALERTS only when the critical threshold is exceeded.

Correct Answer: B,D

Question 5

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. A subsequent execution of the query in this session is likely to undergo a soft parse. 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 will undergo a hard parse. D. The second execution of the query was hard parsed because extended statistics were collected after the first execution of the query. E. No statistics were collected during the first execution of the query.

Correct Answer: A,B

Question 6

You want to enable the Database Smart Flash Cache feature on your database. For this purpose, you configure two flash devices: /dev/sdj and /dev/sdk, with sizes of 64 GB and 32 GB, respectively.
Examine the parameters set for your database instance:

How would you make sure that the database uses these devices for Database Smart Flash Cache?

A. by disabling Automatic Memory Management, setting SGA_TARGET to 96G, and setting the required memory that you want to set for SGA B. by setting the value of the DB_FLASH_CACHE_SIZE parameter to 8G C. by setting the DB_FLASH_CACHE_SIZE parameter to 86G and the MEMORY_TARGET parameter to 112G D. by configuring the DB_FLASH_CACHE_SIZE parameter and making sure that all flash devices are of the same size E. by setting the value of the DB_FLASH_CACHE_SIZE parameter to 64G, 32G

Correct Answer: E

Question 7

Examine the query and its output:

Which two statements are true? (Choose two.)

A. 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. B. 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. C. Session 4208 is either idle or experiencing poor response time due to a network or resource bottleneck on the client process. D. Session 4208 is definitely idle and should be killed to free network resources. E. Session 2832 had to wait 2029 seconds for a message to arrive because of a network bottleneck.

Correct Answer: B,E

Oracle Database 12c: Performance Management and Tuning - 1z1-064 Exam Practice Test