网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Youexecutedthiscommandtocreateatemporarytable:SQL>CREATEGLOBALTEMPORARYTABLEreport_work_area(startdateDATE,enddateDATE,classCHAR(20))ONCOMMITPRESERVEROWS;WhichstatementistrueabouttherowsinsertedintotheREPORT_WORK_AREAtableduringatransaction()

A.Therowsstayinthetableonlyuntilsessiontermination.

B.Therowsstayinthetableonlyuntilthenexttransactionstartsonthetable.

C.Therowsarevisibletoallcurrentsessionsafterthetransactioniscommitted.

D.Therowsstayavailableforsubsequentsessionsafterthetransactioniscommitted


参考答案

更多 “ Youexecutedthiscommandtocreateatemporarytable:SQLCREATEGLOBALTEMPORARYTABLEreport_work_area(startdateDATE,enddateDATE,classCHAR(20))ONCOMMITPRESERVEROWS;WhichstatementistrueabouttherowsinsertedintotheREPORT_WORK_AREAtableduringatransaction()A.Therowsstayinthetableonlyuntilsessiontermination.B.Therowsstayinthetableonlyuntilthenexttransactionstartsonthetable.C.Therowsarevisibletoallcurrentsessionsafterthetransactioniscommitted.D.Therowsstayavailableforsubsequentsessionsafterthetransactioniscommitted ” 相关考题