Chapter 8 (Multiple Choice CIS 3365)

1. The following SQL statement uses a(n) ____.SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAMEFROM PRODUCT, VENDORWHERE PRODUCT.V_CODE = VENDOR.V_CODE;

2. When using a(n) ____ join, only rows that meet the given criteria are returned.

3. The statement SELECT * FROM T1, T2 produces a(n) ____ join.

4. How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

5. A(n) ____ join will select only the rows with common values in the common attribute(s).

6. If you wish to create an inner join, but the two tables do not have a commonly named attribute, you can use a(n) ____ clause.

7. The ANSI standard defines ____ type(s) of outer join(s)

8. A(n) ____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

9. The syntax for a left outer join is ____.

10. A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.

11. A ____ is a query (SELECT statement) inside a query.

12. In subquery terminology, the first query in the SQL statement is known as the ____ query.

13. In a subquery, the ____ query is executed first

14.The ____ function returns the current system date in MS Access.

15. When using the Oracle TO_DATE function, the code ____ represents a three-letter month name.

16. The Oracle ____ function returns the current date

17. In Oracle, the ____ function converts a date to a character string.

18. The Oracle string concatenation function is ____.

19. When using the Oracle TO_NUMBER function to convert a character string into a number, ____represents a digit.

20. ____ is a relational set operator.

21. “Union-compatible” means that the ____.

22. The ____ data type is considered compatible with VARCHAR(35).

23. The Oracle ____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

24. The ____ data type is compatible with NUMBER.

25. The ____ query combines rows from two queries and excludes duplicates.

26. The syntax for the UNION query is ____.

27. Assume you are using the UNION operator to combine the results from two tables with identical structure,CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUS-TOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION operator?

28. Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUS-TOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL
operator?

29. Assume you are using the INTERSECT operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUS-TOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the INTERSECT operator?

30. The ____ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.

31. Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the MINUS operator?

32. The ____ operator could be used in place of INTERSECT if the RDBMS does not support it.

33. The ____ operator could be used in place of MINUS if the RDBMS does not support it.

34. The Oracle equivalent to an MS Access AutoNumber is a(n) ____.

35. The ____ pseudo-column is used to select the next value from a sequence.

36. A(n) ____ is a block of code (containing standard SQL statements and procedural extensions) that is stored and executed at the DBMS server.

37. In Oracle, ____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

38. The PL/SQL block starts with the ____ clause.

39. Oracle recommends ____ for creating audit logs.

40. A stored function uses the ____ statement to return a value.