Ch8Questions - 1. When using an equality (=) or inequality...

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

View Full Document Right Arrow Icon
1. When using an equality (=) or inequality ( < , > , etc.) operator for a subquery, what type of value must the subquery return? a. single value b. list of values c. no value d. virtual table 2. A(n) ____ query can be used to produce a relation that retains duplicate rows. a. UNION b. UNION ALL c. INTERSECT d. MINUS 3. Assume you are using the UNION statement to combine the results from two identical tables CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains seven rows. There are two customers included in both tables. How many records are returned when using the UNION statement? a. 7 b. 10 c. 15 d. 17 4. Which data type is considered compatible with VARCHAR(35)? a. DATE b. INT c. TINYINT d. CHAR(15) 5. How many different types of outer joins exist? a. 1 b. 2 c. 3 d. 4 6. What type of subquery could be used in place of INTERSECT if the RDBMS does not support it? a. IN b. OF c. AND d. UNION 7. The Oracle string concatenation function is ____. a. CONCAT b. + c. || d. &
Background image of page 1

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

View Full DocumentRight Arrow Icon
8. The ____ statement combines rows from two or more queries without including duplicate rows. a. UNION b. UNION ALL c. INTERSECT d. MINUS 9. The Oracle ____ function replaces a null with a string in results of a query.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/24/2009 for the course CPSC 323 taught by Professor Fergany during the Summer '07 term at Slippery Rock.

Page1 / 5

Ch8Questions - 1. When using an equality (=) or inequality...

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

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