Unit 1

Question 1

What is a Database Management System?

Answer 1

A software system that allows users to define, create, maintain, and control access to the database.

Question 2

What are the advantages of using a Database Management System?

Answer 2

Advantages include data consistency, data integrity, data security, and reduced data redundancy.

Question 3

True or False: A DBMS helps in enforcing data constraints and business rules.

Answer 3

True

Question 4

What is data redundancy?

Answer 4

Storing the same data in multiple locations, leading to inconsistencies and inefficiencies.

Question 5

What is data consistency?

Answer 5

Ensuring that data is accurate and updated across all instances in the database.

Question 6

Fill in the blank: A DBMS provides a ____________ view of the database to users.

Answer 6

Logical

Question 7

What is a primary key in a database?

Answer 7

A unique identifier for each record in a table.

Question 8

What is a foreign key in a database?

Answer 8

A field that links one table to another by referencing the primary key of another table.

Question 9

What is normalization in database management?

Answer 9

The process of organizing data in a database to reduce redundancy and improve data integrity.

Question 10

What is denormalization in database management?

Answer 10

The process of intentionally adding redundancy to speed up data retrieval.

Question 11

What is a transaction in a database?

Answer 11

A single unit of work that must be completed in its entirety or not at all.

Question 12

What is ACID in the context of database transactions?

Answer 12

Atomicity, Consistency, Isolation, Durability - properties that ensure database transactions are reliable.

Question 13

What is a database schema?

Answer 13

The structure that represents the logical view of the entire database.

Question 14

True or False: A DBMS allows multiple users to access the database simultaneously.

Answer 14

True

Question 15

What is data mining in the context of database management?

Answer 15

The process of discovering patterns and relationships in large datasets.

Question 16

What is a query in a database?

Answer 16

A request for information from a database.

Question 17

What is the role of a database administrator?

Answer 17

Responsible for managing and maintaining the database system, ensuring its security and performance.

Question 18

What is the purpose of data dictionary in a DBMS?

Answer 18

It stores metadata information about the database, such as data definitions and data relationships.

Question 19

What is a database index?

Answer 19

A data structure that improves the speed of data retrieval operations on a database table.

Question 20

What is the difference between a database and a database management system?

Answer 20

A database is a collection of related data, while a DBMS is a software system that manages the database.

Question 21

What is data warehousing?

Answer 21

The process of collecting and managing data from various sources to provide meaningful business insights.

Question 22

What is data modeling in database management?

Answer 22

The process of designing the database structure that defines the relationships between data elements.

Question 23

What is the role of SQL in database management?

Answer 23

SQL (Structured Query Language) is used to interact with and manipulate databases.

Question 24

What is a view in a database?

Answer 24

A virtual table that presents data from one or more tables in a specific format.

Question 25

What is data security in the context of database management?

Answer 25

Protecting data from unauthorized access, use, disclosure, disruption, modification, or destruction.