Unit 1 Flashcards
(25 cards)
What is a Database Management System?
A software system that allows users to define, create, maintain, and control access to the database.
What are the advantages of using a Database Management System?
Advantages include data consistency, data integrity, data security, and reduced data redundancy.
True or False: A DBMS helps in enforcing data constraints and business rules.
True
What is data redundancy?
Storing the same data in multiple locations, leading to inconsistencies and inefficiencies.
What is data consistency?
Ensuring that data is accurate and updated across all instances in the database.
Fill in the blank: A DBMS provides a ____________ view of the database to users.
Logical
What is a primary key in a database?
A unique identifier for each record in a table.
What is a foreign key in a database?
A field that links one table to another by referencing the primary key of another table.
What is normalization in database management?
The process of organizing data in a database to reduce redundancy and improve data integrity.
What is denormalization in database management?
The process of intentionally adding redundancy to speed up data retrieval.
What is a transaction in a database?
A single unit of work that must be completed in its entirety or not at all.
What is ACID in the context of database transactions?
Atomicity, Consistency, Isolation, Durability - properties that ensure database transactions are reliable.
What is a database schema?
The structure that represents the logical view of the entire database.
True or False: A DBMS allows multiple users to access the database simultaneously.
True
What is data mining in the context of database management?
The process of discovering patterns and relationships in large datasets.
What is a query in a database?
A request for information from a database.
What is the role of a database administrator?
Responsible for managing and maintaining the database system, ensuring its security and performance.
What is the purpose of data dictionary in a DBMS?
It stores metadata information about the database, such as data definitions and data relationships.
What is a database index?
A data structure that improves the speed of data retrieval operations on a database table.
What is the difference between a database and a database management system?
A database is a collection of related data, while a DBMS is a software system that manages the database.
What is data warehousing?
The process of collecting and managing data from various sources to provide meaningful business insights.
What is data modeling in database management?
The process of designing the database structure that defines the relationships between data elements.
What is the role of SQL in database management?
SQL (Structured Query Language) is used to interact with and manipulate databases.
What is a view in a database?
A virtual table that presents data from one or more tables in a specific format.
