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

Deteriorating Personal Appearance

A noticeable decline in the upkeep or presentation of one's external look, often regarded as a potential indicator of health or psychological issues.

Rage

A strong feeling of anger that is difficult to control.

Sexual Harassment

Unwelcome sexual advances, requests for sexual favors, and other verbal or physical conduct of a sexual nature in a work or social situation.

Unwelcome Sexual Advances

Any unwelcome behavior of a sexual nature that creates an intimidating, hostile, or offensive work environment.