Introduction to SQL Multiple Choice Questions 1 PDF Download

Learn introduction to sql multiple choice questions (MCQs), database management system test 1 for online learning, course exam prep. Practice nested subqueries MCQs, introduction to sql questions and answers on nested subqueries, aggregate functions, additional basic operations, set operations test for online DBMS courses distance learning.

Free introduction to sql quiz online, self-study student guide has multiple choice question: with clause, was introduced in with choices sql:1999, sql:1998, sql:2000 and sql:2001 with distance learning online for computer science engineering, bachelor and masters of computer science. Study to learn online nested subqueries quiz questions with database management system MCQs for IT certifications competitive exam prep.

MCQ on Introduction to SQL Test 1 Quiz PDF Download

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