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

In a join condition it is mandatory to specify the table name along with the Column name.

  1. True

  2. False


Correct Option: B

A Non equi-join is a join condition that does not contain an equality operator.

  1. True

  2. False


Correct Option: B

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

  1. True

  2. False


Correct Option: B

What are the two types of SQL Functions?

  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

Compare the output of the following: SELECT TRUNC(99.57,1) FROM DUAL; and SELECT ROUND(99.57,1) FROM DUAL;

  1. 99.57,99,6

  2. 99.5,99.6

  3. 99.6,99.6

  4. 99.57,99.57


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

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 used to join a table to itself.

  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