Tag: databases

Questions Related to databases

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

The minimum number of join statements required to join 10 tables together are:
technology databases

  1. 9

  2. 11

  3. 5

  4. 12

  5. None of the above

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: B

What are the two types of SQL Functions?

technology databases

  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

Show answer
Correct Option: C

Single-Row Functions can return multiple results per row.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;
technology databases

  1. 1112

  2. 1111.93

  3. 1111.93412

  4. 1111.934

Show answer
Correct Option: D

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

  1. 99.57,99,6

  2. 99.5,99.6

  3. 99.6,99.6

  4. 99.57,99.57

Show answer
Correct Option: B

What does the MOD Function do?

technology databases

  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.

Show answer
Correct Option: C

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

technology databases

  1. True

  2. False

Show answer
Correct Option: B

To perform wild card search “Like” is used .

technology databases

  1. True

  2. False

Show answer
Correct Option: B