DBMS-18CBC207T

What is normalization in the context of database management systems?

• Normalization is the process of adding redundancy to a database to improve performance.

• Normalization in database management systems is the process of organizing a database to reduce redundancy and dependency by dividing large tables into smaller ones and defining relationships between them.

• Normalization involves combining multiple tables into one to simplify the database structure.

• Normalization is only applicable to non-relational databases.

Explain the importance of query optimization in database management systems.

• Query optimization has no impact on system efficiency

• Query optimization is important in database management systems to enhance performance, reduce response times, minimize resource consumption, and improve overall system efficiency.

• Query optimization only focuses on increasing resource consumption

• Query optimization is irrelevant in database management systems

What is transaction management and why is it crucial in databases?

• Transaction management is crucial in databases to maintain data integrity and reliability.

• Transaction management is primarily focused on database security.

• Transaction management ensures high availability of databases.

• Transaction management is used for data analysis in databases.

How does indexing improve the performance of database queries?

• Indexing creates a data structure for faster data retrieval.

• Indexing increases database storage requirements

• Indexing slows down data retrieval

• Indexing has no impact on query performance

Discuss the concept of concurrency control in database systems.

• Concurrency control in database systems is essential to prevent issues like lost updates, uncommitted data, and inconsistent query results.

• Concurrency control always guarantees consistent query results

• Concurrency control is not necessary in database systems

• Concurrency control can lead to faster data processing

What is relation algebra and how is it used in database management?

• Relation algebra is used in database management to perform arithmetic operations on data

• Relation algebra is used in database management to create animations

• Relation algebra is used in database management to perform various operations on relations such as selection, projection, join, etc., to retrieve specific data from the database.

• Relation algebra is used in database management to design user interfaces

Define the term 'functional dependency' in the context of normalization.

• A functional dependency in normalization refers to a relationship between two attributes where one attribute uniquely determines the value of another attribute.

• Functional dependency is only applicable in denormalized databases

• Functional dependency is a relationship between tables in a database

• Functional dependency refers to the order of attributes in a table

What are the different normal forms in database normalization?

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

• 6NF

• 5NF

• 2NF

How can you optimize a query using indexing?

• Create indexes on all columns in the query

• Identify frequently used columns in the query and create indexes on those columns.

• Use indexing only on columns with low cardinality

• Avoid using indexes altogether

Explain the ACID properties in the context of transaction management.

• Atomicity, Consistency, Isolation, Durability

• Reliability

• Isolation

• Atomicity

• Consistency