[Solved] Consider a view EmployeeSalaries created as:CREATE VIEW EmployeeSalaries AS SELECT EmployeeID, Salary FROM Employees WHERE Salary > 50000;If the Employees table has 100 rows with 30 employees earning... | SQL

SQL - Views

Consider a view EmployeeSalaries created as:

CREATE VIEW EmployeeSalaries AS SELECT EmployeeID, Salary FROM Employees WHERE Salary > 50000;

If the Employees table has 100 rows with 30 employees earning more than 50000, what will SELECT COUNT(*) FROM EmployeeSalaries; return?

AAn error due to missing columns

B100

C30

D0

Step-by-Step Solution

Solution:

Step 1: Understand the view filter condition
The view includes only employees with Salary > 50000.
Step 2: Count rows matching the condition
Given 30 employees meet this condition, the count from the view is 30.
Final Answer:
30 -> Option C
Quick Check:
View row count = Filtered rows count [OK]

Quick Trick: View row count matches filtered base table rows [OK]

Common Mistakes:

MISTAKES

Master "Views" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider a view EmployeeSalaries created as: