网友您好，请在下方输入框内输入要搜索的题目：

搜题

题目内容（请给出正确答案）

提问人：网友xiaoqi_100 发布时间：2022-01-07

[主观题]

Examine the structures of the EMPLOYEES and TAX tables.You need to find the percentage tax applicable for each employee. Which SQL statement would you use？（）

Examine the structures of the EMPLOYEES and TAX ta

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 structures of the EMPLOYEES and TAX tables.You need to find the percentage tax applicabl…”相关的问题

第1题

Click the Exhibit button to examine the structures of the EMPLOYEES and TAX tables.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 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.

点击查看答案

第2题

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

点击查看答案

第3题

Examine the data in the EMPLOYEES table:Which three subqueries work？（）

点击查看答案

第4题

Examine the description of the EMPLOYEES table:EMP_ID NUMBER（4) NOT NULLLAST_NAME VARCHAR2

Examine the description of the EMPLOYEES table:EMP_ID NUMBER(4) NOT NULLLAST_NAME VARCHAR2(30) NOT NULLFIRST_NAME VARCHAR2(30)DEPT_ID NUMBER(2)Which statement produces the number of different departments that have employees with last name Smith？（）

A. SELECT COUNT (*) FROM employees WHERE last _name=‘smith‘;

B. SELECT COUNT (dept_id) FROM employees WHERE last _name=‘smith‘;

C. SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name=‘smith‘;

D. SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name=‘smith‘;

E. SELECT UNIQE (dept_id) FROM employees WHERE last _name=‘smith‘;

点击查看答案

第5题

Tax will be levied on those employees whose payments was______.A．over $4, 000B．$40, 000C．o

Tax will be levied on those employees whose payments was______.

A．over $4, 000

B．$40, 000

C．over $40, 000

D．$4, 000

点击查看答案

第6题

After a lot of work, the artist thought that he had paid the government ________.A．less ta

After a lot of work, the artist thought that he had paid the government ________.

A．less tax than he should have

B．more tax than he should have

C．as much tax as usuall

D．just enough tax

点击查看答案

第7题

Examine the description of the EMPLOYEES table:Which statement produces the number of different departments that have employees with last name Smith？（）

A.SELECT COUNT(*) FROM employees WHERE last_name=‘Smith‘;

B.SELECT COUNT(dept_id) FROM employees WHERE last_name=‘Smith‘;

C.SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name=‘Smith‘;

D.SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name=‘Smith‘;

E.SELECT UNIQUE(dept_id) FROM employees WHERE last_name=‘Smith‘;

点击查看答案

第8题

What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?()

A.File system snapshots

B.Mysqldumpslow

C.Mysqlhotcopy

D.Mysqldump with – binary-data option

E.Mysql Enterprise Backup

点击查看答案

第9题

The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar requested a report listing the students‘ grade point averages (GPA) sorted from highest grade point average to lowest.Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?（）

A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;

C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;

D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;

E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;

F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

点击查看答案

账号：尚未登录

登录没有账号？去注册

搜题记录

联系客服

购买搜题卡

考试指南全部 >

全国自考新生注册报名时间一年有几次想要自考本科怎么自己报名报考方式是怎样的 2024自考专升本需要满足的条件与要求是什么 2024年上海自考专业一览表如何选择浙江自考专科有哪些学校怎么选择 2024年河南下半年自考本科报名时间考哪几门初中文凭怎么自考大学需要什么条件怎么自学考大专毕业证考哪些科目 2024年成人初中没毕业如何提升学历需要多少钱广东自考大专报名时间2024 考哪些内容

购买搜题卡查看答案

购买前请仔细阅读《购买须知》

请选择支付方式

微信支付

支付宝支付

点击支付即表示你同意并接受《服务协议》和《购买须知》

立即支付已付款，但不能查看答案，请点这里登录即可>>

搜题卡使用说明

1. 搜题次数扣减规则：

功能	扣减规则
功能	基础费（查看答案）	加收费（AI功能）
文字搜题、查看答案	1/每题	0/每次
语音搜题、查看答案	1/每题	2/每次
单题拍照识别、查看答案	1/每题	2/每次
整页拍照识别、查看答案	1/每题	5/每次