Quiz 4

Question 1

When you code a union that combines two result sets, which of the following is not true?

duplicate rows in the result set are allowed *

each result set must have the same number of columns *

the result sets must be derived from different tables

the corresponding columns in the result sets must have compatible data types

Answer 1

3rd one??

Question 2

A full outer join includes rows that satisfy the join condition, plus ___________

Show answer choices

rows in the right table that don’t satisfy the join condition

the Cartesian product of the two tables

rows in both tables that don’t satisfy the join condition

rows in the left table that don’t satisfy the join condition

Answer 2

rows in both tables that don’t satisfy the join condition

Question 3

15. Table aliases are temporary table names assigned in which clause?

Show answer choices

FROM

ORDER BY

ON

WHERE

Answer 3

FROM

Question 4

In most cases, the join condition of an inner join compares the primary key of one table to the ____________________ key of another table

Show answer choices

primary

SELECT

foreign

unique

Answer 4

foreign

Question 5

The bringing together of rows from two tables.

Answer 5

Join

Question 6

Specifies how the rows of table A are to be brought together with the rows of table B.

Answer 6

Join Condition

Question 7

For an inner join (defalut type) only rows from table A and table B that satisfy the join condition are placed on the table C. If rows exist in table A and/or table B that do not satify the join condition, these rows will not be present in table C.

Answer 7

Inner Join

Question 8

A fully qualified name consists of four parts: a server name, a database name, a schema name, and the name of the object itself. At times it will be necessary to qualify a column name (either partially or fully) to tell SQL server the source of the column.

Answer 8

Qualified Column Name

Question 9

The join syntax introduced in the SQL-92 standard.

Answer 9

explicit syntax

Question 10

Temporary table names assigned in the FROM clause.

Answer 10

correlation name or table alias

Question 11

A join where a table is joined to itself.

Answer 11

self-join

Question 12

Pre SQL92 join Syntax.

Answer 12

implicit syntax

Question 13

A join in which all the rows of a table appear in the join results, regardless of whether they have a match in the join condition.

Answer 13

Outer Join

Question 14

All of the rows in the left table appear in the join results, regardless of whether they have a match in the join condition.

Answer 14

Left Outer Join

Question 15

All of the rows in the right table appear in the join results, regardless of whether they have a match in the join condition.

Answer 15

Right Outer Join

Question 16

All of the rows in both joined tables appear in the join results regardless of whether they have a match in the join condition.

Answer 16

Full Outer Join

Question 17

Each row from table A is joined (concatenated) with each row from table B.

Answer 17

Cross Join (Cartesian Product)

Question 18

Combining the results of two or more SELECTS that return the same number of corresponding columns.

Answer 18

Union

Question 19

A union combines the rows from two or more _______

SELECT statements

string expressions

databases

tables

Answer 19

SELECT statements

Question 20

If you assign an alias to one table in a join, you have to _________

Show answer choices

use that name for the table in the query

assign one to all of the tables in the query

qualify every column name in the query

qualify all of the column names for that table

Answer 20

use that name for the table in the query

Question 21

In a join, column names only need to be qualified where?

in inner joins

when the code is confusing

in outer joins

when the same column names are used in both tables

Answer 21

when the same column names are used in both tables

Question 22

SELECT VendorName AS Vendor, InvoiceDate AS Date

FROM Vendors v JOIN Invoices i ON v.VendorID = i.VendorID;

This type of join is called _________________________

a left join

a right join

an inner join

an outer join

Answer 22

an inner join
?