0

databases Online Quiz - 153

Description: databases Online Quiz - 153
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

IGNORE DUPLICATE ROWS does not apply if there are any unique indexes in the table.

  1. True

  2. False


Correct Option: A

The DELETE with a WHERE clause starts a period(.) in MLOAD

  1. True

  2. False


Correct Option: B

Select the DDL statements suppoerted by Mload

  1. Drop

  2. Create

  3. Alter

  4. Rename


Correct Option: A

In a join condition it is mandatory to specify the table name along with the Column name.

  1. True

  2. False


Correct Option: B

An outer join is used to:

  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


Correct Option: A
  1. Selfjoin

  2. Outerjoin

  3. innerjoin

  4. equijoin


Correct Option: A

What are the two types of SQL Functions?

  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


Correct Option: C

Single-Row Functions can return multiple results per row.

  1. True

  2. False


Correct Option: B

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

  1. 99.57,99,6

  2. 99.5,99.6

  3. 99.6,99.6

  4. 99.57,99.57


Correct Option: B

What does the MOD Function do?

  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.


Correct Option: C

Which of the following WHERE clauses represent equi-join?

  1. Table1.column1=Table2.column2

  2. Table1.column1=Table2.column1

  3. Table1.column2=Table2.column1

  4. None of the above


Correct Option: B
- Hide questions