Tag: databases

Questions Related to databases

An outer join is used to:
technology databases

  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

Show answer
Correct Option: A

____________ is the outer join operator.
technology databases

  1. (+)

  2. (-)

  3. (*)

  4. +

Show answer
Correct Option: A

____________ is used to join a table to itself.

technology databases

  1. Selfjoin

  2. Outerjoin

  3. innerjoin

  4. equijoin

Show answer
Correct Option: A

A null is the same as zero or a blank space.
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

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

Duplicate values are eliminated by which keyword
technology databases

  1. Duplicate

  2. Distinct

  3. Remove

  4. Delete

Show answer
Correct Option: B

The two types of subqueries are:
technology databases

  1. Single-row subquery, Double-row subquery

  2. Double-row subquery, Multiple-row subquery

  3. Multiple-row subquery

  4. Single-row subquery and Multiple subquery

Show answer
Correct Option: D

Single-row subquery returns:
technology databases

  1. Only one row

  2. Two rows

  3. Zero rows

  4. There is no such subquery

Show answer
Correct Option: A

What is the result of the query below? SELECT Stud_name, Rollnum FROM STUDENT WHERE stud_marks=(SELECT MIN (stud_marks) FROM STUDENT GROUPBY Rollnum);

technology databases

  1. It gives the name and marks of all the students.

  2. It does not return anything.

  3. It shows an error saying” INVALID SYNTAX ERROR”

  4. It shows an error saying” Single-row subquery returns more than one row

Show answer
Correct Option: D