单选题Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）ASELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salaryBSELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary t.min_salary, tax_percentCSELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salaryDYou cannot find the information because there is no common column between the two tables.
单选题
Examine the structures of the EMPLOYEES and TAX tables. EMPLOYEES EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT _ID column of the DEPARTMENT table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER Percentage tax for given salary range You need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）
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.
参考解析
解析：
暂无解析
相关考题：
Examine the data in the EMPLOYEES table:Which three subqueries work? () A. SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C. SELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D. SELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E. SELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F. SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
Examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:What is the result when the query is executed?() A.B.C.D. The query fails because the subquery returns more than one row.E. The query fails because the outer query and the inner query are using different tables.
Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.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.
Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?（）A.B.C.D.E.
Examine the structure of the EMPLOYEES table:What is the correct syntax for an inline view?() A.B.C.D.
Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables.EMPLOYEESNOT NULL, PrimaryEMPLOYEE_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.
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.
Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?() A.B.C.D.
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?() A.B.C.D.
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:Which UPDATE statement is valid?() A.B.C.D.
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?() A.B.C.D.
Examine the data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000...Which three subqueries work? () A. SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C. SELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D. SELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E. SELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F. SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? () A.SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department_id);B.SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);C.SELECT distinct department_id FROM employees WHERE salary ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);D.SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);E.SELECT last_name FROM employees WHERE salary ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);F.SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));
Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?() A.to find the tax percentage for each of the employeesB.to list the name, job_id, and manager name for all the employeesC.to find the name, salary, and the department name of employees who are not working with SmithD.to find the number of employees working for the Administrative department and earning less than 4000E.to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned
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 ManagerFROM employees e JOIN employees m ON (e.mgr_id = m.employee_id)AND e.salary 4000;What is its output?（）A.AB.BC.CD.DE.E
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?（）A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）A、SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C、SELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D、SELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E、SELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F、SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
单选题Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?（）AAn error is generated.BYou will have two identical tables in the HR schema with different names.CYou create a table called employees in the HR schema based on you EMP table.DYou create an alternative name for the employees table in the HR schema in your own schema.
单选题View the Exhibit and examine the details of the EMPLOYEES table. The query was written to format the PHONE_NUMBER for the employees. Which option would be the correct format in the output？（）A xxx-xxx-xxxxB （xxx） xxxxxxxC （xxx） xxx-xxxxD xxx-（xxx）-xxxx
多选题Examine the data in the EMPLOYEES table: Which three subqueries work? （）ASELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);CSELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);DSELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);ESELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);FSELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
单选题Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith? （）ASELECT COUNT (*) FROM employees WHERE last _name='smith';BSELECT COUNT (dept_id) FROM employees WHERE last _name='smith';CSELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';DSELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';ESELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';
多选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? （）AINSERT INTO employees VALUES (NULL, 'JOHN','Smith');BINSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');CINSERT INTO employees VALUES ('1000','JOHN','NULL');DINSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');EINSERT INTO employees (employee_id) VALUES (1000);FINSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',);
单选题Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid? （）ADELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);BDELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);CDELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'DDELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'
单选题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?（）ATo find the tax percentage for each of the employees.BTo list the name, job id, and manager name for all the employees.CTo find the name, salary, and department name of employees who are not working with Smith.DTo find the number of employees working for the Administrative department and earning less then 4000.ETo display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
单选题Exhibit: Examine the data in the EMPLOYEES table. Examine the subquery: SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id); Which statement is true?（）A The SELECT statement is syntactically accurate.B The SELECT statement does not work because there is no HAVING clause.C The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.D The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
单选题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?（）ATo find the tax percentage for each of the employees.BTo list the name, job id, and manager name for all the employees.CTo find the name, salary, and department name of employees who are not working with Smith.DTo find the number of employees working for the Administrative department and earning less then 4000.ETo display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.