•
Question 1: Multiple Choice
Average Score 1.58185 points
Which of the following is valid SQL command?
(Assume that all the mentioned fields are in the table)
Correct
Percent Answered
Select title from books where price > 10
79.093%
Select title and author from books
3.748%
Select * from books where author = James
15.187%
Select from books where price <10 or >15
1.972%
Unanswered
0%
•
Question 2: Multiple Choice
Average Score 1.6213 points
What are "the number of fields" and "the order of results" from the following query?
(Assume that "
books
" table has 5 fields in total)
Select author, price, year from books where price < 10 and year >
1995 order by year
Correct
Percent Answered
The number of fields: 3, The order of results: Ascending
81.065%
The number of fields: 5, The order of results: Descending
1.972%
The number of fields: 3, The order of results: Descending
6.903%
The number of fields: 5, The order of results: Ascending
7.298%
The number of fields: 2, The order of results: Ascending
1.183%
The number of fields: 2, The order of results: Descending
0.986%
Unanswered
0.592%
•
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Spring '08
 Sheikh,N
 MYSQL , PostgreSQL, Microsoft SQL Server, KAI ZHAO

Click to edit the document details