多项选择题
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：
ERROR at line 1：
ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）
A. Drop and re-create the inbox.
B. Coalesce the ORDERS_IND index.
C. Coalesce the INDEXES tablespace.
D. Drop and re-create the ORDERS table.
E. Rebuild the index online and move it to another tablespace.
相关考题
-
单项选择题
YouneedtochecktheEMP_EASTpartitionintheEMPLOYEEStableforphysicalcorruptions.Youalsoneedtoverifythattherowsbelongtothecorrectpartition.Whichoptioncouldyouuse？（）
A. LogMiner
B. The DBNEWID utility
C. The DBVERIFY utility
D. The ANALYZE command
E. The RMAN REPORT command
F. The RMAN CROSSCHECK command.
G. The RMAN BLOCKRECOVER command. -
单项选择题
Youwantyourlistenertobepasswordprotectedtopreventitfrombeingshutdown.Youwantto accomplishthistaskwhilethelistenerisfunctional.Whichmethodcouldyouusetoachievethisobjective？（）
A. Use the CHANGE_PASSWORD command of the Listener control utility.
B. Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.
C. Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.
D. Manually modify the listener.ora file to include the password for the listener and restart the listener. -
单项选择题
WhichstatementistrueregardingthecreationofnestedplansusingResourceManager？（）
A. Only one nested subplan is allowed.
B. The plans can be nested up to four levels.
C. Resource Manager does not support nested plans.
D. Nested plans control only the degree of parallelism but not the CPU.
E. Each nested plan gets a proportion of the CPU resources assigned to its parent group.
