單項選擇題

You work as a database administrator for Supportcenter.cn. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

A.Memory Advisors
B.Segment Advisors
C.SQL Tuning and Access Advisors
D.Automated Workload Repository （AWR）
E.Automatic Database Diagnostic Monitor （ADDM）

你可能感興趣的試題

單項選擇題

Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?（）

A.The modified data are not available on disk.
B.The modified data have been flushed out from memory.
C.The modified rows of the SupportCenter STAFF table have been locked.
D.Jack has not committed the changes after modifying the value.
E.Both users are accessing the database from two different machines.

多項選擇題

You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

A.use enterprise manager
B.use DBMS_SQL package
C.use DBMS_AWR package
D.use PRVT_WORKLOAD package
E.query the AWR snapshot repository objects
F.use DBMS_WORKLOAD_REPOSITORY package

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

你可能感興趣的試題

Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精