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
FROM Employee A LEFT OUTER JOIN Spouse B
ON A. Employee_ID = B.Employee_ID
Overall Stats
Answers
Zachery Chen from Taiwan is saying A list of all employees that have spouses, with spouse names included in the list is correct answer
Shourya Singh Rawat from India is saying Two lists : One list of employees, the other of spouses is correct answer
Mihir Shah from Majalgaon, India is saying A list of employee�??s spouses is correct answer
Shab e Zindagi from Islamabad, Pakistan is saying Two lists : One list of employees, the other of spouses is correct answer
Imran Ali from Rawalpindi, Pakistan is saying A list of all employees that have spouses, with spouse names included in the list is correct answer
Related Questions
The level of abstraction describes only part of the entire database is called?
- [A] Conceptual level
- [B] View Level
- [C] Procedural Level
- [D] None of above
The benefits of object-oriented modeling are which of the following?
- [A] The ability to tackle more challenging problems
- [B] Reusability of analysis, design, and programming results
- [C] Improved communication between users, analysts, etc.
- [D] All of the above.
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
- [A] entity integrity rule
- [B] referential integrity constraint
- [C] action assertion
- [D] composite attribute
............. is a special type of stored procedure that is automatically invoked whenever the data in the table is modified
- [A] Procedure
- [B] Trigger
- [C] cursor
- [D] none
The data model that is produced from reverse engineering is:
- [A] a conceptual model.
- [B] an internal model.
- [C] a logical model.
- [D] None of the above is correct.