Examine the structure of the EM

单项选择题 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?（）: 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.

热门试题