相关考题
-
未知题型
ExaminethefollowingstatementthatisusedtomodifytheprimarykeyconstraintontheSALEStable：SQL>ALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE；Whichthreestatementsaretrueregardingtheabovecommand（）
A.Theconstraintremainsvalid.
B.Theindexontheconstraintisdropped.
C.ItallowstheloadingofdataintothetableusingSQL*Loader.
D.Newdataconformstotheconstraint，butexistingdataisnotchecked.
E.ItallowsthedatamanipulationonthetableusingINSERT/UPDATE/DELETESQLstatements. -
未知题型
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.
