EXHIBIT, Emp Table <img src="https://nimg.ppkao.com/2018-08/zhangxu/2018080117201979147.jpg?sign=7ed869f9d4dbebd1151d467034e09756&t=62d07c17" /> Exhibit A <img src="https://nimg.ppkao.com/2018-08/zhangxu/2018080117204388492.jpg?sign=df17038bed9a86f1e5c6d29c67f7a0b1&t=62d07c17" /> Exhibit B <img src="https://nimg.ppkao.com/2018-08/zhangxu/2018080117211213641.jpg?sign=a7b34dddffb58269c58b5288d84d9e7a&t=62d07c17" /> Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）..

第1题

A、DELETE * FROM. EMP B、DELETE FROM EMP C、TRUNCATE TABLE EMP D、DELETE TABLE EMP"

第2题

[单选题] Which is a valid CREATE TABLE statement?（）

A、CREATE TABLE EMP9$# AS (empid number(2)); B、CREATE TABLE EMP*123 AS (empid number(2)); C、CREATE TABLE PACKAGE AS (packid number(2)); D、CREATE TABLE 1EMP_TEST AS (empid number(2));

点击查看答案

第3题

[单选题] Which is a valid CREATE TABLE statement? （）

A、CREATE TABLE EMP9$# AS (empid number(2)); B、CREATE TABLE EMP*123 AS (empid number(2)); C、CREATE TABLE PACKAGE AS (packid number(2)); D、CREATE TABLE 1EMP_TEST AS (empid number(2));

点击查看答案

第4题

[单选题] 下列哪个操作可以将表中的数据删除，并且不需要回滚删除后回收其所占有的空间，但表定义保留（）

A、DELETE FROM EMP; B、TUNCATE TABLE EMP; C、TUNCATE TABLE EMP REUSE STORAGE; D、DROP TABLE EMP; E、以上所述都不正确

点击查看答案

第5题

[单选题] 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));

点击查看答案

第6题

[单选题] 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));

点击查看答案

第7题

[单选题] 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));

点击查看答案

第8题

[] 有如下三步操作,并且均成功执行,请选择结果（） delete from emp; alter table emp add(addr varchar2(40)); rollback; 有如下三步操作,并且均成功执行,请选择结果（） delete from emp; alter table emp add(addr varchar2(40)); rollback;

A、A. emp表中数据处于回滚段中 B、B. emp表中的数据被永久删除 C、C. emp表中的数据没有变化 D、D. 原来的emp表中的数据被添加到新emp表中 E、E. 以上所述都不正确

点击查看答案

第9题

[] View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table： ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY （emp_id） USING INDEX emp_id_idx； Which statement is true regarding the effect of the command？（） View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：

A、A. The PRIMARY KEY is created along with a new index. B、B. The PRIMARY KEY is created and it would use an existing unique index. C、C. The PRIMARY KEY would be created in a disabled state because it is using an existing index. D、D. The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.

点击查看答案

请使用微信扫码支付