Solved

If the SQL Statement SELECT C1,C2,C3

Question 79

Multiple Choice

If the SQL statement SELECT C1,C2,C3
FROM T4
WHERE C2 = 'Smith';
Is frequently executed,which column(s) should be considered for indexing based only on the statement itself?


A) C1 only
B) C2 only
C) C3 only
D) C1 and C2

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q74: In Oracle Database,which of the following prefixes

Q75: For which of the following types of

Q76: Oracle Database supports the ON UPDATE CASCADE

Q77: In Oracle Database,triggers that are fired once

Q78: The PL/SQL keyword STOP HERE is used

Q80: The Oracle Database variant of SQL with

Q81: Oracle Database provides only one method for

Q82: The Oracle Database GUI tool used for

Q83: Among its many functions,SQL*Plus is also a

Q84: Which of the following Oracle Database PL/SQL