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.

View Answer

The ............ operator preserves unmatched rows of the relations being joined.

  • [A] Inner join
  • [B] Outer join
  • [C] union
  • [D] Union join

View Answer

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

View Answer

The number of attributes in relation is called as its .....................

  • [A] Cardinality
  • [B] Degree
  • [C] Tuple
  • [D] Row

View Answer

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

View Answer