网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
每个BEGIN TRANSACTION语句使@@TRANCOUNT()1。
参考答案
更多 “每个BEGIN TRANSACTION语句使@@TRANCOUNT()1。” 相关考题
考题
在SQL Server 2000中,某数据库中有教师表(教师号, 姓名, 职称),其中教师号的数据类型是整型,其他均为字符类型。若教师表中当前没有数据,用户在数霜尾币藕次执行下列语句: Ⅰ.BEGIN TRANSACTION T1 Ⅱ.INSERT INTO教师表VALUES(1000,'张三','助教'); Ⅲ.INSERT INTO教师表VALUES(1001,'王二','助教'); Ⅳ.COMMIT T1; Ⅴ.BEGIN TRANSACTION T2 Ⅵ.INSERT INTO教师表VALUES(1002,'王三','讲师'); Ⅶ.INSERT INTO教师表VALUES(1003,'李四','讲师'); Ⅷ.COMMIT T2; 在Ⅶ执行的时候数据库所在的服务器突然掉电,当数据库系统重新启动后,教师表中包含的数据条数为A.4条B.3条C.2条D.0条
考题
开始事务,提交事务,回滚事务的英语单词分别是:A.begin transaction , rollback transaction , commit transactionB.commit transaction , rollback transaction , begin transactionC.rollback transaction , begin transaction , commit transactionD.begin transaction , commit transaction , rollback transaction
考题
已知string s=“123456“,s1=“de“;,则下列选项中正确的语句包括()。
A.s.insert(s.begin()+1,s1)B.s.insert(s.begin()+1,'p')C.s.insert(s.begin()+1,"abc")D.s.insert(1,"abc")
考题
请看以下存储过程beginbegin语句1exceptionwhen othersdbms_output.put_line('错误1');end;begin语句2dbms_output.putline('错误2');end;exceptionwhen others thendbms_output.put_line("错误3");end;请问,当语句1,语句2出错时,该存储过程输出字符串分别是什么?
考题
Which of the following will begin a new unit of work?()
A.The CONNECT statementB.The first FETCH of a cursorC.The BEGIN TRANSACTION statementD.The first executable SQL statement
考题
属于事务控制的语句是()。A.Begin Tran、Commit、RollBackB.Begin、Continue、EndC.Create Tran、Commit、RollBackD.Begin Tran、Continue、End
考题
用于提交和回滚事务的语句为( )。A.END TRANSACTION和ROLLBACK TRANSACTION
B.COMMIT TRANSACTION和ROLLBACK TRANSACTION
C.SAVE TRANSACTION和ROLLUP TRANSACTION
D.COMMIT TRANSACTION和ROLLUP TRANSACTION
考题
V5.x系统中,手工清除Sybase中zxcms数据库日志的SQL语句是()A、dump transaction zxcms with no_logB、dump transaction zxcms with nologC、dump transaction zxcms with no-logD、drop transaction zxcms with nolog
考题
下列关于系统故障恢复的描述,正确的是()。A、从日志文件开头向后扫描B、从日志文件最后向前扫描C、需要建立撤销队列,并对该队列中的每个事务做撤销处理D、既有BEGIN TRANSACTION记录也有COMMIT记录的事务应放入撤销队列中
考题
下面语句中,能够正确的进入数据库事务的是:()A、@transaction.non_atomic_requestsB、@transaction.atomicC、withtransaction.atomic():D、withtransaction.non_atomic_requests():
考题
属于事务控制的语句是()。A、Begin Tran、Commit、RollBackB、Begin、Continue、EndC、Create Tran、Commit、RollBackD、Begin Tran、Continue、End
考题
Which of the following will begin a new unit of work?()A、The CONNECT statementB、The first FETCH of a cursorC、The BEGIN TRANSACTION statementD、The first executable SQL statement
考题
You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY BEGIN TRANSACTION DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY BEGIN CATCH DECLARE @ErrorMessage nvarchar(2000) DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE(),@ErrorSeverity=ERROR SEVERITY(),@ErrorState = ERROR STATE() RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState) END CATCH; You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do?()A、Add a COMMIT TRANSACTION command to the CATCH block.B、Remove the COMMIT TRANSACTION command from the TRY block.C、Add a ROLLBACK TRANSACTION command to the CATCH block.D、Add a ROLLBACK TRANSACTION command to the TRY block.
考题
问答题阅读程序,回答后面的问题
STM #9,AR4
begin: STM #7,BRC
RPTB next-1
nop
next: LD #0,B
banz begin,*AR4-
其中的“nop”语句被执行了多少次?
热门标签
最新试卷