SQL Fundamentals Exam Prep Guide FAQ PDF Download

Sql fundamentals exam prep guide , learn online sql MCQs, competency based interview questions with FAQs based online test prep. These frequently asked questions has multiple choice questions (MCQs), sql quiz questions and answers: execution of an update statements should be of, answer key with options no transaction, single transaction, two transaction only, multiple transactions for competitive exam preparation. Free FAQ, situational interview questions are to learn sql fundamentals exam prep guide : Q&A 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


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


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

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


MCQ: Automatic commit can be turned off depending upon specific

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


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

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