miercuri, 24 februarie 2010

Quiz: Cross joins and Natural Joins

Test: Quiz: Cross joins and Natural Joins
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
Section 1

1. What happens when you create a Cartesian product? Mark for Review
(1) Points

All rows from one table are joined to all rows of another table (*)

No rows are returned as you entered wrong join-criteria

The table is joined to itself, one column to the next column, exhausting all possibilities

All rows that do not match in the WHERE clause are displayed

Correct Correct

2. A NATURAL JOIN is based on: Mark for Review
(1) Points

Columns with the same name and datatype (*)

Columns with the same name

Columns with the same datatype and width

Tables with the same structure

Correct Correct

3. The join column must be included in the select statement when you use the NATURAL JOIN clause. True or False? Mark for Review
(1) Points


False (*)

Correct Correct

4. The ___________ join is the ANSI-standard syntax used to generate a Cartesian product. Mark for Review
(1) Points





Correct Correct


Niciun comentariu:

Trimiteți un comentariu