Click the Exhibit button to examine the data of the EMP_建筑考试题库网

1Z0-007

单项选择题

Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement:
SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager"
FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id)
AND e.salary > 4000;
What is its output?（）

A.A
B.B
C.C
D.D
E.E

相关考题

多项选择题 For which two actions can you use the TO_DATE function? （）

多项选择题 Evaluate the SQL statement: TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

单项选择题 Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）

All Rights Reserved 版权所有©建筑考试题库(jzkao.com)

备案号：湘ICP备2020024380号-3