多项选择题
You work as a database administrator for Certkiller .com. 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
相关考题
-
单项选择题
You are working on the Certkiller database. What is the default name of the alert log file in this database?()
A.alert_ Certkiller .log
B.alertlog_ Certkiller .log
C.alert_log_ Certkiller .log
D.Certkiller _alert_log.log
E.log_alert_: Certkiller .log
F.trace_alert_ Certkiller .log -
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.Inaproductionenvironment,userscomplainabouttheslowresponsetimewhenaccessingthedatabase.YouhavenotoptimizedthememoryusageoftheOracleinstanceandyoususpecttheproblemtobewiththememory.Towhichtypeofobjectwouldyourefertodeterminethecauseoftheslowresponse?()
A.The trace file
B.The fixed views
C.The data dictionary views
D.The operating system log fields
E.The dynamic performance views. -
单项选择题
YouworkasadatabaseadministratorforCertkiller.com.Thedatabaseisopen.Amediafailurehasoccurred,resultinginlossofallthecontrolfilesinyourdatabase.Whichstatementregardingthedatabaseinstanceistrueinthisscenario?()
A.The instance would hang.
B.The instance needs to be shut down.
C.The instance would be in the open state.
D.The instance would abort in such cases.
E.The instance would be in the open and invalid state.
F.The instance would in the open state, but all the background processes will be restarted.
