Data management system (DMS)
What is the primary purpose of a Data Management System (DMS)?
To store, organize, and retrieve data efficiently
Which of the following is an example of a Data Management System?
SQL Server
Which component of a DMS is responsible for defining the structure of the data?
Data definition language (DDL)
Which of the following is NOT a key function of a Data Management System?
Operating system management
Which type of DMS is specifically designed to manage relational databases?
Relational Database Management System (RDBMS)
Which language is typically used to interact with relational database management systems?
SQL
What is a key advantage of using a Database Management System over a traditional file system?
Reduced data redundancy and better consistency
Which of the following DMS components helps ensure that only authorized users can access the data?
Security module
Which process ensures that database changes are permanent and stored safely?
Commit
What does ACID stand for in database management systems?
Atomicity, Consistency, Isolation, Durability