5 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 360
Correct 78
Incorrect 83
Viewed 199

Answers

Guest
Guest
Tsega Asresa Mengistu
Tsega Asresa Mengistu - 1 week ago

Tsega Asresa Mengistu from Dessie, Ethiopia is saying Two lists : One list of employees, the other of spouses is correct answer

Serkie Mekonnen
Serkie Mekonnen - 1 week ago

Serkie Mekonnen from Dessie, Ethiopia is saying Two lists : One list of employees, the other of spouses is correct answer

Abdul Haseeb Shershahabadi
Abdul Haseeb Shershahabadi - 1 month ago

Abdul Haseeb Shershahabadi from Birpur, India is saying A list of all employee�??s names, including the name of their spouse if they have one is correct answer

Deep
Deep - 1 month ago

Deep from Kolkata, India is saying A list of all employees that have spouses, with spouse names included in the list is correct answer

indhuja indhuja
indhuja indhuja - 4 months ago

indhuja indhuja from Erode, India is saying A list of all employees that have spouses, with spouse names included in the list is correct answer

Related Questions

SQL stands for ________ .

  • [A] Structured Question Language
  • [B] Structured Query Language
  • [C] Sequential Question Language
  • [D] Sequential Query Language

View Answer

Which one of the following is provided by a data dictionary ?

  • [A] User data
  • [B] Database structure data
  • [C] Sorted data
  • [D] Functional data

View Answer

DBMS is a collection of .............. that enables user to create and maintain a database.

  • [A] Key
  • [B] Program
  • [C] Translator
  • [D] none

View Answer

Which of the following modifications may not succeed?

  • [A] Changing a column data type from char to date
  • [B] Changing a column data type from numeric to char
  • [C] Both of the above actions should succeed.
  • [D] Neither of the above actions will succeed.

View Answer

In an object oriented model, one object can access data of another object by passing?

  • [A] Instance variable
  • [B] Variable
  • [C] Message
  • [D] Function

View Answer