Tag: databases

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.

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.

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?