Multiple Choice
What result set will the following query return?
Select item_no,description
From item
Where weight > 100 and weight < 200;
A) The item_no and description for all items weighing less than 100
B) The item_no for all items weighing between 101 and 199
C) The item_no and description for all items weighing between 101 and 199
D) The item_no for all items weighing more than 200
Correct Answer:

Verified
Correct Answer:
Verified
Q7: What does the following SQL statement do?
Q13: When creating tables, it's important to decide
Q26: The WHERE clause is always processed before
Q69: DCL is used to update the database
Q89: The following query totals sales in state=
Q100: The _ contains raw data.
Q103: A view may not be updated directly
Q104: The _ is a set of commands
Q107: The DROP TABLE command causes tables to
Q109: The _ SQL command defines a logical