​Structure of the ORDERITEMS Table

question 31

Multiple Choice

​Structure of the ORDERITEMS table

-Based on the structure of the ORDERITEMS table,which of the following commands was most likely used to create the table?​

• A) ​CREATE TABLE orderitems (order# NUMBER (4)PRIMARY KEY, Item# NUMBER(2)PRIMARY KEY, Isbn VARCHAR2(10), Qty NUMBER(3));
• B) ​CREATE TABLE orderitems (order# NUMBER (4), Item# NUMBER(2), Isbn VARCHAR2(10), Qty NUMBER(3), NOT NULL (order#,item#));
• C) ​CREATE TABLE orderitems (order# NUMBER (4), Item# NUMBER(2), Isbn VARCHAR2(10), Qty NUMBER(3), PRIMARY KEY(order#,item#));
• D) ​CREATE TABLE orderitems (order# NUMBER (4), Item# NUMBER(2), Isbn VARCHAR2(10), Qty NUMBER(3), PRIMARY KEY(order#), PRIMARY KEY(order#));

---

Definitions:

Agricultural Products

Goods that result from the cultivation of plants and the husbandry of animals, intended primarily for food, fiber, and raw materials.

Agricultural Products

Goods produced through farming activities, including crops, livestock, and other raw materials related to agriculture.

Short-Run Instability

Fluctuations in economic activity or prices that occur within a short period of time.

Agricultural Products

Items produced through farming and agriculture, including crops, livestock, and other raw materials.