Multiple Choice
Which of the following queries uses the correct SQL syntax to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
A) SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE <= 24288;
B) SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE => 24288;
C) SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288;
D) SELECT P_DESCRIPT,P_INDATE,P_PRICE,V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288;
Correct Answer:

Verified
Correct Answer:
Verified
Q1: _ words are words used by SQL
Q5: The SQL data manipulation command HAVING:<br>A) restricts
Q36: The basic SQL vocabulary has fewer than
Q41: The COMMIT command does not permanently save
Q42: A(n) _ order sequence is a multilevel
Q45: In the SQL environment, the word _
Q47: To delete an index, one must use
Q74: In Oracle,the command is used to change
Q77: The ANSI prescribes a standard SQL-the current
Q79: Some RDBMSs,such as Oracle,automatically data changes when