Display employee names and dependent information using an outer join.
Use the NamanNavan (N2) Corporation database tables to design the following queries. (Use the spooling method to capture all queries and results in the CHAP7SP1.LST file.)
```
SQL> SELECT LNAME, FNAME, DEPENDENTID, DEPDOB, RELATION
2 FROM EMPLOYEE E, DEPENDENT D
3 WHERE E.EMPLOYEEID = D.EMPLOYEEID (+);
LNAME FNAME DEPENDENTID DEPDOB RELATION
--------------- --------------- ---------------- ------------ -----------
SMITH JOHN 1 12-DEC-45 SPOUSE
HOUSTON LARRY
ROBERTS SANDI
MCCALL ALEX
DEV DEREK 1 28-SEP-58 SPOUSE
DEV DEREK 2 14-OCT-88 SON
SHAW JINKU 1 10-JUN-76 SPOUSE
GARNER STANLEY
CHEN SUNNY 1 04-FEB-75 SPOUSE
CHEN SUNNY 2 23-AUG-97 SON
CHEN SUNNY 3 10-JUL-99 DAUGHTER
11 ROWS SELECTED.
```
You might also like to view...
The Windows XP __________ manages the system’s device drivers, works with the virtual memory manager to provide memory-mapped file I/O, and manages the file system buffers.
a. file system b. input output manager c. kernel d. API
Jarod wants to learn more about his options for secure transactions while conducting e-commerce. Jarod learns that all of the following are true about a one-time-use credit card number EXCEPT ____.
A. A one-time-use credit card number is called a controlled payment number. B. One-time-use credit card numbers allow consumers to make purchases while keeping their actual card numbers hidden. C. Banks and credit card companies offer this service. D. A one-time-use credit card number works for up to 10 online purchases.
Which of the following terms is NOT a synonym for the central processing unit?
A) Processor B) Brain C) Control unit D) CPU
A ________ analysis tool that is included with Excel is Goal Seek.
a. where-to b. what-now c. how-to d. what-if