问题

Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? ()

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));

参考答案

您可能感兴趣的试题

Using the #define statement, how would you declare a manifest constant that returns th

答案解析
Using the #define statement, how would you declare a manifest constant that returns th

答案解析
Examine this command:SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’ ‘CUSTOMERS’ ‘PUBLISH’ ‘false’);Which three statements are true about the effect of this command?()

答案解析
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 greater than $30 000?()

答案解析
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()

答案解析
Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?()

答案解析