

MCQOPTIONS
Saved Bookmarks
1. |
Which question corresponds best to the following query? SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2 |
A. | Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. = PRICE . Leave an empty line after every second line. |
B. | Select two columns from the COURSES table, the second one gets as title =PRICE .Sort the data according to the second column, in ascending order. |
C. | Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. = PRICE . Sort the data according to the second column, in ascending order. |
D. | Select two columns from the COURSES table, of which the second one has a constantvalue, i.e. = PRICE . Sort the data according to the second column, in ascending order |
Answer» D. Select two columns from the COURSES table, of which the second one has a constantvalue, i.e. = PRICE . Sort the data according to the second column, in ascending order | |