Multiple chices Questions:

19. How many rows would be returned from a cross join of tables A and B if A contains 10 rows and B contains 20 rows?

a. 10

b. 20

c. 30

d. 200

20. A(n) ________ will select only the rows with common values in the common columns, excluding rows with unmatched values and duplicate columns.

a. natural join

b. cross join

c. full join

d. outer join

25. Which of the following is the syntax for a left outer join?

a. SELECT column-list

FROM table1 OUTER JOIN table2 LEFT WHERE join-condition

b. SELECT column-list

FROM table1 LEFT [OUTER] JOIN table2 ON join-condition

c. SELECT column-list

WHERE LEFT table1 = table 2

d. SELECT column-list

FROM table1 LEFT table2 [JOIN] WHERE join-condition

26. ROUND(value, p) is an example of a ________.

a. numeric function

b. string function

c. conversion function

d. date and time function

27. In subquery terminology, the first query in the SQL statement is known as the ________.

a. outer query

b. nested query

c. inner query

d. base query

28. In a subquery, the ________ is executed first.

a. outer query

b. stored query

c. inner query

d. nested query

29. INSERT INTO PRODUCT SELECT * FROM P; is an example of a ________.

a. cross join

b. subquery

c. set operator

d. stored procedure

30. The most common type of subquery uses an inner SELECT subquery on the right side of a(n) ________ expression.

a. WHERE comparison

b. IN comparison

c. UNION comparison

d. EXCEPT comparison

31. When using an equality (=) or inequality (<, >, etc.) operator for a subquery, the subquery returns a ________.

a. single value

b. list of values

c. null value

d. virtual value

32. In order to compare one value to a list of values returned by a subquery, you must use a(n) ________.

a. WHERE operand

b. MINUS operand

c. ON operand

d. IN operand

33. The ________ is used to restrict the output of a GROUP BY query by applying conditional criteria to the grouped rows.

a. WHERE clause

b. HAVING clause

c. FROM clause

d. MINUS clause

34. Which of the following operators is used with subqueries that use inequality operators on a list of values?

a. IN

b. ANY

c. FROM

d. ONLY

35. In a SELECT query, the attribute list can include a subquery expression known as a(n) ________.

a. having subquery

b. correlated subquery

c. inline subquery

d. nested subquery