單項(xiàng)選擇題

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）

A.by using the SQL access advisor
B.by using the Automatic Workload Repository report
C.by running the Automatic Database Diagnostic Monitor （ADDM）
D.by using the Automatic Workload Repository Compare Period report
E.by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

你可能感興趣的試題

多項(xiàng)選擇題

Which two statements are true about a bitmap index？（）

A.It is recommended for the columns that have unique values.
B.It can be converted to a B-tree index by using the ALTER INDEX command.
C.It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.
D.Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

單項(xiàng)選擇題

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；
Table created.
Further， you executed the following command to drop the table：
SQL> DROP TABLE emp； Table dropped.
What happens in this scenario？（）

A.The table is moved to the SYSAUX tablespace.
B.The table is moved to the SYSTEM tablespace.
C.The table is removed from the database permanently.
D.The table is renamed and remains in the TBSFD tablespace.

你可能感興趣的試題

Which two statements are true about a bitmap index？ （）

Which two statements are true about a bitmap index？（）