Multiple Choice
Regarding the interchangeability of subqueries and joins,________.
A) a join can always be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join
B) a join can sometimes be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join
C) a join can always be used as an alternative to a subquery,and a subquery can sometimes be used as an alternative to a join
D) a join can sometimes be used as an alternative to a subquery,and a subquery can always be used as an alternative to a join
Correct Answer:

Verified
Correct Answer:
Verified
Q97: The rows of the result table can
Q98: The SQL syntax JOIN ...ON can be
Q99: The SQL wildcard character "#" indicates a
Q100: To refer to a set of values
Q101: In an SQL query,which SQL keyword is
Q103: Suppose your company stores EMPLOYEE and CUSTOMER
Q104: The SQL built-in function COUNT computes the
Q105: What are SQL Built-in Functions?
Q106: When making an SQL query,we are using
Q107: In addition to being a data sublanguage,SQL