现有如下建表SQL语句：

CREATE TABLE departments

(

  department_id NUMBER(4) PRIMARY KEY,

  department_name VARCHAR2(20),

  city  VARCHAR2(20),

  province VARCHAR2(20)

)

下面插入语句正确的是：( )。

 A.

INSERT INTO departments VALUES(300,’abc’);

 B.

INSERT INTO departments(department_name,department_id) VALUES(300,’design’);

 C.

INSERT INTO departments(department_name,city) VALUES(‘design’,’bj’);

 D.

INSERT INTO departments VALUES(300,’abc’,null,null);