好的小说应该是可读性、艺术性和思想性的完美结合，比如大仲马的小说，之所有流行百年而不衰，就是因

A. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min_salary AND t.max_salary;

B. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent

C. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary

D. You cannot find the information because there is no common column between the two tables.

A.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON e.salary BETWEEN t.min_salary AND t.max_salary;

B.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t WHERE e.salary > t.min_salary AND < t.max_salary;

C.SELECT employee_id, salary, tax_percent FROM employees e JOIN tax t ON (MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary);

D.You cannot find the information because there is nocommon column between the two tables.

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 the 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 than 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

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 the 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 than 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

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.

maryEMPLOYEE_ID NUMBERKeyVARCHAR2EMP_NAME(30)VARCHAR2JOB_ID(20)SALARY NUMBERReferencesMGR_ID NUMBEREMPLOYEE_IDcolumnDEPARTMENT_ID NUMBER Foreign key toDEPARTMENT_IDcolumn ofthe DEPARTMENTStableDEPARTMENTSNOT NULL,DEPARTMENT_ID NUMBERPrimary KeyVARCHAR2DEPARTMENT_NAME|30|ReferencesMGR_ID columnMGR_ID NUMBERof theEMPLOYEES tableTAXMIN_SALARY NUMBERMAX_SALARY NUMBERTAX_PERCENT NUMBERFor 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.

A．

B．

C．

D．

A.common currency

B.harmonized tax rates

C.harmonized tax rate structures

D.common political policy

Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee‘s manager, for all the employees who have a manager and earn more than 4000？（）

A.

B.

C.

D.

E.

A．

B．

C．

D．