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

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.

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.