网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
UserSCOTTexecutesthefollowingcommandontheEMPtablebuthasnotissuedCOMMIT，ROLLBACK，oranydatadefinitionlanguage（DDL）command：SQL>SELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno；SCOTThasopenedanothersessiontoworkwiththedatabaseinstance.WhichthreeoperationswouldwaitwhenissuedinSCOTT’ssecondsession（）
A.LOCKTABLEempINSHAREMODE；
B.LOCKTABLEempINEXCLUSIVEMODE；
C.UPDATEempSETsal=sal*1.2WHEREjob=ANAGER？UPDATEempSETsal=sal*1.2WHEREjob=？ANAGER？
D.INSERTINTOemp（empno，ename）VALUES（1289，’Harry’）；
E.SELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno
参考答案
更多 “ UserSCOTTexecutesthefollowingcommandontheEMPtablebuthasnotissuedCOMMIT，ROLLBACK，oranydatadefinitionlanguage（DDL）command：SQLSELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno；SCOTThasopenedanothersessiontoworkwiththedatabaseinstance.WhichthreeoperationswouldwaitwhenissuedinSCOTT’ssecondsession（）A.LOCKTABLEempINSHAREMODE；B.LOCKTABLEempINEXCLUSIVEMODE；C.UPDATEempSETsal=sal*1.2WHEREjob=ANAGER？UPDATEempSETsal=sal*1.2WHEREjob=？ANAGER？D.INSERTINTOemp（empno，ename）VALUES（1289，’Harry’）；E.SELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno ” 相关考题
考题
●关于ROLLBACK的描述，正确的是__(55) 。(55)A． ROLLBACK语句会将事务对数据库的更新写入数据库B．ROLLBACK语句会将事务对数据库的更新撤消C．ROLLBACK语句会退出事务所在程序D．ROLLBACK语句能够将事务中使用的所有变量置空值
考题
●关于ROLLBACK的描述，正确的是(55) 。(55)A． ROLLBACK语句会将事务对数据库的更新写入数据库B．ROLLBACK语句会将事务对数据库的更新撤消C．ROLLBACK语句会退出事务所在程序D．ROLLBACK语句能够将事务中使用的所有变量置空值
考题
You configured an interface with an IP address and committed the change. You then committed a change that added an exception in a firewall filter to allow this network through the filter. You realize that this work was done on the wrong router. How do you undo all these changes?（）A. rollback 2B. rollback 1C. rollback 0D. rollback 3
考题
Which command is used to load the rescue configuration?()
A. load override rescueB. rollback rescueC. load replace rescue-configurationD. rollback 49
考题
You‘ve configured an interface with an IP address and commited the change. You then commited a change that added an exception in a firewall filter to allow this network through the filter. You realize that this work was done on the wrong router.How do you undo all these changes?（）A. rollback 2B. rollback 1C. rollback 0D. rollback 3
考题
Which of the following actions may cause a trigger to be fired?()
A.DROPB.ALTERC.DELETED.ROLLBACK
考题
在SQL中，通过使用COMMIT和和ROLLBACK语句可以结束事务。以下说法正确的是（ ）A.某事务执行了ROLLBACK语句，表示事务正确地执行完毕
B.某事务执行了ROLLBACK语句，可将其对数据库的更新写入数据库
C.某事务执行了ROLLBACK语句，可将其对数据库的更新撤消
D.某事务执行了COMIMIIT语句，其影响可用ROLLBACK语句来撤销
考题
26、关于 ROLLBACK 的描述， 正确的是_______A．ROLLBACK 语句会将事务对数据库的更新写入数据库B．ROLLBACK 语句会将事务对数据库的更新撤消C．ROLLBACK 语句会退出事务所在程序D．ROLLBACK 语句能够将事务中使用的所有变量置空值
热门标签
最新试卷
