Chapter Exam

Chapter 7 Database Concepts — Online MCQ Test

Q: What does DBMS stand for?

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.

Q: In a relational database, data is primarily stored in the form of:

Answer: B. Tables — The relational model stores data in tables, also called relations. Each table contains rows and columns.

Q: Which of the following best describes a database relationship?

Answer: A. A connection between two tables — A relationship shows how tables are connected through related fields. It helps organize data efficiently.

Q: Which of the following best explains data redundancy?

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.

Q: 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?

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.

INFORMATICS PRACTICES · Grade 11 · CBSE(NCERT)

Practice Chapter 7 Database Concepts with a free chapter-wise online MCQ test for CBSE(NCERT) Grade 11 INFORMATICS PRACTICES. 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.

Questions

20m

Time Limit

Attempts Left

10 random questions from this chapter (mixed difficulty)
Questions you've seen before won't repeat until the pool resets
You have 20 minutes — exam auto-submits when time is up
Maximum 3 attempts per chapter
Results and explanations shown immediately after submission

New here? Register free — includes 3 free chapter exams.

Chapter 7 Database Concepts — Important Questions & Answers (FAQ)

Frequently asked questions from CBSE(NCERT) Grade 11 INFORMATICS PRACTICES — Chapter 7 Database Concepts, with answers and explanations. These are sample questions; the exam has its own separate question set.

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.

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.

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.

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.

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.