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

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

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

Select the DDL statements suppoerted by Mload

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

An outer join is used to:

____________ is the outer join operator.

____________ is used to join a table to itself.

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

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

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

What are the two types of SQL Functions?

Single-Row Functions can return multiple results per row.

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

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

What does the MOD Function do?

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

To perform wild card search “Like” is used .

Which of the following WHERE clauses represent equi-join?

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