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 13
Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)
A. Executing SQL statements in an SQL Tuning Set (STS) on a test database by using database links to the production database.
B. Generating only execution plans on a test database without actually running SQL statements.
C. Generating an execution plan and statistics for selective SQL statements captured in an STS
D. Loading performance data and execution plans from an STS.
E. Generating both execution plans and statistics for each SQL statement in an STS by actually running the SQL statements on a test database.
Answer: BDE
Explanation:
https://docs.oracle.com/cd/E11882_01/server.112/e41481/spa_pre_change.htm#RATUG1
QUESTION 14
Which two statements are true about server-generated alerts? (Choose two.)
A. They are always logged in the alert log.
B. They are written to a trace file if the TRACE_ENABLED initialization parameter is set to TRUE.
C. They are generated only when the STATISTICS_LEVEL initialization parameter is set to ALL.
D. They can be generated for user-defined metric thresholds.
E. They appear in the DBA_ALERT_HISTORY view whenever corrective action is taken for an alert.
Answer: DE
QUESTION 15
You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%. Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)
A. the alert log
B. Oracle Enterprise Manager Cloud Control
C. DBA_ALERT_HISTORY
D. DBA_OUTSTANDING_ALERTS
E. DBA_ACTIVE_SESSION_HISTORY
F. DBA_THRESHOLDS
Answer: AF
QUESTION 16
Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)
A. DB time cannot exceed the total elapsed time (walk clock time) since the database instance started.
B. DB time cannot exceed the maximum number of concurrent sessions multiplied by the actual elapsed time for each session.
C. DB time includes the time spent on client processes and background processes.
D. Reducing DB time allows a database instance to support more user requests by using the same resources.
E. DB time is always greater than or equal to the DB CPU time.
Answer: DE
QUESTION 17
Examine the output of the query executed to diagnose the reason for performance degradation of queries:
Which three factors will you investigate further to identify the cause of the performance degradation? (Choose three.)
A. Check the number of disk sorts.
B. Check for the causes of the full table scans.
C. Check the number of chained or migrated rows.
D. Check for the causes of the short table scans.
Answer: ABC
QUESTION 18
Which two result in the latest fragmentation within segments and the least external fragmentation within tablespaces? (Choose two.)
A. automatic segment space managed segments
B. locally managed tablespaces with uniform extent size
C. freelist managed segments with one freelist
D. dictionary managed tablespace
E. locally managed tablespaces that were converted from dictionary managed tablespaces
F. freelist managed segments with multiple freelist
Answer: AB
Explanation:
http://docs.oracle.com/cd/B19306_01/server.102/b14220/logical.htm
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