问答题

Whendoesatransactioncomplete?（）

A.whenaDELETEstatementisexecuted
B.whenaROLLBACKcommandisexecuted
C.whenaPL/SQLanonymousblockisexecuted
D.whenadatadefinitionlanguage(DDL)statementisexecuted
E.whenaTRUNCATEstatementisexecutedafterthependingtransaction

你可能感兴趣的试题

YouneedtogeneratealistofallcustomerlastnameswiththeircreditlimitsfromtheCUSTOMERStable.Thosecustomerswhodonothaveacreditlimitshouldappearlastinthelist.Whichtwoquerieswouldachievetherequiredresult?（）

A.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitDESC
B.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limit
C.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitNULLSLAST
D.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_last_name,cust_credit_limitNULLSLAST

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

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