When is a Cartesian product formed?
When a join condition is omitted.
When a join condition is invalid.
All rows in the first table are joined to all rows in the second table.
All of the above.
In a join condition it is mandatory to specify the table name along with the Column name.
True
False
The minimum number of join statements required to join 10 tables together are:
9
11
5
12
None of the above
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 and Double-row Functions
One-row Functions and Two-row Functions
Single-row Functions and Multiple-row 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;
99.57,99,6
99.5,99.6
99.6,99.6
99.57,99.57
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?
Table1.column1=Table2.column2
Table1.column1=Table2.column1
Table1.column2=Table2.column1