attention
function
exception
perception
第1题:
ExhibitExamine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their manager‘s last names and their department names. Which query would you use?()
A. SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN department d ON (e.department_id = d.department_id);
B. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.managaer_id = m.employee_id) LEFT OUTER JOIN department d ON (e.department_id = d.department_id);
C. SELECT e.last_name, m.last_name, department_name FROM employees e RIGT OUTER JOIN employees m on ( e.manager_id = m.employee_id) FULL OUTER JOIN department d ON (e.department_id = d.department_id);
D. SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGT OUTER JOIN department d ON (e.department_id = d.department_id);
E. SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id)
F. SELECT last_name, manager_id, department_name FROM employees e JOIN department d ON (e.department_id = d.department_id);
第2题:
You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.
The customer service representatives in your company add and edit the information in the complaints table. They work with this table by using a number of client applications, including a web-based application and a Microsoft Windows 32-bit application.
The customer service manager discovers that some customer complaints are marked as closed before they are resolved to the customer’s satisfaction.
You need to notify the customer service manager whenever a complaint is marked as closed. You do not want to make any changes to the client applications.
What should you do?
A.Create an UPDATE trigger that sends an e-mail message.
B.Create a stored procedure that sends an e-mail message. Use the stored procedures to make changes to the data.
C.Create a user-defined function that sends an e-mail message. Use the function to make changes to the data.
D.Create a rule that validates data entry. Bind the rule to the CompliantClosed column.
第3题:
第4题:
第5题:
第6题:
第7题:
his company doesn’t have enough staff to provide good customer service.
the sales in his company is decreasing gradually.
the customers’ complaints are on the rise.
第8题:
第9题:
if customer complaints go unnoticed by the management
unless foreign companies are introduced in greater numbers
if there’s no competition among companies
without strict routine of employees
第10题:
SELECT last_name, department_name FROM employees NATURAL JOIN departments;
SELECT last_name, department_name FROM employees JOIN departments ;
SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
第11题:
Create a reverse lookup zone in DNS for each new Domain.
Add a WINS lookup record to the DNS forward lookup zone.
Add a WINS reverse record to the DNS reverse lookup zone.
Enable Dynamic updates for DownLevel client computers on each DHCP server.
Install the Active Directory Client on All Computers in the Customer service department.
第12题:
attention
function
exception
perception
第13题:
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees‘ last names, along with their managers‘ last names and their department names. Which query would you use?()
A.SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN departments d ON (e.department_id = d.department_id);
B.SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
C.SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
D.SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
E.SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
F.SELECT last_name, manager_id, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id) ;
第14题:
第15题:
第16题:
第17题:
第18题:
Seamen on board the ship are in two departments: Deck Department, Engine Department.
Seaman on board the ship are in two department: Deck Department, Engine Department and Service Department.
The Deck Department and the Engine Department are the two departments.
Seamen on board the ship are in three departments: the Deck Department, the Engine Department and the Service Department.
第19题:
第20题:
overemphasis on the service format
decreased corporate revenue
misunderstanding of customer satisfaction
customers’ complaints
第21题:
On
In
For
With
第22题:
SELECT last_name, department_name FROM employees , departments(+);
SELECT last_name, department_name FROM employees JOIN departments(+);
SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d
SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id);
SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);
第23题:
overemphasis on the service format.
decreased corporate revenue.
misunderstanding of customer satisfaction.
customers’ complaints.
第24题:
Call the Customer Service Center
Send payment to the utilities firm
Review two bills from last year
Verify her account balance