If the following SQL statements are executed in the order shown:
CREATE TABLE orders
(order_num INTEGER NOT NULL,
buyer_name VARCHAR(35),
amount NUMERIC(5,2));
CREATE UNIQUE INDEX idx_orderno ON orders (order_num);
Which of the following describes the resulting behavior?
A.
Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried
rows should be displayed in order of increasing ORDER_NUM values
B.
Every ORDER_NUM value entered must be unique; whenever the ORDERS table is queried
rows will be displayed in no particular order
C.
Duplicate ORDER_NUM values are allowed; no other index can be created for the ORDERS
table that reference the ORDER_NUM column
D.
Every ORDER_NUM value entered must be unique; no other index can be created for the
ORDERS table that reference the ORDER_NUM column