Oracle 1Z0-050 問題集

質問 1：
You executed the following commands in an RMAN session for your database instance that has failures:
RMAN> LIST FAILURE;
After some time, you executed the following command in the same session:
RMAN> ADVISE FAILURE;
But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?
A. It produces advice only for new failures and the failures listed in the last LIST FAILURE
command are ignored.
B. It produces a warning for new failures before advising for CRITICAL and HIGH failures.
C. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.
D. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
正解：B

質問 2：
You issued the following command on the temporary tablespace LMTEMP in your database:
SQL>ALTER TABLESPACE Imtemp SHRINK SPACE KEEP 20M;
Which requirement must be fulfilled for this command to succeed?
A. The tablespace must have only one temp file.
B. The tablespace must be made nondefault and offline.
C. The tablespace can remain as the default but must have no active sort operations.
D. The tablespace must be locally managed.
正解：D

質問 3：
View the Exhibit to examine the error obtained during the I/O calibration process. There are no data files on raw devices. What is the reason for this error?

A. The pending area has not been created before running the I/O calibration process.
B. Another session runs the I/O calibration process concurrently.
C. The FILESYSTEMIOJDPTIONS parameter is set to NONE.
D. The DISK_ASYNCH_IO parameter is set to TRUE.
正解：C

質問 4：
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of l/Os. Which statement describes a solution to the above?
A. Modify the profile for the targeted users for which control needs to be imposed.
B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).
C. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
D. Set a threshold for the default system-defined moving window baseline.
正解：C

質問 5：
View the Exhibit to examine the Automatic SQL Tuning result details.

Which action would you suggest for the selected SQL statement in the Exhibit?
A. Collect statistics for the related objects.
B. Run the Segment Advisor for recommendations.
C. Run the Access Advisor for the SQL statement.
D. Accept the recommended SQL profile.
正解：C