问答题

YouexecutethiscommandtodroptheITEMtable，whichhastheprimarykeyreferredintheORDERtable：SQL>DROPTABLEscott.itemCASCADECONSTRAINTSPURGE；Whichtwostatementsaretrueabouttheeffectofthecommand（）

A.NoflashbackispossibletobringbacktheITEMtable.
B.TheORDERtableisdroppedalongwiththeITEMtable.
C.ThedependentreferentialintegrityconstraintsintheORDERtablearedisabled.
D.ThedependentreferentialintegrityconstraintsintheORDERtableareremoved.
E.ThetabledefinitionoftheITEMtableandassociatedindexesareplacedintherecyclebin.

你可能感兴趣的试题

问答题

Viewthisparametersettinginyourdatabase：DB_CREATE_FILE_DEST=’D：/oracle/product/10.2.0/oradata/oracle’Youcreatedatablespacebyusingthiscommand：CREATETABLESPACEUSERS；WhichtwostatementsaretrueabouttheUSERStablespace？（）
A.Thetablespacehastwodatafiles.
B.Anerrorisreportedandtablespacecreationfails.
C.Datafilesarecreatedwithnamesgeneratedbytheinstance.
D.Thetablespacecanbeextendedwithoutspecifyingthedatafile.
E.DatafilesbelongingtotheUSERStablespacecannotberenamed.

A.2.0/oradata/oracle’Youcreatedatablespacebyusingthiscommand：CREATETABLESPACEUSERS；WhichtwostatementsaretrueabouttheUSERStablespace？（）
A.Thetablespacehastwodatafiles.
B.Anerrorisreportedandtablespacecreationfails.
C.Datafilesarecreatedwithnamesgeneratedbytheinstance.
D.Thetablespacecanbeextendedwithoutspecifyingthedatafile.
E.DatafilesbelongingtotheUSERStablespacecannotberenamed.

问答题

ImmediatelyafteraddinganewdisktoorremovinganexistingdiskfromanAutomaticStorageManagement（ASM）instance，youfindthattheperformanceofthedatabasedecreasesinitially，untiltheadditionorremovalprocessiscompleted.Performancethengraduallyreturnstonormallevels.Whichtwoactivitiescouldyouperformtomaintainaconsistentperformanceofthedatabasewhileaddingorremovingdisks？（）
A.increasethenumberofcheckpointprocesses
B.definethePOWERoptionwhileaddingorremovingthedisks
C.increasethenumberofDBWRprocessesbysettingupahighervalueforDB_WRITER_PROCESSES
D.increasethenumberofslavedatabasewriterprocessesbysettingupahighervaluefor DBWR_IO_SLAVES
E.increasethenumberofASMRebalanceprocessesbysettingupahighervalueforASM_POWER_LIMITduringthediskadditionorremovalprocess

A.Performancethengraduallyreturnstonormallevels.Whichtwoactivitiescouldyouperformtomaintainaconsistentperformanceofthedatabasewhileaddingorremovingdisks？（）
A.increasethenumberofcheckpointprocesses
B.definethePOWERoptionwhileaddingorremovingthedisks
C.increasethenumberofDBWRprocessesbysettingupahighervalueforDB_WRITER_PROCESSES
D.increasethenumberofslavedatabasewriterprocessesbysettingupahighervaluefor
E.increasethenumberofASMRebalanceprocessesbysettingupahighervalueforASM_POWER_LIMITduringthediskadditionorremovalprocess