Comprehension

A record of each student with its sports preference is given :
SPORT
R.noSports
9Cricket
13Football
14Badminton
16Football
19NULL
20Cricket
22Football
Based on the data, answer the questions

Question: 1

Identify the command to check for NULL value in sports

Updated On: Sep 23, 2024
  • 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;
Hide Solution
collegedunia
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.

Updated On: Sep 23, 2024
  • Data is redundant
  • Data is consistent
  • Data is intregrated
  • Data error
Hide Solution
collegedunia
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 ?

Updated On: Sep 23, 2024
  • Sports
  • Rno
  • Rno, Sports
  • No primary key in table
Hide Solution
collegedunia
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.

Updated On: Sep 23, 2024
  • DIFFERENT
  • UNIQUE
  • DISTINCT
  • PRIMARY KEY
Hide Solution
collegedunia
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.

Updated On: Sep 23, 2024
  • 7
  • 6
  • 4
  • 3
Hide Solution
collegedunia
Verified By Collegedunia

The Correct Option is D

Solution and Explanation

The correct option is (D) :3.
Was this answer helpful?
0
0

Top Questions on Reading Comprehension

View More Questions