Oracle 1z0-064 問題集

質問 1：
Which two statements are true about wait events?
A. Wait event countries are incremented by the server process that waits.
B. A single resource wait event may be recorded as multiple waits, depending on the number of session timeouts during that wait.
C. A wait event can be defined in multiple wait classes.
D. Wait event statistics are cumulatively collected only at the instance level.
E. Wait events for an instance include statistics for both background and foreground processes.
正解：A,C

質問 2：
Examine the query and its output:

Which two inferences can be definitely derived from this output? (Choose two.)
A. The multiblock factor is 8 for this I/O but it could vary for the other I/O events.
B. The session has completed performing a full table scan.
C. The db file scattered read event has occurred 104 times in this session for file# 12.
D. The SQL statements in this session are performing excessive disk reads.
正解：C,D

質問 3：
For your database some users complain about not being able to execute transactions. Upon investigation, you find that the problem is caused by some users performing long-running transactions that consume huge amounts of space in the UNDO tablespace.
You want to control the usage of the UNDO tablespace only for these user sessions.
How would you avoid the issue from repeating in future? (Choose the best answer.)
A. Set the threshold for UNDO tablespace usage for the users.
B. Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.
C. Implement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.
D. Create a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.
正解：C

質問 4：
Which two statements are true about Compare Period ADDM? (Choose two.)
A. It is automatically invoked whenever ADDM is run by default.
B. It can be used to create a comparison report between the Database Replay workload capture report and the replay report.
C. It verifies if there is any change in the workload or average resource consumption by the SQL executed during the two specified time periods, to ensure 100% accuracy.
D. It is automatically invoked whenever the AWR Compare Period report is invoked.
正解：A,B

質問 5：
Examine the partial TKPROF output for an SQL statement:

Which two inferences can definitely be made from this output? (Choose two.)
A. Another transaction held a shared lock on the table, thereby causing a significant delay.
B. Array fetch operations were not performed for this query.
C. No hard parse was performed for this query.
D. An uncommitted transaction made a series of updates to the NAME_ID column just before the execution of this query.
E. The number of logical I/Os is almost equal to the number of physical I/Os.
正解：A,C

質問 6：
You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads.
Which action would you take to achieve this? (Choose the best answer.)
A. Create database services for the applications and assign different profiles to the sessions to set a relative priority for resource usage.
B. Create database services for the applications, create a job class associated with the service, batch the jobs, and then create jobs by using the job class.
C. Create database services for the applications, assign individual sessions created by the applications to consumer groups, and then set a priority.
D. Assign profiles to users running the batch operations and make sure that a priority is set for resource limits in profiles.
正解：A