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? （）

单选题

2022-01-04 07:50

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

查看答案

正确答案

B

试题解析

标签： 1Z0-007

感兴趣题目

Which three statements about performance analysis by SQL Performance Analyzer are true? （）

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）

Which statement correctly describes SQL and /SQL*Plus? （）

Which statement correctly describes SQL and /SQL*Plus?（）

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

Which three statements describe how the strict SQL mode provides added security?（）

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12? （）

Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?（）

Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?（）

Evaluate this SQL statement:

In the statement, which capabilities of a SELECT statement are performed?（）

Evaluate the SQL statement:

What is the result of the statement?（）

相关题目: Which of the following statements is the theme; Which of the following objects contains control structures that are considered the bound form of SQL statements?（）; Which three statements are true about adaptive SQL plan management?（）; The company which is defined in the ISM Code means（）; You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.
Which SQL statement would you use to create the view EMP_VU?（）; You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）; Which three statements describe how the strict SQL mode provides added security?（）; You execute the following PL/SQL:Which two statements are true?（）; Which statement describes the effect of the execution of the above PL/SQL block?（）; Which two statements best describe the wireless security standard that is defined by WPA (Choose two.)（）。; You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results? （）; You need to display the last names of those employees who have the letter “A” as the second character in their names.Which SQL statement displays the required results?（）; You are signing on a deck officer，who will be designated as one of the GMDSS operators，before sailing foreign．Which statement is TRUE（）.; 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? （）; Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.); You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?（）; Which two statements describe the behavior of the server's SQL mode?（）; Which two statements describe the behavior of the server's SQL mode?（）; The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）

广告位招租WX:84302438

题库考试答案搜索网

免费的网站请分享给朋友吧