未知题型
ExaminethefollowingstatementthatisusedtomodifytheprimarykeyconstraintontheSALEStable：SQL>ALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE；Whichthreestatementsaretrueregardingtheabovecommand（）
- A.Theconstraintremainsvalid.
B.Theindexontheconstraintisdropped.
C.ItallowstheloadingofdataintothetableusingSQL*Loader.
D.Newdataconformstotheconstraint，butexistingdataisnotchecked.
E.ItallowsthedatamanipulationonthetableusingINSERT/UPDATE/DELETESQLstatements.
【参考答案】
A, B, C
点击查看答案
相关考题
-
未知题型
YouwanttomigrateyourexistingnonASMfilestoASMfilesforthedatabasePROD.Whichmethodorcommandwouldyouusetoaccomplishthistask？（）
A.theCONVERTcommandofRMAN
B.DataPumpExportandImportintothesamedatabase
C.conventionalexportandimportintothesamedatabase
D.theBACKUPDATABASEandRESTOREDATABASEcommandsofRMAN
E.theBACKUPASCOPYDATABASEandSWITCHDATABASETOCOPYcommandofRMAN -
未知题型
Evaluatethefollowingcommandanditsoutput：SQL>SELECT*FROMdba_temp_free_space；TABLESPACE_NAMETABLESPACE_SIZEALLOCATED_SPACEFREE_SPACELMTEMP250609664101048576149561088Whichtwostatementscorrectlyinterprettheoutput？（）A.FREE_SPACEindicatesonlythespacethatiscurrentlyunallocated.B.ALLOCATED_SPACEindicatesonlythespacecurrentlyallocatedandinuse.C.FREE_SPACEindicatesonlythespacethatiscurrentlyallocatedandavailableforreuse.D.ALLOCATED_SPACEindicatesboththespacecurrentlyallocatedandused，andthespacethat isavailableforreuse.E.FREE_SPACEindicatesboththespacethatiscurrentlyallocatedandavailableforreuse，andthespacethatiscurrentlyunallocated.
A.FREE_SPACEindicatesonlythespacethatiscurrentlyunallocated.
B.ALLOCATED_SPACEindicatesonlythespacecurrentlyallocatedandinuse.
C.FREE_SPACEindicatesonlythespacethatiscurrentlyallocatedandavailableforreuse.
D.ALLOCATED_SPACEindicatesboththespacecurrentlyallocatedandused，andthespacethat
E.
F.FREE_SPACEindicatesboththespacethatiscurrentlyallocatedandavailableforreuse，andthespacethatiscurrentlyunallocated. -
未知题型
Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile？（）
A.DB_CREATE_FILE_DEST
B.DB_RECOVERY_FILE_DEST
C.DB_RECOVERY_FILE_DEST_SIZE
D.DB_ONLINE_LOG_DEST_n
