Question
A table T has a column score with values 10, 20, NULL, 20, 30. What does SELECT COUNT(*), COUNT(score), COUNT(DISTINCT score) FROM T return?
More SQL Questions
- Which single SQL constraint, when applied to a column, automatically enforces both uniqueness of values and a NOT NULL restriction, and is also used to uni...
- In SQL, what is the primary purpose of the GROUP BY clause?
- What is the output of this SQL snippet if the price column contains NULL values? SELECT SUM(price) FROM products;
- A table T has a column score with values 10, 20, NULL, 20, 30. What does SELECT COUNT(*), COUNT(score), COUNT(DISTINCT score) FROM T return?
- Consider two tables: Employees(EmpID, Name, DeptID) with 8 rows, and Departments(DeptID, DeptName) with 3 rows. Every employee has exactly one valid DeptID...
- A transaction in DBMS is said to be atomic if:
- A 'view' in SQL is best described as:
- Which SQL aggregate function returns the number of rows in a column that contain a non-NULL value, ignoring NULL entries in that column?
- What is the result of SELECT COUNT(NULL) on any table?
- Table T(A,B) contains: (1,NULL), (NULL,2), (3,4), (NULL,NULL). How many rows are returned by the following query? SELECT * FROM T WHERE A=3 OR B=4;
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)