Comprehension
A record of each student with its sports preference is given :
SPORT
Based on the data, answer the questions
SPORT
| R.no | Sports |
| 9 | Cricket |
| 13 | Football |
| 14 | Badminton |
| 16 | Football |
| 19 | NULL |
| 20 | Cricket |
| 22 | Football |
Question: 1
Identify the command to check for NULL value in sports
Identify the command to check for NULL value in sports
Updated On: Feb 21, 2026
- Select NULL from SPORT;
- Select Rno from SPORT where Sports = NULL;
- Select Rno from SPORT with NULL;
- Select Rno from SPORT where Sports IS NULL;
Show Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
The correct option is (D) :Select Rno from SPORT where Sports IS NULL;.
Was this answer helpful?
0
0
Question: 2
If Rno 14 has two Sports, then which property of RDBMS is violated.
If Rno 14 has two Sports, then which property of RDBMS is violated.
Updated On: Feb 21, 2026
- Data is redundant
- Data is consistent
- Data is intregrated
- Data error
Show Solution
Verified By Collegedunia
The Correct Option is A
Solution and Explanation
The correct option is (A) :Data is redundant.
Was this answer helpful?
0
0
Question: 3
Which column can be considered as primary key ?
Which column can be considered as primary key ?
Updated On: Feb 21, 2026
- Sports
- Rno
- Rno, Sports
- No primary key in table
Show Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
The correct option is (B) :Rno.
Was this answer helpful?
0
0
Question: 4
Name the clause used to show all different sports.
Name the clause used to show all different sports.
Updated On: Feb 21, 2026
- DIFFERENT
- UNIQUE
- DISTINCT
- PRIMARY KEY
Show Solution
Verified By Collegedunia
The Correct Option is C
Solution and Explanation
The correct option is (C) :DISTINCT.
Was this answer helpful?
0
0
Question: 5
Find the output of -
select count(Distinct Sports) from SPORT.
Find the output of -
select count(Distinct Sports) from SPORT.
select count(Distinct Sports) from SPORT.
Updated On: Feb 21, 2026
- 7
- 6
- 4
- 3
Show Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
The correct option is (D) :3.
Was this answer helpful?
0
0
Top CUET Questions
Select the statements that are CORRECT regarding patterns of biodiversity.
(A) Species diversity increases as we move away from the equator towards the poles(B) The tropical Amazon rain forest in South America has the greatest biodiversity on earth.(C) There is more solar energy available in the temperate region than tropics.(D) Tropical environments are less seasonal relatively more constant and predictableWhich of the following hormone is not produced by placenta ?
- Individuals with karyotype of 44+XXY having overall masculine development with few feminine development like Gynaecomastia has _______ chromosomal disorder.
- Match List - I with List - II.Choose the correct answer from the options given below :
List - I
List - II
A Streptokinase I Blood-Cholestrol lowering agents B Cyclosporin II Clot Buster C Statins III Propionibacterium sharmanii D Swiss Cheese IV Immuno suppressive agent Which of the following option determines percolation and water holding capacity of soils ?
View More Questions