dbms transactions

mcqspedia.com has 5 Question/Answers about Topic dbms transactions

A term that consists of a sequence of query and/or update statements, is known as

A term that consists of a sequence of query and/or update statements, is known as
  • A. Transactions
  • B. Data commit
  • C. Data rollback
  • D. Data automation
  • Correct Answer: Option A

SQL standard specifies that a transaction begins implicitly when an SQL statement is

SQL standard specifies that a transaction begins implicitly when an SQL statement is
  • A. Called
  • B. Used
  • C. Retrieved
  • D. Executed
  • Correct Answer: Option D

Term that is known to commit current transaction, is

Term that is known to commit current transaction, is
  • A. Rollback work
  • B. Commit work
  • C. Trace work
  • D. Transit work
  • Correct Answer: Option B

SQL statements that must end transaction are of type

SQL statements that must end transaction are of type
  • A. 2 types
  • B. 3 types
  • C. 4 types
  • D. 5 types
  • Correct Answer: Option A

When an SQL statement is Executed, SQL standard specifies start of a

When an SQL statement is Executed, SQL standard specifies start of a
  • A. Commitment
  • B. Data flow
  • C. Transaction
  • D. Data communication
  • Correct Answer: Option C