0

databases Online Quiz - 161

Description: databases Online Quiz - 161
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Structured Query Language

  2. Standard Query Language

  3. System Query Language

  4. Simple Query Language


Correct Option: A

A null is the same as zero or a blank space.

  1. True

  2. False


Correct Option: B

What does the MOD Function do?

  1. It divides both the values and gives the quotient.

  2. It multiplies both the values and gives the product.

  3. It divides both the values and gives the remainder.

  4. There is no such function.


Correct Option: C
  1. It divides both the values and gives the quotient.

  2. It multiplies both the values and gives the product.

  3. It divides both the values and gives the remainder.

  4. There is no such function.


Correct Option: C
  1. When a join condition is omitted.

  2. When a join condition is invalid.

  3. All rows in the first table are joined to all rows in the second table.

  4. All of the above.


Correct Option: D
  1. Single-row Functions and Double-row Functions

  2. One-row Functions and Two-row Functions

  3. Single-row Functions and Multiple-row Functions

  4. None of the above


Correct Option: C

Which of the following WHERE clauses represent equi-join?

  1. Table1.column1=Table2.column2

  2. Table1.column1=Table2.column1

  3. Table1.column2=Table2.column1

  4. None of the above


Correct Option: B

An outer join is used to:

  1. Return records which have no direct match

  2. Return records which have direct match

  3. Return all the records

  4. None of the above


Correct Option: A

____________ is the outer join operator.

  1. (+)

  2. (-)

  3. (*)

  4. +


Correct Option: A
- Hide questions