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


True


False (*)



Correct Correct


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


NATURAL


ALL


FULL


CROSS (*)



Correct Correct

http://www.materie.ro/materie/test-quiz-cross-joins-and-natural-joins-49

Niciun comentariu:

Trimiteţi un comentariu