A subquery in an SQL SELECT statement:%! – McqOptions

MCQOPTIONS

1.	A subquery in an SQL SELECT statement:%!
A.	can only be used with two tables.
B.	can always be duplicated by a join.
C.	has a distinct form that cannot be duplicated by a join.
D.	cannot have its results sorted using ORDER BY.
Answer» D. cannot have its results sorted using ORDER BY.

Discussion

No Comment Found

Related MCQs

If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.~!
To establish a range of values, < and > can be used.~!
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.~!
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.~!
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.~!
Indexes can usually be created for both primary and secondary keys.~!
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.%!
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.%!
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.%!
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.%!