SQL Fundamentals Exam Prep Guide FAQ PDF Download

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

FAQ: 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