网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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
参考答案
参考解析
解析：
暂无解析
更多 “多选题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” 相关考题
考题
单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）A
The user must be granted the database administrator （DBA） privilege.B
The user must be listed in the password file for the authentication.C
No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.D
Set 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？（）A
Restart the database instance and run the jobB
Truncate the Certkiller STAFF table and run the jobC
Delete all rows from the Certkiller STAFF table and run the jobD
Increase the size of the USERStablespacethe and run the jobE
Increase 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？（）A
SQL scriptB
PL/SQL scriptC
Operating System （OS） scriptD
Enterprise Manager （EM） scriptE
Recovery 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？（）A
Coalesce the application tables at a regular interval.B
Export and Import the application tables a regular interval.C
Drop and recreate the application tables at a regular interval.D
Move the application tables to a tablespace with less space usage.E
Distribute the application tables across multiple tablespaces depending on usage.F
Move the application tables to automatic segment space management tablespace.
考题
单选题Which two operations can be flashed back using the Flashback technology？ （）A
DROP USER SMITH；B
DROP TABLE EMPLOYEES；C
DROP TABLESPACE USERS；D
ALTER TABLE SALES_REP DROP PARTITION P1；E
ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
热门标签
最新试卷