The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（） The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（）..

第1题

A、A. SELECT * FROM emp_dept_vu; B、B. SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id; C、C. SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id; D、D. SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000 E、E. None of the statements produce an error; all are valid.

点击查看答案

第2题

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

点击查看答案

第3题

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

点击查看答案

第4题

[单选题] EXHIBIT, Emp Table Exhibit A Exhibit B 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?（）

A、Exhibit A B、Exhibit B C、The query returns no rows D、The query fails because the outer query is retrieving more than one column E、The query fails because both the inner and outer queries are retrieving data from the same table.

点击查看答案

第5题

[] Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: Which statement ensures that a value is displayed in the calculated columns for all employees?（） Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: Which statement ensures that a value is displayed in the calculated columns for all employees?（）

A、A. SELECT last_name, 12*salary* commission_pct FROM emp; B、B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp; C、C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp; D、D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

点击查看答案

第6题

[多选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER\ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column. B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column. C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table. D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence. E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table. F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

点击查看答案

第7题

[多选题] Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER\ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column. B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column. C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table. D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence. E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table. F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

点击查看答案

第8题

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

点击查看答案

第9题

[单选题] You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema. You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?（）

A、It retrieves the latest version of the table from the recycle bin B、It retrieves the oldest version of the table from the recycle bin C、It retrieves the version of the table for which undo information is available D、It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

点击查看答案

第10题

[单选题] You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?（）

A、It retrieves the latest version of the table from the recycle bin B、It retrieves the oldest version of the table from the recycle bin C、It retrieves the version of the table for which undo information is available D、It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

点击查看答案

请使用微信扫码支付