Use set operator and subquery to find employees, who do not have any dependents.

Use the N2 Corporation database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP1.LST file.)


```
SQL> SELECT Lname, Fname
2 FROM employee
3 WHERE EmployeeId IN
4 (SELECT EmployeeId FROM employee
5 MINUS
6 SELECT DISTINCT EmployeeId FROM dependent);

LNAME FNAME
--------------- ---------------
Roberts Sandi
Garner Stanley
Houston Larry
McCall Alex
```

Computer Science & Information Technology

You might also like to view...

Every month, the human resources department issues a list of employees terminated in the previous month. The security manager should:

a. Use the list to conduct an audit of computer accounts to make sure the terminated employees’ accounts have been terminated b. Make sure that computer accounts are terminated as soon as possible after the issuance of the list of terminated employees c. Request that the human resource department notify account managers of terminations daily instead of monthly d. Request that the list of terminated employees be encrypted for security reasons

Computer Science & Information Technology

Critical Thinking QuestionsCase 2-1Tom is a golf pro, and he is using Outlook to manage his schedule. Some of his customers pay him for a single lesson, while others set up regular weekly lessons. In addition, Tom is coordinating the annual two-day tournament at his local golf course.Tom wants to show his time as busy during the annual two-day tournament. Does he need to change the appointment status for the tournament's calendar item, or can he use the default status? a. Yes, he must change it from Out of Office to Busy.b. Yes, he must change it from Tentative to Busy.c. Yes, he must change it from Free to Busy.d. No, the default status for this type of calendar item is Busy.

What will be an ideal response?

Computer Science & Information Technology

What symbol may NOT be used in variable names?

A. underscore B. # C. 3 D. a

Computer Science & Information Technology

What is a gigabyte?

a. one billion bytes b. one trillion bytes c. one billion bits d. onemillion bits

Computer Science & Information Technology