Multiple Choice
All of the following features of a relational query or of the relational database that it accesses are considered by the relational query optimizer, except ____.
A) whether a search argument in the query is a unique attribute in the database
B) whether a search argument in the query involves an indexed attribute
C) the number of rows of output the query produces
D) the number of rows of the database tables involved
E) whether a join attribute in the query involves an indexed attribute
Correct Answer:

Verified
Correct Answer:
Verified
Q46: A GROUP BY clause in an SQL
Q47: The SQL SELECT command is capable of
Q48: To retrieve an entire table, an SQL
Q49: The SQL SELECT LIKE operator _.<br>A) involves
Q50: Consider the following relational database for
Q52: The BETWEEN operator in the SQL SELECT
Q53: The use of a subquery in an
Q54: The SQL CREATE TABLE command is capable
Q55: A relational query optimizer _.<br>A) is a
Q56: Structured Query Language (SQL) _.<br>A) is capable