Question:
What will be the result of the following SQL query?
SELECT COUNT(*) FROM Employees;
What will be the result of the following SQL query?
SELECT COUNT(*) FROM Employees;
SELECT COUNT(*) FROM Employees;
Show Hint
COUNT(*) tallies every row, NULLs included.
Updated On: Jul 2, 2026
- Returns the total number of rows in the Employees table
- Returns the total number of unique values in the Employees table
- Returns the total number of columns in the Employees table
- Returns the number of NULL values in the Employees table
Show Solution
Verified By Collegedunia
The Correct Option is A
Solution and Explanation
Step 1: COUNT(*) counts every row in the table, including rows that contain NULL values.
Step 2: The asterisk means all rows, so the result is simply the row count of the Employees table.
Step 3: DISTINCT would count unique values, and NULL handling differs only when you count a specific column, but COUNT(*) always returns the total number of rows.
Step 2: The asterisk means all rows, so the result is simply the row count of the Employees table.
Step 3: DISTINCT would count unique values, and NULL handling differs only when you count a specific column, but COUNT(*) always returns the total number of rows.
Was this answer helpful?
0
0
Top CPET Computer Science Questions
- Which of the following is a key reason for choosing DRAM over SRAM for main memory?
- Which of the following components in an FPGA is responsible for implementing combinational and sequential logic?
- What is the main purpose of declaring a base class as virtual in multiple inheritance?
- What happens if a class contains at least one pure virtual function?
- What happens if a derived class defines a function with the same name as a base class function, but with a different parameter list?
View More Questions
Top CPET Questions
- Which of the following is a key reason for choosing DRAM over SRAM for main memory?
- Which of the following components in an FPGA is responsible for implementing combinational and sequential logic?
- What is the main purpose of declaring a base class as virtual in multiple inheritance?
- What happens if a class contains at least one pure virtual function?
- What happens if a derived class defines a function with the same name as a base class function, but with a different parameter list?
View More Questions