The ORDERS table has these columns: The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive…

The correct answer is C. SELECT customer_id, order_id, order_total E. SELECT customer_id, order_id, order_total. Answers C and E provide correct results to show. You can use BETWEEN or comparison operations to retrieve data. Incorrect Answers A: There is no RANGE ON or INCLUSIVE keyword in Oracle. B: HAVING clause can be use only in conjunction with the GROUP BY clause. D: Syntax…

Restricting and Sorting Data

Question

The ORDERS table has these columns:

The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? (Choose two.)

Options

ASELECT customer_id, order_id, order_total
BSELECT customer_id, order_id, order_total
CSELECT customer_id, order_id, order_total
DSELECT customer_id, order_id, order_total
ESELECT customer_id, order_id, order_total

How the community answered

(20 responses)

A
15% (3)
B
10% (2)
C
70% (14)
D
5% (1)

Explanation

Answers C and E provide correct results to show. You can use BETWEEN or comparison operations to retrieve data. Incorrect Answers A: There is no RANGE ON or INCLUSIVE keyword in Oracle. B: HAVING clause can be use only in conjunction with the GROUP BY clause. D: Syntax "order_total >= 100 and <= 2000" is incorrect.

Topics

#BETWEEN operator#range filtering#WHERE clause#comparison operators

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice