Weekly Review 9 Commentary - Question 1 Multiple Choice...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
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%
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 2

Weekly Review 9 Commentary - Question 1 Multiple Choice...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online