You need to create a table named ORDERS that contains four columns:<br /> 1.an ORDER_ID column of number data type<br /> 2.a CUSTOMER_ID column of number data type<br /> 3.an ORDER_STATUS column that contains a character data type<br /> 4.a DATE_ORDERED column to contain the date the order was placed<br /> When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead.<br /> Which statement accomplishes this?（）<p> You need to create a table named ORDERS that contains four columns:<br /> 1.an ORDER_ID column of number data type<br /> 2.a CUSTOMER_ID column of number data type<br /> 3.an ORDER_STATUS column that contains a character data type<br /> 4.a DATE_ORDERED column to contain the date the order was placed<br /> When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead.<br /> Which statement accomplishes this?（）</p>
A、A.CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );
B、B.CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
C、C.CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
D、D.CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
E、E.CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
F、F.CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );
查看正确答案
