PrepAway - Latest Free Exam Questions & Answers

which of the following describes the order of the rows in the result data set produced?

Given the following table definition:
SALES

———————————————
INVOICE_NO CHAR(20) NOT NULL
SALES_DATE DATE
SALES_PERSON CHAR(20)
REGION CHAR(20)
SALES INTEGER
If the following SELECT statement is executed, which of the following describes the order of the
rows in the result data set produced?
SELECT * FROM sales

PrepAway - Latest Free Exam Questions & Answers

A.
The rows are sorted by INVOICE_NO in ascending order.

B.
The rows are sorted by INVOICE_NO in descending order.

C.
The rows are ordered based on when they were inserted into the table.

D.
The rows are not sorted in any particular order.

One Comment on “which of the following describes the order of the rows in the result data set produced?


Leave a Reply