Which of the following WHERE clauses represent equi-join?
Table1.column1=Table2.column2
Table1.column1=Table2.column1
Table1.column2=Table2.column1
None of the above
LAST_DAY(date) finds the date of the last day of the month that contains date.
True
False
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.
A Non equi-join is a join condition that does not contain an equality operator.
SYSDATE is a date function that returns the current database server date and time.
Which keyword used in DML statements prohibits you from changing rows that are not in the sub-query?
CHECK keyword
WITH CHECK keyword
WITH CHECK OPTION keyword
None of the Above
Explicit Defaults can be used in
INSERT statement
UPDATE statement
Both of the Above
MERGE statement
Avoids separate updates
ncreases performance and ease of use
Is useful in data warehousing applications
All of the above
Database transactions end with
COMMIT or ROLLBACK
A DDL or DCL statement executing
USER exiting iSQL*Plus or System crash
Any one of the above
You can update more than 1 row in a table with one update syntax