An employee stock ownership plan （ESOP) is an employee-owner program that provides a compa

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATEYou issue these statements:CREATE table new_emp ( employe_id NUMBER, name VARCGAR2(30));INSERT INTO new_emp SELECT employee_id, last_name from employees; Savepoint s1;UPDATE new_emp set name = UPPER(name);Savepoint s2;Delete from new_emp;Rollback to s2;Delete from new_emp where employee_id=180;UPDATE new_emp set name = ‘James‘;Rollback to s2;UPDATE new_emp sey name = ‘James‘ Where employee_id=180; Rollback;At the end of this transaction, what is true? （）

A. You have no rows in the table.

B. You have an employee with the name of James.

C. You cannot roll back to the same savepoint more than once.

D. Your last update fails to update any rows because employee ID 180 was already deleted.

When an employee stops working in the company, all of the following should be done except______.

A．a termination notice should be issued by the personnel department

B．a copy of the termination authorization should be given to the employee personally

C．a copy of the termination authorization should be sent to the employee"s supervisor

D．a copy of the termination authorization be delivered to the payroll register

The Premium Pension Authority ______.

A．provides several funds for employees to choose

B．is a non-governmental agency

C．pays the pension for people

D．centrally administers premium pension contributions and fund choices

What does Mr. Robert Wright think about an employee who intentionally destroyed the company property?

A．Warning and dismissal

B．Payment for damages only

C．Dismissal and payment

D．Dismissal only

The EMPLOYEES table contains these columns:LAST_NAME VARCHAR2 (25)SALARY NUMBER (6,2)COMMISSION_PCT NUMBER (6)You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value. Evaluate the SQL statement:SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEESWHERE COMMISSION_PCT IS NOT NULL;What does the statement provide? （）

A. All of the desired results

B. Two of the desired results

C. One of the desired results

D. An error statement

Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)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.

B.

C.

D.

E.

Ezonexam has 50 offices. The employees in these offices have limited knowledge of Windows 2000. Each office has a network of between five and 20 client computers. The office networks are connected to each other. The company is buying 50 identical computers to run Windows 2000 Server in these offices. The server must be installed to the company's standard configuration. You use Setup Manager to create a network shared distribution folder and a Unattend.txt file that specifies the company's standard configuration.

You want to automate the installation process as much as possible, in the least possible amount of time.

What should you do?

A．Run Makebt32.exe to create four installation startup disks and add the Unattend.txt file to the first disk. Instruct an employee at each office to start the installation by using these disks.

B．Create a Microsoft MS-DOS network boot disk that makes a connection to the network shared distribution folder and runs the winnt command with the /s and /u switches. Instruct an employee at each office to start the installation by using this disk.

C．Create a floppy disk that contains only the Unattend.txt file. Instruct an employee at each office to start the installation by using the Windows 2000 Server compact disc, with the floppy disk inserted.

D．Create a Windows 2000 folder on a hard disk. Copy the Windows 2000 Server compact disc to the folder. Add the Unattend.txt file to the folder. Copy the folder to a writeable CD. Instruct an employee at each office to start the installation by suing this CD.

A、are given

B、give

C、will give

D、were given

Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type RemarksEMPLOYEE_ID NUMBER NOT NULL, Primary KeyEMP_NAME VARCHAR2 (30)JOB_ID VARCHAR2 (20)SALARY NUMBERMGR_ID NUMBER References EMPLOYEE_ID COLUMNDEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS tableDEPARTMENTSColumn name Data type RemarksDEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30)MGR_ID NUMBER References MGR_ID column of the EMPLOYEES tableEvaluate this SQL statement:SELECT employee_id, e.department_id, department_name, salaryFROM employees e, departments dWHERE e. department_id = d.department_id;Which SQL statement is equivalent to the above SQL statement? （）

A. SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);

B. SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;

C. SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;

D. SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);

Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement: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;What is its output?（）

A.A

B.B

C.C

D.D

E.E