Database Management System · Class 12 · CBSE · Science Computer Science
A relation named STUDENT has attributes RollNo, Name, Class and Email. RollNo is unique and never contains a NULL value, while the other attributes m…
Practice question from Database Management System (Class 12 · CBSE · Science Computer Science), with the correct answer and a step-by-step solution.
easy · MCQ · Q-9A4967
A relation named STUDENT has attributes RollNo, Name, Class and Email. RollNo is unique and never contains a NULL value, while the other attributes may contain duplicate values. Which attribute is most suitable as the primary key?
- A.Name
- B.Class
- C.RollNoCorrect answer
- D.Email
Solution
A primary key uniquely identifies every record and cannot contain NULL values. RollNo satisfies both conditions.
More from Database Management System
- Whatever whatever we do do do ???
- Test
- A relation named Employee has the attributes EmpID, EmpName, Department and Salary. Which SQL query displays the names of employees who bel…
- Explain why storing several phone numbers as a single comma-separated value in one attribute violates First Normal Form (1NF). Suggest a su…
Practise more Computer Science
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed