Oracle 1Z0-054 問題集

質問 1：
View the Exhibit and examine the query based on the DBA_THRESHOLDS view and its partial
output :
Which observation about the output is correct?

A. Database Time SpentWaiting(%) triggers an alert when more than 30% of the DB time per second for three consecutive seconds is spent on lock waits.
B. Blocked User Session Count triggers an alert based on the ELAPSED_TIME_PER_CALL and DB_TIME_WAITING metrics collection per minute.
C. Logons Per Sec triggers an alert when the number of users logging on in an interval of one second is equal to or greater than 100.
D. Average Users Waiting Counts triggers an alert when the count is more than 30 for 3 consecutive 1 minute intervals and is related to the log file sync wait event.
正解：D

質問 2：
Identify the type of recommendation that can automatically be implemented by the Automatic Tuning Advisor as part of automatic SQL tuning task?
A. recommendation about effective indexing
B. recommendation for SQL profiles
C. recommendation about stale or no statistics
D. recommendation about the structure of SQL statements
正解：B

質問 3：
The columns CUST_CITY, CUST_STATE_PROVINCE, and COUNTRY_ID are frequently used together in the WHERE clause of the queries. The CUSTOMERS table is a big table with 20 GB of data. You notice that the selectivity for these three columns varies from the selectivity that the optimizer calculates. What would you recommend to influence the selectivity calculated by the optimizer?
A. using the DBMS_STATS.CREATE_EXTENDED_STATSfunction to create a virtual column and the DBMS_STATS.GATHER_TABLE_STATS procedure to collect statistics on the virtual column
B. updating histogram statistics for these columns by using the DBMS_STATS.GATHER_TABLE_STATS procedure
C. creating function-based indexes by concatenating all the columns
D. using the DBMS_STATS.CREATE_EXTENDED_STATSfunction to create a virtual column and create index on the virtual column
正解：A

質問 4：
You work in an online transaction processing (OLTP) environment and users are experiencing slow response time on their queries. These users connect as FINANCE to run their application and run hundreds of sessions. Your investigation shows that there is lot of I/O contention happening on only one temporary tablespace and there is no load on other temporary tablespaces. View the Exhibit and examine the details. After some time you observed that sort operations are running out of temporary space.
What would be a long-term solution?

A. Create and assign temporary tablespace group to this user ID.
B. Increase the size of the temporary tablespace assigned to this user ID.
C. Change the temporary tablespace assigned to this user ID.
D. Make the bigger temporary tablespace the default temporary tablespace I
正解：A

質問 5：
While reviewing the Top 5 Timed Events section in the Automatic Workload Repository report, you notice that the db file scattered read and db file sequential read events appear in the list. Which two reasons could have caused these wait events? (Choose two.)
A. excessive writes due to an aggressive checkpointing policy
B. SQL statements performing frequent full table scans
C. tablespaces using manual segment space management
D. SQL statements performing frequent fast full index scans
正解：B,D