Transactions as SQL Statements MCQ

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

• SQL can be used to:
  ক

  Create database structures only

  খ

  Query database data only

  গ

  Modify database data only

  ঘ

  All of the mentioned
• Which of the following is the original purpose of SQL?
  ক

  To specify the syntax and semantics of SQL data definition language

  খ

  To specify the syntax and semantics of SQL manipulation language

  গ

  To define the data structures

  ঘ

  All of the mentioned
• Constraint checking can be disabled in existing _______________ and _____________ constraints so that any data you modify or add to the table is not checked against the constraint.
  ক

  CHECK, FOREIGN KEY

  খ

  DELETE, FOREIGN KEY

  গ

  CHECK, PRIMARY KEY

  ঘ

  PRIMARY KEY, FOREIGN KEY
• Isolation of the transactions is ensured by
  ক

  Transaction management

  খ

  Application programmer

  গ

  Concurrency control

  ঘ

  Recovery management
• SNAPSHOT is used for (DBA)
  ক

  Synonym

  খ

  Tablespace

  গ

  System server

  ঘ

  Dynamic data replication
• Which of the following is a property of transactions?
  ক

  Atomicity

  খ

  Concurrency

  গ

  Isolation

  ঘ

  All of the mentioned