网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
每个BEGIN TRANSACTION语句使@@TRANCOUNT()1。
参考答案
更多 “每个BEGIN 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
考题
自旋回波(SE)脉冲序列()。A.每个TR周期采集的数据填充K空间的一行B.每个TR周期采集的数据填充K空间的二行C.每个TR周期采集的数据填充K空间的三行D.每个TR周期采集的数据填充K空间的四行E.每个TR周期采集的数据填充K空间的多行
考题
属于事务控制的语句是()。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
考题
在Hibernate中,下列关于Transaction说法正确的有()A、事务Transaction为应用程序指定以原子操作单元为范围的对象B、在对数据库进行增加、修改和删除操作时一定要加上TransactionC、在对数据库进行查询操作时一定要加上TransactionD、获得Transaction的方法:Transaction tr = session.beginTransaction();
考题
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
考题
单选题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.
考题
单选题User A executes the following command to update the TRANS table) SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’; Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table: SQl ALTER TABLE trans MODIFY (tr_type VARCHAR2 (3)); What would happen in this scenario?()A
The transaction for user A is rolled back.B
The ALTER TABLE command modifies the column successfully.C
The ALTER TABLE command fails due to the resource being busy.D
The ALTER TABLE command waits until user A ends the transaction.
考题
多选题在Hibernate中,下列关于Transaction说法正确的有()A事务Transaction为应用程序指定以原子操作单元为范围的对象B在对数据库进行增加、修改和删除操作时一定要加上TransactionC在对数据库进行查询操作时一定要加上TransactionD获得Transaction的方法:Transaction tr = session.beginTransaction();
热门标签
最新试卷