Which SQL statement defines the FOREIG

Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? （）

A CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(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 VARCNAR2(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 VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno))

参考答案

参考解析：

分类：1Z0-007题库

相关推荐

1、Which defines the we

Which defines the welcome files in a web application deployment descriptor？（）ABCD

2、The company which is defined in the IS

The company which is defined in the ISM Code means（）Athe owner of the shipBthe manager who assumes the responsibility for operation of the shipCthe bareboat chartererDAll of the above

3、Which of the following SQL statements

Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary...

4、Which SQL statement returns a numeric

Which SQL statement returns a numeric value?（）A SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;B SELECT ROUND(hire_date) FROM EMP;C SELECT sysdate-hire_date FROM EMP;D SELECT TO_NUMBER(hire_date + 7) FROM EMP

5、Which SQL statement displays the date

Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"? （）A SELECT TO_CHAR(...

6、Which SQL statement defines a FOREIGN

Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）ACREATE TABLE EMP (empno NUMBER(4), ename VARCHAR...

编辑推荐

河南煤化集团所属每一个单位、每一位员工，都必须清楚知道企.....

Rubin将产褥期产妇的心理调适分为：__________期、_______..

慢粒白血病的临床特点（）..

下列属传播特点的为：（）。..

演员塑造角色的四个阶段可分为认识、（）、呈现、获得。..

毒蛇的毒液是从蛇的什么地方喷射而出？..