DBMS

What does DBMS stand for?

• Digital Business Management Software

• Database Monitoring System

• Data Business Management System

• Database Management System

What is the purpose of a primary key in a database table?

• To sort the records in the table

• To limit the number of records in the table

• To store additional information about each record

• To uniquely identify each record in the table.

Explain the concept of normalization in the context of databases.

• Normalization is the process of adding redundant data to improve database performance.

• Normalization leads to increased data redundancy and decreased data integrity.

• Normalization helps in minimizing data redundancy, improves data integrity, and reduces the chances of anomalies during data manipulation.

• Normalization is only applicable to non-relational databases.

What is a foreign key in a database?

• A foreign key is a unique identifier in a database

• A foreign key is a field that links to the primary key of the same table

• A foreign key in a database is a field that links to the primary key of another table.

• A foreign key is used to store text data in a database

Describe the ACID properties in database transactions.

• Atomicity, Consistency, Isolation, and Reliability

• Atomicity, Consistency, Isolation, and Durability

• Atomicity, Concurrency, Isolation, and Durability

• Atomicity, Consistency, Integrity, and Durability

Explain the difference between a database view and a table.

• A view and a table both store data physically

• A view stores data physically, while a table does not store data physically

• A table stores data physically, while a view does not store data physically but provides a virtual representation of data.

• A table provides a virtual representation of data, while a view stores data physically

What is a stored procedure in a database?

• A stored procedure in a database is a set of SQL statements stored in the database catalog.

• A stored procedure is a type of database table

• A stored procedure is a physical storage location for data in a database

• A stored procedure is a software application used to access a database

What is data redundancy and how can it be minimized in a database?

• Normalization techniques such as breaking down data into multiple related tables and linking records through foreign keys can minimize data redundancy in a database.

• Data redundancy can be minimized by storing all data in a single denormalized table

• Data redundancy is beneficial for database performance

• Data redundancy can be minimized by duplicating all records in the database

A function that has no partial functional dependencies is in _______ form

• 1NF

• 2NF

• 3NF

• 4NF

What is the purpose of a database transaction in a DBMS?

• A database transaction is used to store data permanently in the database.

• A database transaction is used to perform multiple database operations as a single unit of work that must be completed entirely or not at all.

• A database transaction is used to retrieve data from the database.

• A database transaction is used to delete all records from the database.