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

Create your Digital Resume For FREE on your name's sub domain "yourname.wcard.io". Register Here!


Overall Stats

Attempted 238
Correct 54
Incorrect 50
Viewed 134

Answers

Guest
Guest
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

Muhammad Saleem Raza
Muhammad Saleem Raza - 4 years ago

Muhammad Saleem Raza from Lahore, Pakistan is saying A list of all employee�??s names, including the name of their spouse if they have one is correct answer

Related Questions

Which of the following is a technique for hiding the internal implementation details of an object?

  • [A] Encapsulation
  • [B] Polymorphism
  • [C] Inheritance
  • [D] All of the above.

The term Complete for a UML has the same meaning as which of the following for an EER diagram?

  • [A] Overlapping rule
  • [B] Disjoint rule
  • [C] Total specialization rule
  • [D] Partial specialization rule

The level of data abstraction which describes how the data is actually stored is?

  • [A] Physical level
  • [B] Conceptual level
  • [C] Storage Level
  • [D] File level