Database concepts Quiz Class 12 CBSE Python

1. What is a database?

A structured collection of data

A collection of files on a computer

A type of computer programming language

A graphical user interface

2. Why is a database needed in the context of information management?

To slow down data access

To limit data storage

To prevent data retrieval

To centralize and organize data

3. What is the primary purpose of a database management system (DBMS)?

To create computer programs

To facilitate internet communication

To manage and organize data in a database

To design hardware components

4. In the context of databases, what is data integrity?

The process of encrypting data

The accuracy and consistency of data

The speed of data retrieval

The amount of data storage

5. How does a relational database differ from other types of databases?

It uses a table-based structure to organize data

It stores data without any structure

It stores data in a single file

It doesn’t allow data retrieval

6. What is a relation in the context of the relational data model?

The connection between two databases

The process of data retrieval

The encryption of data

A table that stores data

7. In a relational data model, what is an attribute?

A condition for data retrieval

A column or field in a table

A foreign key linking tables

The encryption key for data

8. What is a tuple in the context of the relational data model?

A type of data encryption

A row or record in a table

A query language for databases

A primary key in a table

9. Define the term “domain” as it relates to the relational data model.

The set of allowed values for an attribute

The connection between tables

The total number of tuples in a table

The process of data insertion

10. What does the “degree” of a relation represent?

The level of encryption

The number of attributes in a relation

The number of tuples in a relation

The process of data deletion

11. In the relational data model, what is cardinality?

The process of data retrieval

The speed of data access

The number of relationships in a database

The number of tuples in a relation

12. What is a candidate key in a relational database?

An attribute with encrypted values

A key used for data retrieval

A unique identifier for a tuple in a table

The primary table in a database

13. Define the term “primary key” in the context of the relational data model.

A unique identifier for a tuple in a table

A foreign key linking tables

A secondary table in a database

The number of attributes in a relation

14. What is an alternate key in the relational data model?

An attribute with encrypted values

A key used for data retrieval

A candidate key that is not selected as the primary key

The process of data deletion

15. In the relational data model, what is a foreign key?

A key used for data retrieval

A unique identifier for a tuple in a table

An attribute with encrypted values

A field that links to the primary key in another table

Database concepts Quiz Class 12

Database concepts Quiz Class 12

Related Post

CSV File Quiz Class 12

Binary File Quiz Class 12

Text File Quiz Class 12

CBSE Python