Tag: databases

Questions Related to databases

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

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

____________ 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
Explanation:

To solve this question, the user needs to know the definition of a null value. A null value typically represents a missing or unknown value, and it is not the same as a zero or a blank space.

Option A - True: This option is incorrect. A null value is not equivalent to zero or a blank space. In programming, null is often used to indicate the absence of a value or a missing value.

Option B - False: This option is correct. A null value is not the same as zero or a blank space. It is a distinct value that represents an absence of data.

Therefore, the correct answer is:

The Answer is: B. False