当执行COMMIT语句时,会在哪类文件上发生I/O操作()
A. 数据文件
B. 控制文件
C. 重做日志文件
D. 归档日志文件
E. 警告文件
查看答案
Examinethissyntaxwhichallocateschannelsduringaparallelimagecopy:RMAN>CONFIGUREDEVICETYPEdiskparallelism4:2>COPY3>datafile1TO‘/BACKUP/datafile1.dbf’,4>datafile2TO‘/BACKUP/datafile2.dbf’,5>datafile3TO‘/BACKUP/datafile3.dbf;RMAN>COPY2>datafile4TO‘/BACKUP/datafile4.dbf’;Howmanychannelsareused?()
A. 0
B. 1
C. 3
D. 4
数据字典信息被存放在哪类文件中()
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.