Introduction to SQL Multiple Choice Questions 1 PDF Download

Practice introduction to sql multiple choice questions (MCQs), db test 1 for online course prep exams. Learn nested subqueries MCQs questions and answers on nested subqueries, aggregate functions, additional basic operations, set operations with answers.

Free introduction to sql quiz online, study guide has multiple choice question on with clause, was introduced in with options sql:1999, sql:1998, sql:2000 and sql:2001 to test online e-learning skills for viva exam prep and job's interview questions with answers key. Study to learn nested subqueries quiz questions with online learning MCQs for competitive exam preparation test.

MCQ on Introduction to SQL Quiz PDF Download Test 1

MCQ. The with clause, was introduced in

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

B

MCQ. To specify duplicate retention, we can use the keyword in place of distinct, which is

  1. Select distinct
  2. Duplicate
  3. Whole
  4. All

D

MCQ. An identifier, that is used to rename a relation is referred to as a

  1. Input variable
  2. Clone name
  3. Correlation name
  4. Table alias

C

MCQ. The exist construct returns true as a value, if the argument subquery is

  1. Empty
  2. Not empty
  3. Exist
  4. Not exist

B

MCQ. If any of the input values is null, the result of an arithmetic expression, would be

  1. 0
  2. Null
  3. 1
  4. Undefined

B