Introduction to SQL Multiple Choice Questions Test 1 Tests pdf Download

Practice introduction to sql multiple choice questions (MCQs), db test 1 online to learn. Practice 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 answer key with choices as sql:1999, sql:1998, sql:2000 and sql:2001 of multiple choice questions (MCQ) as with clause, was introduced in to test learning skills. Study to learn nested subqueries quiz questions to practice MCQ based online exam preparation test.

MCQ on Introduction to SQL Quiz pdf Download Test 1

MCQ. 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 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. Exist construct returns true as a value, if argument subquery is

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

B

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

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

B