OCP 1Z0 051 36

36. Examine the following SQL commands:  
SQL>CREATE TABLE products ( 
prod_id NUMBER(3) CONSTRAINT p_ck CHECK (prod_id > 0), 
prod_name CHAR(30), 
prod_qty NUMBER(6), 
CONSTRAINT p_name NOT NULL, 
CONSTRAINT prod_pk PRIMARY KEY (prod_id)); 
SQL>CREATE TABLE warehouse ( 
warehouse_id NUMBER(4), 
roomno NUMBER(10) CONSTRAINT r_id CHECK(roomno BETWEEN 101 AND 200), 
location VARCHAR2(25), 
prod_id NUMBER(3), 
CONSTRAINT wr_pr_pk PRIMARY KEY (warehouse_id,prod_id), 
CONSTRAINT prod_fk FOREIGN KEY (prod_id) REFERENCES products(prod_id)); 
Which statement is true regarding the execution of the above SQL commands? 
A. Both commands execute successfully. 
B. The first CREATE TABLE command generates an error because the NULL constraint is not valid. 
C. The second CREATE TABLE command generates an error because the CHECK constraint is not valid. 
D.  The  first  CREATE  TABLE  command  generates  an  error  because  CHECK  and  PRIMARY  KEY 
constraints cannot be used for the same column. 
E. The first CREATE TABLE command generates an error because the column PROD_ID cannot be used 
in the PRIMARY KEY and FOREIGN KEY constraints. 

第一个语句不对（见红色部分），没有check关键字，表达式也有问题。
应为 CONSTRAINT p_name CHECK (prod_name IS NOT NULL), 

SQL> CREATE TABLE products (
  2  prod_id NUMBER(3) CONSTRAINT p_ck CHECK (prod_id > 0),
  3  prod_name CHAR(30),
  4  prod_qty NUMBER(6),
  5  CONSTRAINT p_name CHECK (prod_name IS NOT NULL),
  6  CONSTRAINT prod_pk PRIMARY KEY (prod_id));
Table created
Executed in 0.031 seconds
SQL> CREATE TABLE warehouse (
  2  warehouse_id NUMBER(4),
  3  roomno NUMBER(10) CONSTRAINT r_id CHECK(roomno BETWEEN 101 AND 200),
  4  location VARCHAR2(25),
  5  prod_id NUMBER(3),
  6  CONSTRAINT wr_pr_pk PRIMARY KEY (warehouse_id,prod_id),
  7  CONSTRAINT prod_fk FOREIGN KEY (prod_id) REFERENCES products(prod_id));
Table created
Executed in 0.062 seconds

Answer: B