Could you tell me ______？A．when did you saw himB．when you saw himC．when did you see him

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.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));

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

want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use？（）

A.SELECT last_name, department_name FROM employees NATURAL JOIN departments;

B.SELECT last_name, department_name FROM employees JOIN departments ;

C.SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);

D.SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);

E.SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);

F.SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);

You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use？（）

A. SELECT last_name, department_name FROM employees NATURAL JOIN departments;

B. SELECT last_name, department_name FROM employees JOIN departments ;

C. SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);

D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);

E. SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);

F . SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id)

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