Question 1

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

technology databases

True
False

Answer

Correct Option: A

Question 2

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

technology databases

True
False

Answer

Correct Option: B

Question 3

Which of the below table is essentail when restarting a Mload Script

technology databases

Error Table
UV Table
Work Table
Log Tbale

Answer

Correct Option: D

Question 4

Select the DDL statements suppoerted by Mload

technology databases

Drop
Create
Alter
Rename

Answer

Correct Option: A

Question 5

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

technology databases

True
False

Answer

Correct Option: B

Question 6

An outer join is used to:

technology databases

Return records which have no direct match
Return records which have direct match
Return all the records
None of the above

Answer

Correct Option: A

Question 7

____________ is the outer join operator.

technology databases

(+)
(-)
(*)
+

Answer

Correct Option: A

Question 8

____________ is used to join a table to itself.

technology databases

Selfjoin
Outerjoin
innerjoin
equijoin

Answer

Correct Option: A

Question 9

The value returned by the subquery is used by the main query.

technology databases

True
False

Answer

Correct Option: B

Question 10

The minimum number of join statements required to join 10 tables together are:

technology databases

9
11
5
12
None of the above

Answer

Correct Option: A

Question 11

Sorting SQL statement result data by column alias is not possible.

technology databases

True
False

Answer

Correct Option: B

Question 12

What are the two types of SQL Functions?

technology databases

Single-row Functions and Double-row Functions
One-row Functions and Two-row Functions
Single-row Functions and Multiple-row Functions
None of the above

Answer

Correct Option: C

Question 13

Single-Row Functions can return multiple results per row.

technology databases

True
False

Answer

Correct Option: B

Question 14

What is the output of the following? SELECT ROUND(1111.93412,3) FROM DUAL;

technology databases

1112
1111.93
1111.93412
1111.934

Answer

Correct Option: D

Question 15

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

technology databases

99.57,99,6
99.5,99.6
99.6,99.6
99.57,99.57

Answer

Correct Option: B

Question 16

What does the MOD Function do?

technology databases

It divides both the values and gives the quotient.
It multiplies both the values and gives the product.
It divides both the values and gives the remainder.
There is no such function.

Answer

Correct Option: C

Question 17

A null is the same as zero or a blank space.

technology databases

True
False

Answer

Correct Option: B

Question 18

To perform wild card search “Like” is used .

technology databases

True
False

Answer

Correct Option: B

Question 19

Which of the following WHERE clauses represent equi-join?

technology databases

Table1.column1=Table2.column2
Table1.column1=Table2.column1
Table1.column2=Table2.column1
None of the above

Answer

Correct Option: B

Question 20

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

technology databases

True
False

Answer

Correct Option: B

Description: databases Online Quiz - 153
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 153

Find more quizzes from top tags