How many copies of the database schema are typically used in the redesign process?

What is the result of the following SQL statement ?

SELECT A.Employee_Name, B.Spouse_Name
FROM Employee A LEFT OUTER JOIN Spouse B
ON A. Employee_ID = B.Employee_ID

• [A] A list of employee�??s spouses
• [B] A list of all employees that have spouses, with spouse names included in the list
• [C] A list of all employee�??s names, including the name of their spouse if they have one
• [D] Two lists : One list of employees, the other of spouses

Which of the following SQL statements are helpful in database redesign?

• [A] Correlated subqueries only
• [B] EXISTS/NOT EXISTS expressions only
• [C] Both of the above are helpful
• [D] None of the above are helpful.

How is it possible that both programs and data can be stored on the same floppy disk?

• [A] Floppy disks can only store data, not programs
• [B] Programs and data are both software, and both can be stored on any memory device
• [C] A floppy disk has to be formatted for one or for the other
• [D] A floppy disks has two sides, one for data and one for program

In an ER model, ................ is described in the database by storing its data.

• [A] Entity
• [B] Attribute
• [C] Relation ship
• [D] Notation

Which of the following applies to a class rather than an object?

• [A] Query
• [B] Scope
• [C] Update
• [D] Constructor