Tag: databases

Questions Related to databases

To perform wild card search “Like” is used .
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

When is a Cartesian product formed?
technology databases

  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.

Show answer
Correct Option: D

In a join condition it is mandatory to specify the table name along with the Column name.
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

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

  1. True

  2. False

Show answer
Correct Option: B

Arithmetic expressions containing a null value evaluate to null.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Concatenation operator is
technology databases

  1. +

  2. -

  3. ||

  4. *

Show answer
Correct Option: C

What are SQL “SELECT” statement capabilities.
technology databases

  1. Projection

  2. Selection

  3. Join

  4. All of the above

Show answer
Correct Option: D

To select all the columns from a table EMP, which one of the following is TRUE?
technology databases

  1. Select all columns from EMP;

  2. Select distinct columns from EMP;

  3. Select * from EMP;

  4. All of the above

Show answer
Correct Option: C