Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME |30| References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?（）

发布日期：2020-04-10

A.To find the tax percentage for each of the employees.

B.To list the name, job id, and manager name for all the employees.

C.To find the name, salary, and department name of employees who are not working with Smith.

D.To find the number of employees working for the Administrative department and earning less then 4000.

E.To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.

热门试题

热门资讯

暂无相关推荐~