​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:

Factor-Rating

A method used in decision making to evaluate alternative options based on a set of assigned factors and their importance.

Site Level

The specific operational context or location within an organization, often referring to a particular physical location or operational tier.

Zoning Regulations

Legal rules defining how property in specific geographic zones can be used, which may affect building types, dimensions, placement, and usage.

Community Attitudes

The prevalent beliefs, values, and opinions held by a community or society towards particular issues or subjects.