You issued the following command on t

You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M; Which requirement must be fulfilled for this command to succeed?（）

A The tablespace must be locally managed.
B The tablespace must have only one temp file.
C The tablespace must be made nondefault and offline.
D The tablespace can remain as the default but must have no active sort operations.

参考答案

参考解析：

分类：OCP 11G认证考试题库

相关推荐

1、You issued the following command: An

You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TB...

2、You issue the following command on th

You issue the following command on the RMAN prompt.REPORT NEED BACKUP DAYS 5;Which statement is true about executing this command?（）A It will...

3、You executed the following commands i

You executed the following commands in a database session:What could have caused the recycle bin to clean up?（）A There is demand for space f...

4、You issue the follow

You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" S...

5、You issued the following RMAN command

You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?（）A Archived redo l...

6、You execute the following commands to

You execute the following commands to audit database activities:SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;SQL > AUDIT SELECT TA...

编辑推荐

小强家的木质书桌桌面已经严重掉漆，而且有很多地方坑洼不平.....

风机的主要工作参数为流量、风压、（）和功率。..

柏拉图认为，做最高统治者的人应该是（）。..

培训质量管理与培训评估的关系是（）..

自中脑背部发出的脑神经是（）..

“市场调查报告”是提供给领导决策参考的，因此，它的落脚点.....