问题

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 VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
BCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
CCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
DCREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno))

参考答案

参考解析：

分类：1Z0-007题库

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

2、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...

3、Which two statements regarding a SQL p

Which two statements regarding a SQL profile are true?（）A It is built by Automatic Tuning Optimizer.B It cannot be stored persistently in the...

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 accepts user input

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）A SELECT &1, "&2" FROM &3 WH...

编辑推荐

2型滤毒罐外观呈（）色。..

TCBS平板含有下列哪种物质()..

近年来，长江洪灾频繁发生，其主要自然原因是（）①中游地区.....

演示气管位置检查。..

分析项目盈利能力的主要指标有()。①财务净现值;②财务内部收.....

某建筑施工单位（乙方与建设单位（甲方签订的合同中写明：施.....