gs gs116 Performance Tuning and Optimization - SQL Server Transaction - Quiz No.2
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Performance Tuning and Optimization. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following argument is ignored by database engine in COMMIT TRANSACTION?
@tran_name_variable
@tran_name
transaction_name
all of the mentioned
Question 2: Point out the correct statement.
ROLLBACK TRANSACTION with a savepoint_name or transaction_name rolls back to the beginning of the transaction
A ROLLBACK TRANSACTION statement does produce any messages to the user
Issuing a COMMIT TRANSACTION when @@TRANCOUNT is 0 results in an error
All of the mentioned
Question 3: ____________ is the preferred statement for indicating errors in the transaction.
SELECT
PRINT
RAISERROR
All of the mentioned
Question 4: Which of the following query deletes a job candidate?
BEGIN TRANSACTION; GO DELETE FROM HumanResources.JobCandidate WHERE JobCandidateID = 13; GO COMMIT TRANSACTION; BEGIN TRANSACTION; GO DELETE FROM HumanResources.JobCandidate WHERE JobCandidateID = 13; GO ROLLBACK TRANSACTION; BEGIN TRANSACTION; GO DELETE FROM HumanResources.JobCandidate WHERE JobCandidateID = 13; GO END;
All of the mentioned
Question 5: Point out the wrong statement.
It is the responsibility of the Transact-SQL programmer to issue COMMIT TRANSACTION only at a point when all data referenced by the transaction is logically correct
The Database Engine increments the transaction count within a statement only when the transaction count is 1 at the start of the statement
You cannot roll back a transaction after a COMMIT TRANSACTION statement is issued
COMMIT transaction requires membership in the public role
Question 6: A ROLLBACK TRANSACTION statement specifying a savepoint_name releases any locks that are acquired beyond the savepoint, with the exception of __________
escalations
containment
contention
none of the mentioned
Question 7: What is the fundamental difference between COMMIT and COMMIT WORK?
COMMIT TRANSACTION accepts a user-defined transaction name
COMMIT WORK accepts a user-defined transaction name
COMMIT TRANSACTION accepts a user-defined function
COMMIT WORK accepts a user-defined stored procedure
Question 8: Implicit transactions are maintained by SQL Server for ___________
SELECT
DDL
DML
All of the mentioned
Question 9: ROLLBACK WORK always rolls back to the outermost BEGIN TRANSACTION statement for ___________ transactions.
Simple
Nested
Distributed
None of the mentioned
Question 10: Which of the following condition will ignore the request to enable delayed durability?
DELAYED_DURABILITY = FORCED
DELAYED_DURABILITY = 0
DELAYED_DURABILITY = IGNORED
DELAYED_DURABILITY = NULL
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
