SQL Fundamentals Exam Prep Guide PDF Download

Learn sql fundamentals exam prep guide , sql FAQs for online MCQs based test prep. These frequently asked questions has multiple choice questions (MCQ), sql quiz questions and answers as execution of an update statements should be of, answer key with choices as no transaction , single transaction, two transaction only and multiple transactions for competitive exam preparation. Free frequently asked questions are to learn sql fundamentals exam prep guide quiz online with MCQs to practice test questions with answers.

FAQs SQL Fundamentals Exam Prep Guide PDF Download

MCQ. Execution of an update statements should be of

  1. No transaction
  2. Single transaction
  3. Two transaction only
  4. Multiple transactions

B

MCQ. Process of restoring database state to first statement of executing transaction, is known as

  1. Transit-back work
  2. Traceback work
  3. Commit work
  4. Rollback work

D

MCQ. Automatic commit can be handled through application program interfaces such as

  1. JDBC
  2. ODBC
  3. JDBC and ODBC
  4. JDBC and TDBC

C

MCQ. Automatic commit can be turned off depending upon specific

  1. View schema
  2. Query expression
  3. SQL implementation
  4. Structure design

C

MCQ. In SQL, commands of begin atomic ...end was introduced in

  1. SQL:1998
  2. SQL:1999
  3. SQL:2000
  4. SQL:2001

B