1Z0-51 QUESTION 33 CREATE TABLE中约束的语法

33. You want  to create an ORD_DETAIL table  to store details  for an order placed having  the  following 

business requirement: 

1) The order ID will be unique and cannot have null values. 
2) The order date cannot have null values and the default should be the current date. 
3) The order amount should not be less than 50. 
4) The order status will have values either shipped or not shipped. 
5) The order payment mode should be cheque, credit card, or cash on delivery (COD). 
Which is the valid DDL statement for creating the ORD_DETAIL table? 
A. CREATE TABLE ord_details    
(ord_id NUMBER(2) CONSTRAINT ord_id_nn NOT NULL,    
ord_date DATE DEFAULT SYSDATE NOT NULL,     
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min            
CHECK (ord_amount > 50),     
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk            
CHECK (ord_status IN ('Shipped', 'Not Shipped')),     
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk            
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',                     
'Cash On Delivery'))); 
B. CREATE TABLE ord_details    
(ord_id NUMBER(2) CONSTRAINT ord_id_uk UNIQUE NOT NULL,    
ord_date DATE DEFAULT SYSDATE NOT NULL,     
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min            
CHECK (ord_amount > 50),     
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk            
CHECK (ord_status IN ('Shipped', 'Not Shipped')),     
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk            
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',                     
'Cash On Delivery'))); 
C. CREATE TABLE ord_details    
(ord_id NUMBER(2) CONSTRAINT ord_id_pk PRIMARY KEY,    
ord_date DATE DEFAULT SYSDATE NOT NULL,     
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min            
CHECK (ord_amount >= 50),     
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk            
CHECK (ord_status IN ('Shipped', 'Not Shipped')),     
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk 

CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',
'Cash On Delivery')));

 D. CREATE TABLE ord_details    
(ord_id NUMBER(2),    
ord_date DATE NOT NULL DEFAULT SYSDATE,     
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min            
CHECK (ord_amount >= 50),     
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk            
CHECK (ord_status IN ('Shipped', 'Not Shipped')),     
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk            
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',                    
'Cash On Delivery'))); 

答案：C

解析：

A选项不满足要求1，ord_id只是定义了not null，并不满足唯一约束；

B选项不满足条件3，ord_amount不小于50，应该是大于等于50；

C选项满足；

D选项不满足条件1且DATE NOT NULL DEFAULT SYSDATE,语法错误。