121、
121.Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the previous day. Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.) A. Use the Active Session History report. B. Use the AWR Compare Periods report. C. Use an ADDM analysis between 7 PM and 9 PM of the previous day. D. Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.
Answer: BC
122、
122.Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.) A. All AWR tables belong to the SYSTEM schema B. The AWR contains systemwide tracing and logging information C. The snapshots collected by the AWR are accessible through data dictionary views D. The snapshots collected by the AWR are used by self-tuning components in the database
Answer: CD
123、
123.View the Exhibit and examine the PL/SQL package and procedure. You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body. Which statement is true after you recompile the EMP_ADMIN package body? A. The USE_P procedure remains valid. B. The USE_P procedure becomes invalid. C. The SHOW_DETAIL procedure becomes invalid. D. The EMP_ADMIN package specification becomes invalid and needs to be recompiled.
Answer: A
124、View the Exhibit.
What would happen if Oracle Home is not empty? A. The installation will not be continued until the location is empty. B. The installation will proceed without overwriting the existing files. C. The installation can be continued, but the existing files will be overwritten. D. The installation terminates automatically after showing an error message.
Answer: A
125、
125.Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.) A. when the tablespace is online B. when the tablespace has segments with data in it C. when the tablespace is a default permanent tablespace for the database D. when the tablespace contains a table that is currently being used by transactions E. when the tablespace contains undo data that is needed to rollback an uncommitted transaction
Answer: CDE
