7 years ago in Database Management System

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
Loading...
Next Question

Overall Stats

Attempted 241
Correct 54
Incorrect 51
Viewed 136

Answers

Guest
Guest
Zachery Chen
Zachery Chen - 1 month ago

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
Shourya Singh Rawat - 4 years ago

Shourya Singh Rawat from India is saying Two lists : One list of employees, the other of spouses is correct answer

Mihir Shah
Mihir Shah - 4 years ago

Mihir Shah from Majalgaon, India is saying A list of employee�??s spouses is correct answer

Shab e Zindagi
Shab e Zindagi - 4 years ago

Shab e Zindagi from Islamabad, Pakistan is saying Two lists : One list of employees, the other of spouses is correct answer

Imran Ali
Imran Ali - 4 years ago

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

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.