Multiple chices Questions: 19. How many rows would be returned from a cross join
ID: 3905521 • Letter: M
Question
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
Explanation / Answer
option D :: 10*20 = 200 option A :: natural join is the join which satisfies the given conditions. option B :: option A :: Numeric function ::The ROUND() function returns a number rounded to a certain number of decimal option A :: outer query is the first query in the subquery terminology. option C :: inner query is first executed in the subquery. option B :: values are fetched using the subqurey. option A :: where comparison expression's left side it is present. option A :: single value is returned option D :: IN operator is used for checking for the presence of a value in a set. option B :: HAVING is used with the group By clause option B :: ANY is used for inequality operation in subquery. option C :: This type of query is known as inline
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.