DBMS Concepts and Applications

What is the purpose of a Database Management System (DBMS)?

• To eliminate the need for data backup.

• To create physical copies of data for security.

• The purpose of a Database Management System (DBMS) is to facilitate the management and organization of data in a structured manner.

• To store data in a non-structured format.

Explain the difference between a primary key and a foreign key.

• A primary key uniquely identifies a record in a table, while a foreign key links to a primary key in another table.

• A primary key is used for indexing, while a foreign key is used for sorting records.

• A primary key is always a number, while a foreign key is always a string.

• A primary key can be duplicated across tables, while a foreign key cannot.

What are the ACID properties in a database transaction?

• Atomicity, Consistency, Isolation, Redundancy

• Atomicity, Concurrency, Isolation, Durability

• Atomicity, Consistency, Isolation, Durability

• Atomicity, Consistency, Isolation, Reliability

Define normalization and its importance in database design.

• Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

• Normalization is only necessary for large databases with complex relationships.

• Normalization is the process of combining all data into a single table.

• Normalization increases data redundancy and decreases performance.

What is a relational database? Give an example.

• An example of a relational database is Adobe Photoshop.

• A relational database is a type of spreadsheet software.

• An example of a relational database is MySQL.

• An example of a relational database is MongoDB.

Describe the role of SQL in database management.

• SQL is only used for data visualization and reporting.

• SQL is primarily used for graphic design in databases.

• SQL is a programming language for creating mobile applications.

• SQL is essential for managing and manipulating relational databases, enabling CRUD operations and database structure definition.

What is the difference between a clustered and a non-clustered index?

• A clustered index is always faster than a non-clustered index.

• Both clustered and non-clustered indexes store data in the same way.

• A clustered index sorts and stores the data rows in the table based on the index, while a non-clustered index creates a separate structure that references the data rows.

• A non-clustered index cannot be created on a table with a primary key.

Explain the concept of data integrity and its types.

• Data integrity refers to the speed of data processing.

• Data integrity is only concerned with data storage methods.

• Data integrity types include only physical and logical integrity.

• Data integrity is the accuracy and consistency of data, with types including physical, logical, referential, and domain integrity.

What are stored procedures and how do they benefit database operations?

• Stored procedures are written in Java and not SQL.

• Stored procedures are less secure than regular SQL queries.

• Stored procedures are only used for data retrieval.

• Stored procedures are precompiled SQL statements that improve performance, security, and maintenance in database operations.

Discuss the differences between NoSQL and SQL databases.

• SQL databases are designed for unstructured data; NoSQL databases are for structured data.

• SQL databases are always faster than NoSQL databases for all use cases.

• SQL databases are relational with fixed schemas; NoSQL databases are non-relational with flexible schemas.

• NoSQL databases require complex joins; SQL databases do not support joins.