DBMS Fundamentals

What is the first step in creating a table in a database management system?

• Define the table schema

• Insert data into the table

• Create the table name

• Define the table relationships

Explain the concept of query optimization in a database management system.

• Query optimization aims to increase query processing time and resource consumption

• Query optimization in a database management system is the process of selecting the most efficient query execution plan to retrieve data from the database, aiming to reduce query processing time and resource consumption.

• Query optimization has no impact on the efficiency of query execution plans

• Query optimization is the process of randomly selecting queries to execute

Why is transaction management important in a database system?

• To reduce data storage capacity

• To increase the complexity of the database system

• To ensure data integrity, consistency, and reliability by grouping multiple operations as a single unit of work.

• To slow down query processing

What is data normalization and why is it necessary in database design?

• Data normalization is essential in database design to reduce redundancy, improve data integrity, and simplify data maintenance.

• Data normalization complicates data integrity in database design.

• Data normalization is unnecessary and hinders data maintenance in database design.

• Data normalization is used to increase redundancy in database design.

What are the different normal forms in data normalization?

• 6NF

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

• 7NF

• 2NF

How does denormalization differ from normalization in database design?

• Denormalization introduces redundancy for performance optimization, while normalization eliminates redundancy to improve data integrity.

• Normalization and denormalization have the same impact on data redundancy.

• Denormalization eliminates redundancy to improve data integrity.

• Normalization increases redundancy for performance optimization.

What is the purpose of primary keys in database tables?

• Primary keys are used to uniquely identify each record in a table.

• Primary keys are used to link multiple tables together in a database.

• Primary keys are used to sort records in a table alphabetically.

• Primary keys are used to store large amounts of data in a table.

Explain the ACID properties in the context of database transactions.

• Atomicity, Consistency, Isolation, Reliability

• Atomicity, Consistency, Isolation, and Durability

• Atomicity, Consistency, Integrity, Durability

• Atomicity, Cohesion, Isolation, Durability

What is the role of indexes in improving query performance?

• Indexes improve query performance by allowing the database system to quickly locate the rows that satisfy the conditions specified in the query, reducing the need for full table scans.

• Indexes slow down query performance by increasing the time taken to retrieve data from the database

• Indexes have no impact on query performance and are purely cosmetic

• Indexes only work for specific data types and not all columns in a table

How can database triggers be used to enforce data integrity?

• Database triggers can be used to send emails

• Database triggers can be used to order pizza

• Database triggers can enforce data integrity by automatically executing actions based on specified events (e.g., insert, update, delete) to validate or constrain data.

• Database triggers can be used to play music