SQL Server Questions and Answers – Transaction – 1

This set of SQL Server Multiple Choice Questions & Answers (MCQs) focuses on “Transaction – 1”.

1. The INSERT, UPDATE, or DELETE statement fails if the OLE DB provider used to access the linked server does not support the _________ interface.
a) ITransJoin
b) ITransactionJoin
c) IactionJoin
d) None of the mentioned
View Answer

2. Point out the correct statement.
a) Transaction ID Returns an object that can be used to specify configuration options for a subsequent call to ITransactionJoin
b) COMMIT WORK syntax, with or without specifying the optional keyword WORK, is compatible with SQL-92
c) You can use ROLLBACK WORK TRANSACTION to erase all data modifications made from the start of the transaction
d) SQL-92 was the third revision of the SQL database query language
View Answer

3. __________ marks the end of a successful implicit or explicit transaction.
a) COMMIT TRANSACTION
b) ROLLBACK TRANSACTION
c) COMMIT WORK
d) All of the mentioned
View Answer

4. What is the syntax for COMMIT WORK statement in transaction?
a)

COMMIT [ WORK ]
[ ; ]

b)

COMMIT WORK [ WORK ]
[ ; ]

c)

COMMITWORK [ WORK ]
[ ; ]

d) None of the mentioned
View Answer

5. Point out the wrong statement.
a) BEGIN TRANSACTION represents a point at which the data referenced by a connection is logically and physically consistent
b) BEGIN TRANSACTION deccrements @@TRANCOUNT by 2
c) BEGIN TRANSACTION starts a local transaction for the connection issuing the statement
d) All of the mentioned
View Answer

6. ____________ rolls back a user-specified transaction to the beginning of the transaction.
a) ROLLBACK
b) ROLLBACK WORK
c) SAVE TRANSACTION
d) COMMIT
View Answer

7. Which of the following is valid syntax for SAVE TRANSACTION with all the optional parameters?
a)

SAVE { TRAN | TRANSACTION } 
[ ; ]

b)

SAVE  { savepoint_name | @savepoint_variable }
[ ; ]

c)

SAVE { TRAN | TRANSACTION } { savepoint_name | @savepoint_variable }

d) None of the mentioned
View Answer

8. In _______ transaction we include the DML statements that need to be executed as a unit.
a) Explicit
b) Implicit
c) Distributed
d) All of the mentioned
View Answer

9. _________ permissions default to any valid user.
a) ROLLBACK WORK
b) ROLLBACK
c) COMMIT
d) None of the mentioned
View Answer

10. If @@TRANCOUNT is 1 ________ makes all data modifications performed since the start of the transaction a permanent part of the database.
a) COMMIT TRANSACTION
b) SAVE TRANSACTION
c) ROLLBACK TRANSACTION
d) None of the mentioned
View Answer

Sanfoundry Global Education & Learning Series – SQL Server.

To practice all areas of SQL Server, here is complete set of 1000+ Multiple Choice Questions and Answers.