Youjustissuedthefollowingstatement:ALTERTABLESALESDROPCOLUMNPROFIT.WhichofthefollowingchoicesidentifieswhenthecolumnwillactuallyberemovedfromOracle?()
A. Immediatelyfollowingstatementexecution
B. AftertheALTERTABLEDROPUNUSEDCOLUMNScommandisissued
C. AftertheALTERTABLESETUNUSEDCOLUMNcommandisissued
D. AftertheALTERTABLEMODIFYcommandisissued
查看答案
Youwanttoperforminincompleterecoveryofyourdatabase.Youplantousethesecommandstorecoveryourdatabase:SETUNTILTIME=’2000-12-09:11:44:00’;RESTOREDATABASE;RECOVERDATABASE;Howshouldthecommandsbeexecuted?()
A. OnlytheSETcommandmustbewithinaRUNblock.
B. AllcommandsshouldbeexecutedattheRMANprompt.
C. AllthreecommandsmustbewithinasingleRUNblock.
D. OnlytheRESTOREandRECOVERcommandsmustbewithinasingleRUNblock.
INSERT,UPDATE,DELETE等命令属于下列哪类命令()
A. DCL
B. DDL
C. DML
DQL
E. 以上所述都不正确
YouareabouttocreateyourOracledatadictionaryforusewiththedatabase.WhichofthefollowinguserswouldyouconnecttothedatabaseasforthispurposeinOracle9iandlaterreleases?()
A. SYSTEM
B. OUTLN
C. INTERNAL
D. SYS
CREATE,DROP,ALTER等命令属于下列哪类命令()
A. DCL
B. DDL
C. DML
DQL
E. 以上所述都不正确