Database Management System using LibreOffice Base · Class 10 · CBSE Information Technology (402)
What is the primary purpose of a Primary Key in a relational database table?
Practice question from Database Management System using LibreOffice Base (Class 10 · CBSE Information Technology (402)), with the correct answer and a step-by-step solution.
easy · MCQ · Q-2686EA
What is the primary purpose of a Primary Key in a relational database table?
- A.To encrypt sensitive user data
- B.To uniquely identify each record in a table and prevent duplicate or null valuesCorrect answer
- C.To increase the physical storage capacity of the database
- D.To create graphical user interface forms automatically
Solution
A Primary Key ensures that every record in a table is distinct by uniquely identifying it, and it enforces entity integrity by forbidding both duplicate entries and NULL values.
More from Database Management System using LibreOffice Base
- Which of the following database objects is used to retrieve and display filtered data from one or more tables based on specific criteria in…
- Which data type in LibreOffice Base is most appropriate for storing large amounts of text, such as product descriptions or user reviews, ex…
- When creating a relationship between two tables, what is a Foreign Key?
- Explain the difference between a Form and a Report in LibreOffice Base, keeping their primary functions in mind.
Practise more Information Technology (402)
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