Chapter1 Flashcards
What does DBMS stand for?
Database Management System
True or False: A DBMS is used to manage databases.
True
Fill in the blank: A DBMS provides a systematic way to __________ data.
create, retrieve, update, and delete
What is the primary purpose of a DBMS?
To allow users to efficiently manage and manipulate data.
Name one advantage of using a DBMS.
Data integrity
Which of the following is NOT a type of DBMS? (a) Hierarchical (b) Network (c) Linear (d) Relational
c) Linear
What type of DBMS uses a table-based format?
Relational DBMS
True or False: A NoSQL database is a type of DBMS.
True
What does SQL stand for?
Structured Query Language
In a relational DBMS, what is a primary key?
A unique identifier for a record in a table.
What is data normalization?
The process of organizing data to reduce redundancy.
Fill in the blank: The __________ model organizes data into a tree-like structure.
Hierarchical
What is the main function of a database schema?
To define the structure of a database.
Which SQL command is used to retrieve data from a database?
SELECT
True or False: A database can have multiple tables.
True
What does ACID stand for in the context of database transactions?
Atomicity, Consistency, Isolation, Durability
What is a foreign key?
A field in one table that uniquely identifies a row of another table.
Which type of database is designed to handle large volumes of unstructured data?
NoSQL database
Fill in the blank: Data __________ is the practice of ensuring data is accurate and consistent.
validation
What is a database index?
A data structure that improves the speed of data retrieval.
True or False: A view in a database is a virtual table.
True
What is the purpose of database backup?
To protect data from loss or corruption.
Which of the following is a popular relational database management system? (a) MongoDB (b) MySQL (c) Cassandra (d) Redis
b) MySQL
What is the role of a database administrator (DBA)?
To manage and maintain database systems.
Fill in the blank: __________ is the process of copying data from one location to another for backup or recovery.
Data replication
What is a stored procedure?
A set of SQL statements that can be stored and executed in the database.