dBMS Concepts Quiz

What is the primary goal of database design?

• To create an efficient, flexible, and secure structure for storing and managing data.

• To maximize the number of tables in the database

• To prioritize speed over security in data storage

• To create a visually appealing layout for the database

Explain the concept of normalization in database management.

• Normalization is the process of adding duplicate data to a database

• Normalization involves combining all tables into one large table

• Normalization does not impact data integrity in a database

• Normalization in database management is the process of organizing data in a database efficiently. It involves breaking down a table into smaller tables and defining relationships between them to reduce redundancy and improve data integrity.

How does query optimization improve database performance?

• By randomly selecting query execution plans

• By executing all queries simultaneously

• By analyzing queries and finding the most efficient way to execute them.

• By ignoring queries and focusing on hardware upgrades

What is the role of transaction management in a database system?

• Manages user authentication

• Optimizes query performance

• Ensures data redundancy

• Ensures ACID properties of transactions and maintains data integrity.

What are the different normal forms in database normalization?

• 1NF, 2NF, 3NF, BCNF, 4NF, 5NF

• 7NF

• 2NF

• 6NF

Why is it important to eliminate redundant data in a database?

• To slow down query performance

• To improve data consistency, reduce storage space, enhance data quality, and increase query performance.

• To complicate data storage

• To increase data redundancy

Explain the concept of functional dependency in normalization.

• Functional dependency in normalization is the concept where the value of one attribute uniquely determines the value of another attribute in a relation.

• Functional dependency is the same as foreign key constraint

• Functional dependency only applies to primary keys

• Functional dependency ensures data redundancy

How can denormalization be used in database design?

• Denormalization can be used to increase data integrity in the database.

• Denormalization can be used to reduce storage space in the database.

• Denormalization can be used to enforce referential integrity in the database.

• Denormalization can be used to improve read performance by reducing the number of joins needed to retrieve data.

What are the ACID properties in transaction management?

• Isolation

• Reliability

• Consistency

• Atomicity, Consistency, Isolation, Durability

• Atomicity

Describe the process of query execution in a database system.

• Query execution in a database system involves only parsing and returning the results.

• The process of query execution in a database system includes data entry, validation, and storage.

• The process of query execution in a database system includes parsing, optimizing, creating an execution plan, executing the plan, and returning the results.

• The process of query execution in a database system includes indexing, sorting, and filtering the data.