多选题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？（）Ause enterprise managerBuse DBMS_SQL packageCuse DBMS_AWR packageDuse PRVT_WORKLOAD packageEquery the AWR snapshot repository objectsFuse DBMS_WORKLOAD_REPOSITORY package
多选题
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
参考解析
解析：
暂无解析
相关考题：
单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）AThe user must be granted the database administrator （DBA） privilege.BThe user must be listed in the password file for the authentication.CNo special setup is needed for the user to connect as SYSDBA in iSQL*Plus.DSet up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.
单选题You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）ARestart the database instance and run the jobBTruncate the Certkiller STAFF table and run the jobCDelete all rows from the Certkiller STAFF table and run the jobDIncrease the size of the USERStablespacethe and run the jobEIncrease the size of the database default permanenttablespaceand run the job
单选题You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？（）ASQL scriptBPL/SQL scriptCOperating System （OS） scriptDEnterprise Manager （EM） scriptERecovery Manager （RMAN） script
多选题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？（）Ause enterprise managerBuse DBMS_SQL packageCuse DBMS_AWR packageDuse PRVT_WORKLOAD packageEquery the AWR snapshot repository objectsFuse DBMS_WORKLOAD_REPOSITORY package
单选题As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）ACoalesce the application tables at a regular interval.BExport and Import the application tables a regular interval.CDrop and recreate the application tables at a regular interval.DMove the application tables to a tablespace with less space usage.EDistribute the application tables across multiple tablespaces depending on usage.FMove the application tables to automatic segment space management tablespace.
单选题Which two operations can be flashed back using the Flashback technology？ （）ADROP USER SMITH；BDROP TABLE EMPLOYEES；CDROP TABLESPACE USERS；DALTER TABLE SALES_REP DROP PARTITION P1；EALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；