IDS410_SampleQuestionschapter8

IDS410_SampleQuestionschapter8 - Questions from Companion...

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

View Full Document Right Arrow Icon
Questions from Companion Website Multiple Choice 1. A join where common (redundant) columns appear in the result table. Correct answer : Equi-join In an equi-join, the redundant columns demonstrate that common attributes have been matched. 2. A join where common columns appear only once in the result table. Correct answer : Natural join A natural join is the same as an equi-join except one of the duplicate columns is not shown. 3. A join where nonmatching rows are included in the result table. Correct answer : Outer join In an outer join, the nonmatching fields are included and contain null values. 4. A join that contains all columns and all rows from joined tables. Correct answer : Union Join SQL-99 allows for a UNION JOIN, which is not implemented in all DBMS products yet. 5. A subquery is enclosed in Correct answer : parentheses. 6. Using the ____ keyword in a subquery will check to see if any rows fit the conditions, not return values from particular columns. Correct answer : EXIST EXIST returns a value of true or false and is included just prior to the beginning of the subquery. 7. The ____ clause is used to combine the output from multiple queries into a single result table. Correct answer : UNION The UNION clause is used to combine query results. 8. IF-THEN-ELSE logic can be accomplished by using the ____ keyword(s) in a statement. Correct answer : CASE The CASE statement can be used to evaluate an expression that gives a value or a predicate (true, false, don’t know). 9. This data dictionary table description includes the owner of each table, table name, column
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.

Page1 / 3

IDS410_SampleQuestionschapter8 - Questions from Companion...

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