Question
A table T has exactly 10 rows. Its column X contains 3 NULL values among its 10 entries, and of the remaining 7 non-null values, exactly two are duplicates of each other (all other values are unique). What will SELECT COUNT(*), COUNT(
- X , COUNT(DISTINCT
- X FROM T return, respectively?
More SQL Questions
- Which SQL command is used to modify existing records in a table?
- Which SQL operator is used to search for a pattern in a column?
- In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
- In normalization, which normal form removes transitive dependencies?
- Table T has five rows and X values (10,20,NULL,20,NULL). What does SELECT COUNT(X) FROM T return?
- SQL Injection can be prevented by all EXCEPT:
- Which SQL keyword removes duplicate rows automatically from results?
- Which operator is used for pattern matching in SQL?
- A table T has exactly 10 rows. Its column X contains 3 NULL values among its 10 entries, and of the remaining 7 non-null values, exactly two are duplicates...
- 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...
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)