Examine the data in the EMPLOYEES and DEPARTMENTS tables: Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: What happens when you execute the DELETE statement?()
You are the desktop administrator for your company. All employees in the graphics department use identical dual-processor Windows XP Professional computers. The employees in the graphics department use only 32-bit Windows applications. Veronica is a user in the graphics department. Veronica reports poor system performance when she runs a certain custom application. The application was designed for multiprocessor use with Windows 2000. Veronica reports that the performance problems have only recently begun. You run Task Manager on Veronica's computer. You view the performance statistics shown in the exhibit. You need to improve application performance on Veronica's computer. What should you do?()
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: Evaluate this SQL statement: Which SQL statement is equivalent to the above SQL statement?()
Practice 6 ● In your company twenty employees receive, at the company’s expense, a personal copy of a daily financial newspaper, which they collect from reception each day. There have been disputes with the newspaper deliveryman about the correct number that should be delivered.
● Your manager has asked you to investigate and you have discovered:
● Employees who are not entitled to newspapers take them from reception.
● The newspapers are delivered. And taken, before the receptionist arrives for work.
● There are spare copies when employees are absent or away on business trips.
● Write a short report of 200—250 words to your manager suggesting how to make sure that the correct number of newspapers is delivered each day and that the right person receive them.
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. EMPLOYEES NOT NULL, EMPLOYEE_ID NUMBER Primary Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, Primary DEPARTMENT_ID NUMBER Key VARCHAR2 DEPARTMENT_NAME (30) References NGR_ID MGR_ID NUMBER column of the EMPLOYEES table Foreign key to LOCATION_ID NUMBER LOCATION_ID column of the LOCATIONS table LOCATIONS NOT NULL, Primary LOCATION_ID NUMBER Key VARCHAR2 CITY |30) Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()
An administrator only has one public IP address that must be shared among five employees. Which of the following network schemes should be used?()
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?()
What is true about employees paid wages by the hour?
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement?()
You need to display the last names of those employees who have the letter “A” as the second character in their names.Which SQL statement displays the required results?()