When is a Cartesian product formed?

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

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

A Non equi-join is a join condition that does not contain an equality operator.

Arithmetic expressions containing a null value evaluate to null.

Concatenation operator is

What are SQL “SELECT” statement capabilities.

To select all the columns from a table EMP, which one of the following is TRUE?

Select ename from emp where ename =”Scott”; This select statement executes successfully.

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.

Which of these is not a Single-Row Function?

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

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

Which of the following WHERE clauses represent equi-join?

An outer join is used to:

____________ is the outer join operator.

____________ is used to join a table to itself.

A Literal is enclosed in double quotes.