Chapter 7 Database Concepts — Online MCQ Test
INFORMATICS PRACTICES · Grade 11 · CBSE(NCERT)
Practice Chapter 7 Database Concepts with a free chapter-wise online MCQ test.
This chapter covers: Introduces Database Management Systems (DBMS) and the relational data model. Covers tables records fields attributes tuples relationships primary keys candidate keys data integrity....
AI-generated questions from basic to board-exam level, with instant results and explanations.
Chapter 7 Database Concepts — Important Questions & Answers
What does DBMS stand for?
- A. Data Base Management System
- B. Database Maintenance Software
- C. Data Backup Management Service
- D. Digital Base Management System
Answer: A. Data Base Management System
DBMS stands for Database Management System. It is software used to create, store, manage, and retrieve data from databases.
DBMS stands for Database Management System. It is software used to create, store, manage, and retrieve data from databases.
In a relational database, data is primarily stored in the form of:
- A. Graphs
- B. Tables
- C. Trees
- D. Files only
Answer: B. Tables
The relational model stores data in tables, also called relations. Each table contains rows and columns.
The relational model stores data in tables, also called relations. Each table contains rows and columns.
Which of the following best describes a database relationship?
- A. A connection between two tables
- B. A formula used in spreadsheets
- C. A type of file extension
- D. A security password rule
Answer: A. A connection between two tables
A relationship shows how tables are connected through related fields. It helps organize data efficiently.
A relationship shows how tables are connected through related fields. It helps organize data efficiently.
Which of the following best explains data redundancy?
- A. Storing the same data multiple times
- B. Deleting all records from a table
- C. Using only one table in a database
- D. Changing the database password
Answer: A. Storing the same data multiple times
Data redundancy means the repetition of the same data in multiple places. A DBMS tries to minimize this problem.
Data redundancy means the repetition of the same data in multiple places. A DBMS tries to minimize this problem.
A table has fields RollNo, AdmissionNo, and Email, each of which can uniquely identify a student. If RollNo is chosen as the primary key, what are AdmissionNo and Email called?
- A. Foreign keys
- B. Alternate keys
- C. Compound keys
- D. Derived attributes
Answer: B. Alternate keys
When one candidate key is selected as the primary key, the remaining candidate keys are called alternate keys. They still uniquely identify records.
When one candidate key is selected as the primary key, the remaining candidate keys are called alternate keys. They still uniquely identify records.