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

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

您可能感兴趣的试题

Which of the following statements is CORRECT about Jennifer Fearings opinion？A．Registry fo

答案解析
Which of the following statements about mental bosses is INCORRECT？A．They lack sympathy fo

答案解析
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?()

答案解析
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.Which statement is true?()

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

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

答案解析