​Structure of the ORDERITEMS Table

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#) ) ;