COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the output of the following SQL statement?SELECT Emp.Emp ____ ID, Fname, LName, SSNFROM Emp e, EmpConf cWHERE e.Emp ____ ID = c.Emp ____ ID
|
|
A list of all 20 employee IDs, names and SSNs
|
|
|
A list of only 10 employee IDs, names and SSNs
|
|
|
Error-if aliasing is used, it must be used throughout
|
|
|
Error-tables EMP and EMPCONF have nothing in common
|
Explanation:
There is 1 question to complete.