offering some employees more and the other less.
relating the customers to the employees’ benefits.
varying benefits according to different employees.
dividing employees into different groups.
第1题:
Click the Exhibit button to examine the data of the EMPLOYEES table.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.SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;
B.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;
C.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id) AND e.salary > 4000;
D.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.mgr_id "Mgr_id", m.emp_name "Manager" FROM employees e SELF JOIN employees m WHERE e.mgr_id = m.employee_id AND e.salary > 4000;
E.SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.mgr_id "Mgr_id" m.emp_name "Manager" FROM employees e JOIN employees m USING (e.employee_id = m.employee_id) AND e.salary > 4000;
第2题:
第3题:
第4题:
第5题:
第6题:
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? ()
第7题:
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?()
第8题:
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?()
第9题:
Many employees don’t like a conservative dress code.
Comfortable clothes make employees more productive.
A casual clothes code is welcomed by young employees.
All the employers in the U. S. are for casual office wear.
第10题:
802.1
Framerelay
HDLC
PPP
SLIP
PAP
第11题:
saving employees’ money
making employees more attractive
improving employees’ motivation
making employees happier
第12题:
treat employees as customers.
stress the benefits of the changes.
talk employees into accepting the changes.
act quickly according to the reactions of employees.
第13题:
The Testking network is implementing dialup services for their remote employees.Testking uses several different Layer 3 protocols on the network. Authentication ofthe users connecting to the network is required for security. Additionally, some employees will be dialing long distance and will need callback support.Which protocol is the best choice for these remote access services?()
A.802.1
B.Framerelay
C.HDLC
D.PPP
E.SLIP
F.PAP
第14题:
第15题:
第16题:
第17题:
In which scenario would TOP N analysis be the best solution? ()
第18题:
Which three statements inserts a row into the table?()
第19题:
You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?()
第20题:
meet changing demands of employees.
check benefits as closely as they do with other investments.
put more emphasis on talent investments.
cut back on the investments in benefits.
第21题:
DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
第22题:
DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);
DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'
DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'
第23题:
MERGE
INSERT
UPDATE
ADD
ENTER
You cannot enter the phone numbers for the existing employee records.