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
Q1: Any create command may be reversed by
Q3: The following query totals sales in state=
Q4: In order to update data in SQL,
Q5: The CREATE SCHEMA DDL command is used
Q6: The benefits of a standardized relational language
Q7: Which of the following questions is answered
Q8: COUNT(<sup>*</sup>) tallies only those rows that contain
Q9: The FROM clause is the first statement
Q10: SQL originated from a project called System-S.
Q11: The ALTER TABLE command is used to