Transaction MCQ

Test your knowledge with important Transaction MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Transaction MCQs at Bissoy

• 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
• ROLLBACK WORK always rolls back to the outermost BEGIN TRANSACTION statement for ___________ transactions.
  ক

  Simple

  খ

  Nested

  গ

  Distributed

  ঘ

  None of the mentioned
• Implicit transactions are maintained by SQL Server for ___________
  ক

  SELECT

  খ

  DDL

  গ

  DML

  ঘ

  All of the mentioned
• 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
• 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
• ____________ is the preferred statement for indicating errors in the transaction.
  ক

  SELECT

  খ

  PRINT

  গ

  RAISERROR

  ঘ

  All of the mentioned
• Which of the following argument is ignored by database engine in COMMIT TRANSACTION?
  ক

  @tran_name_variable

  খ

  @tran_name

  গ

  transaction_name

  ঘ

  all of the mentioned
• If @@TRANCOUNT is 1 ________ makes all data modifications performed since the start of the transaction a permanent part of the database.
  ক

  COMMIT TRANSACTION

  খ

  SAVE TRANSACTION

  গ

  ROLLBACK TRANSACTION

  ঘ

  None of the mentioned
• _________ permissions default to any valid user.
  ক

  ROLLBACK WORK

  খ

  ROLLBACK

  গ

  COMMIT

  ঘ

  None of the mentioned
• In _______ transaction we include the DML statements that need to be executed as a unit.
  ক

  Explicit

  খ

  Implicit

  গ

  Distributed

  ঘ

  All of the mentioned
• ____________ rolls back a user-specified transaction to the beginning of the transaction.
  ক

  ROLLBACK

  খ

  ROLLBACK WORK

  গ

  SAVE TRANSACTION

  ঘ

  COMMIT
• __________ marks the end of a successful implicit or explicit transaction.
  ক

  COMMIT TRANSACTION

  খ

  ROLLBACK TRANSACTION

  গ

  COMMIT WORK

  ঘ

  All of the mentioned
• The INSERT, UPDATE, or DELETE statement fails if the OLE DB provider used to access the linked server does not support the _________ interface.
  ক

  ITransJoin

  খ

  ITransactionJoin

  গ

  IactionJoin

  ঘ

  None of the mentioned