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: 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
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: Sep 23, 2024
- Data is redundant
- Data is consistent
- Data is intregrated
- Data error
Hide 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: Sep 23, 2024
- Sports
- Rno
- Rno, Sports
- No primary key in table
Hide 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: Sep 23, 2024
- DIFFERENT
- UNIQUE
- DISTINCT
- PRIMARY KEY
Hide 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: Sep 23, 2024
- 7
- 6
- 4
- 3
Hide 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 Questions on Reading Comprehension
Read the sentence and infer the writer's tone: "The politician's speech was filled with lofty promises and little substance, a performance repeated every election season."
- CUET (UG) - 2025
- English
- Reading Comprehension
- Read the sentence and answer the question: ``Not only did he forget my birthday, but he also ignored my calls the next day." Which of the following best describes the tone?
- CUET (UG) - 2025
- English
- Reading Comprehension
- Read the passage and answer the The Reserve Bank of India was established in the year 1935. The Central office of RBI is in Mumbai. The main function of the Reserve Bank of India is to regulate the issue of Bank Notes and keeping of reserves with a view to securing monetary stability in India. It generally operates the currency and credit system of the country to its advantage. In this passage, ‘Bank Notes’ refers to
- KMAT KERALA - 2025
- English
- Reading Comprehension
- Read the passage and answer the Animals are the most adorable and loving creatures existing on Earth. They may not be able to speak but they can understand. Domestic animals mostly move with humans. Wild animals generally live in forests. Animals play a vital role in maintaining nature’s balance. This passage primarily focused on the importance of
- KMAT KERALA - 2025
- English
- Reading Comprehension
- Read the passage and answer the A psychotropic drug is a chemical substance that changes the function of the nervous system. If the charges under the Narcotics Drugs and Psychotropic substances Act are proved, the accused will get a deterrent punishment. Police will take in drug addicts and admit them in centres for rehabilitation. This passage primarily focused on
- KMAT KERALA - 2025
- English
- Reading Comprehension
View More Questions
Questions Asked in CUET exam
- Which region was known as the ‘nursery of the Bengal Army’ as many sepoys were recruited from there?
- CUET (UG) - 2025
- British Empire
- A shopkeeper increases the price of an article by 25% and then offers a discount of 20%. What is the net percentage change in the price?
- CUET (UG) - 2025
- Percentage
- In a certain code, WATER is written as YCVGT. How is HOUSE written?
- CUET (UG) - 2025
- Coding Decoding
- A person walks 10 m North, then turns right and walks 5 m, then turns right again and walks 10 m. What direction is he facing now?
- CUET (UG) - 2025
- Direction sense
- A and B can complete a task in the ratio 3:2. If together they complete the task in 20 days, how long will A alone take?
- CUET (UG) - 2025
- Time and Work
View More Questions