IBM Exam Questions

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

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.