外观质量得分率，指（)外观质量实际得分占应得分数的百分数。A．单元工程B．单位工程C．单项工程D．分部

e the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed？（）

A.A

B.B

C.C

D.D

E.E

e this SQL statement:SELECT cust_id, ord_totalFROM ordersWHERE ord_total > ANY(SELECT ord_totalFROM ordersWHERE cust_id IN (SELECT cust_idFROM customers WHERE city LIKE‘New York‘));What is the result when the above query is executed？（）

A.A

B.B

C.C

D.D

E.E

to display data. You build your Web Forms for the Web application by dragging and dropping tables from the Data Connections tree in Server Explorer. You need to add a connection to your data by using the Add Connection dialog box as shown in the exhibit. During the process, you need to configure the .NET Data Provider that you use to create the data source objects. What should you do？（）

A. Right-click the connection, and click Properties. Modify the Provider property of the data connection.

B. Click the Change button, and change the data provider for the selected data source.

C. Click the Advanced button, and change the Data Source property to the target provider.

D. Click the Advanced button, and change the Application Name property to the target provider.

SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP 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.

A．120M

B．320M

C．480M

D．600M

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.

ws the monthly commission earned by the employee.Which three tasks would require subqueries or joins in order to be performed in a single step？（）

A.deleting the records of employees who do not earn commission

B.increasing the commission of employee 3 by the average commission earned in department 20

C.finding the number of employees who do NOT earn commission and are working for department 20

D.inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3

E.creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSION of the EMP table

F.decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more than 800

ws the monthly commission earned by the employee.Which two tasks would require subqueries or joins in order to be performed in a single step？ （）

A.listing the employees who earn the same amount of commission as employee 3

B.finding the total commission earned by the employees in department 10

C.finding the number of employees who earn a commission that is higher than the average commission of the company

D.listing the departments whose average commission is more than 600

E.listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID

F.listing the employees whose annual commission is more than 6000

Whatever you do, you ______ click with the right mouse button or the program will crash.

A．must not

B．don't have to

C．doesn't have to

D．needn't