题目内容

数据字典信息被存放在哪类文件中()

A. 数据文件
B. 控制文件
C. 重做日志文件
D. 归档日志文件
E. 初始化参考文件

查看答案
更多问题

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

答案查题题库