网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
每个COMMIT TRANSACTION语句使@@TRANCOUNT()1。
参考答案
更多 “每个COMMIT TRANSACTION语句使@@TRANCOUNT()1。” 相关考题
考题
开始事务,提交事务,回滚事务的英语单词分别是: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
考题
若用SQL语句编写的转账业务事务程序如下:START TRANSACTION;SET TRANSACTION ISOLATION LEVEL SERIALIZABLEUPDATE AccountsSET CurrentBalance=CurrentBalance-AmountWHERE AccountID=A;if error then ROLLBACK;COMMIT;UPDATE AccountsSET CurrentBalance=CurrentBalance+AmountWHERE AccountID=B;if error then ROLLBACK;COMMIT;其中:Accounts为账户表,CurrentBalance为当前余额,Amount为新存入的金额。该事务程序能否保证数据的一致性?如不能,请说明原因并改正。(100字以内)
考题
属于事务控制的语句是()。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
考题
下列关于事务的说法,哪一项是错误的?()A、事务中的操作并行执行。B、同一个事务中只能执行1个COMMIT语句C、事务会保证一组操作的原子性D、ROLLBACK或COMMIT语句可以终结事务
考题
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
考题
关于DDL与事务控制,下列说法错误的是()。A、COMMIT和ROLLBACK语句只应用于DMLB、无法回滚DDL语句C、DDL语句一旦被执行就会立即具有持久状态D、如果没有在CREATETABLE命令内嵌入COMMIT命令,不会出现未完成的
考题
属于事务控制的语句是()。A、Begin Tran、Commit、RollBackB、Begin、Continue、EndC、Create Tran、Commit、RollBackD、Begin Tran、Continue、End
考题
属于事务控制的语句是()。A、BeginTran、Commit、RollBackB、Begin、Continue、EndC、CreateTran、Commit、RollBackD、BeginTran、Continue、End
考题
The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table: ERROR at line 1: ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened by user JIM has a transaction that caused the deadlock. two statements are true regarding the session of SCOTT in this scenario()A、The session is terminated after receiving the error and JIM can continue with his transaction.B、SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.C、The session is rolled back after receiving the error and JIM can continue with his transaction.D、SCOTT has to reexecute the last command in the transaction after he commits the transaction.
考题
View the following SQL statements: Transaction T1 INSERT INTO hr.regions VALUES (5,’Pole’);COMMIT; Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5; COMMIT; Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5; You want to back out transaction T2. Which option would you use?()A、 It is possible,but transaction T3 also backs out.B、 It is possible with the NOCASCADE_FORCE option.C、 It is possible with the NONCONFLICT_ONLY option.D、 It is not possible because it has conflicts with transaction T3.
考题
You work as a database administrator for Certkiller .com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario?()A、Event Viewer gives more details on the failure.B、The alert log file gives detailed information about the failure.C、PMON rolls back the transaction and releases the locks.D、SMON rolls back the transaction and releases the locks.E、The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.F、Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
考题
You executed this command to create a temporary table: SQL CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddateDATE, class CHAR(20)) ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction()A、The rows stay in the table only until session termination.B、The rows stay in the table only until the next transaction starts on the table.C、The rows are visible to all current sessions after the transaction is committed.D、The rows stay available for subsequent sessions after the transaction is committed
考题
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.
考题
单选题You have two tables with referential integrity enforced between them. You need to insert data to the child tablefirst because it is going to be a long transaction and data for the parent table will be available in a later stage,which can be inserted as part of the same transaction. View the Exhibit to examine the commands used tocreate tables. Which action would you take to delay the referential integrity checking until the end of thetransaction()A
Set the constraint to deferred before starting the transaction.B
Alter the constraint to NOVALIDATE state before starting the transaction.C
Enable the resumable mode for the session before starting the transaction.D
Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction
考题
单选题下列关于事务的说法,哪一项是错误的?()A
事务中的操作并行执行。B
同一个事务中只能执行1个COMMIT语句C
事务会保证一组操作的原子性D
ROLLBACK或COMMIT语句可以终结事务
热门标签
最新试卷
![瑞牛题库 章节练习 历年真题 模拟试卷](http://assets.51tk.com/51_sidebar_right_index.jpg)