0

databases Online Quiz - 156

Description: databases Online Quiz - 156
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

We can nest Group Functions

  1. True

  2. False


Correct Option: B

SYSDATE is a date function that returns the current database server date and time.

  1. True

  2. False


Correct Option: B

The value returned by the subquery is used by the main query.

  1. True

  2. False


Correct Option: B

To perform wild card search “Like” is used .

  1. True

  2. False


Correct Option: B

When is a Cartesian product formed?

  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

Sorting SQL statement result data by column alias is not possible.

  1. True

  2. False


Correct Option: B
  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

Single-Row Functions can return multiple results per row.

  1. True

  2. False


Correct Option: B

LAST_DAY(date) finds the date of the last day of the month that contains date.

  1. True

  2. False


Correct Option: B
  1. Table1.column1=Table2.column2

  2. Table1.column1=Table2.column1

  3. Table1.column2=Table2.column1

  4. None of the above


Correct Option: B
  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
  1. Selfjoin

  2. Outerjoin

  3. innerjoin

  4. equijoin


Correct Option: A
  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
- Hide questions