[Solved] Given the table Employees with columns id, name, and department, what will the following SQL return?CREATE VIEW ITStaff AS SELECT id, name FROM Employees WHERE department = 'IT';SELECT * FROM ITStaff; | SQL

SQL - Views

Given the table Employees with columns id, name, and department, what will the following SQL return?

CREATE VIEW ITStaff AS SELECT id, name FROM Employees WHERE department = 'IT';
SELECT * FROM ITStaff;

AAll employees showing id, name, and department

BAll employees with department 'IT' showing all columns

CAll employees with department 'IT' showing id and name

DSyntax error due to missing AS keyword

Step-by-Step Solution

Solution:

Step 1: Understand the view definition
The view ITStaff selects id and name from Employees where department is 'IT'.
Step 2: Analyze the SELECT from the view
Selecting from ITStaff returns only id and name columns for employees in the IT department.
Final Answer:
All employees with department 'IT' showing id and name -> Option C
Quick Check:
View filters rows and columns as defined [OK]

Quick Trick: View returns columns and rows as defined in its SELECT [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 id, name, and department, what will the following SQL return?