题目内容

当执行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.

答案查题题库