Tag: databases

Questions Related to databases

Select ename from emp where ename =”Scott”; This select statement executes successfully.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

Which of these is not a Single-Row Function?
technology databases

  1. Character Function

  2. Number Function

  3. String Function

  4. Date Function

Show answer
Correct Option: C

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

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

  1. True

  2. False

Show answer
Correct Option: B

Which of the following WHERE clauses represent equi-join?
technology databases

  1. Table1.column1=Table2.column2

  2. Table1.column1=Table2.column1

  3. Table1.column2=Table2.column1

  4. None of the above

Show answer
Correct Option: B

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