[Solved] Given the table Employees with columns EmployeeID, Name, Salary, and a view EmployeeView defined as:CREATE VIEW EmployeeView AS SELECT EmployeeID, Name FROM Employees;What will the query SELECT *... | SQL

SQL - Views

Given the table Employees with columns EmployeeID, Name, Salary, and a view EmployeeView defined as:

CREATE VIEW EmployeeView AS SELECT EmployeeID, Name FROM Employees;

What will the query SELECT * FROM EmployeeView; return?

AOnly Salary column

BAll columns: EmployeeID, Name, Salary

COnly EmployeeID and Name columns

DSyntax error because Salary is missing

Step-by-Step Solution

Solution:

Step 1: Understand the view definition
The view selects only EmployeeID and Name columns from Employees.
Step 2: Determine what SELECT * from the view returns
It returns only the columns defined in the view, which are EmployeeID and Name.
Final Answer:
Only EmployeeID and Name columns -> Option C
Quick Check:
View columns = Selected columns only [OK]

Quick Trick: View shows only columns defined in its SELECT query [OK]

Common Mistakes:

MISTAKES

Master "Views" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given the table Employees with columns EmployeeID, Name, Salary, and a view EmployeeView defined as: