试题详情
- 单项选择题Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
A、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
B、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
C、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
D、CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
关注下方微信公众号，在线模考后查看
热门试题
- What are two reasons
- EvaluatetheSQLstatem
- Evaluate this SQL s
- Examine the descrip
- Which syntax turns a
- You need to design
- Which two tasks can
- Which two statements
- Which three are DATE
- Which SQL statement
- Evaluate this SQL s
- ExaminethedataoftheE
- User Mary has a view
- Which data dictionar
- The STUDENT_GRADES
- The EMPLOYEE tables
- The CUSTOMERS table
- Examine the structu
- Which statement desc
- Which two statements