Chapter 8 - Homework of Chapter 8 CIS4271/CIS6274 Fall...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Homework of Chapter 8 CIS4271/CIS6274 Fall Quarter 2007 MULTIPLE CHOICE: Choose the one alternative that best completes the statement or answers the question. 1. ( D ) The most commonly used form of join operation is the: A) outer join. B) union join. C) equi-join. D) natural join. 2. ( C ) In which of the following situations would one have to use an outer join in order to obtain the desired results? A) A report is desired that lists all customers who placed an order. B) A report is desired that lists all customers and the total of their orders. C) A report is desired that lists all customers, the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero). D) There is never a situation that requires only an outer join. 3. ( B ) One major advantage of the outer join is that: A) information is easily accessible. B) information is not lost. C) the query is easier to write. D) All of the above. 4. ( C ) A type of join implemented in SQL-1999 and by extension SQL-2003 that returns all of the data from each table that is joined is called a(n): A) outer join. B)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This homework help was uploaded on 04/17/2008 for the course CIS 4271 taught by Professor Du during the Fall '07 term at CSU East Bay.

Page1 / 4

Chapter 8 - Homework of Chapter 8 CIS4271/CIS6274 Fall...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online