Database Systems Flashcard

Front

What is the primary purpose of a database?

Back

To manage and retrieve data efficiently

Front

Which of the following best defines data? A type of software, A collection of databases, Processed information

Back

Raw facts that have not been processed

Front

What does DBMS stand for?

Back

Data Base Management System

Front

Which of the following is NOT a function of a DBMS? Data entry, Security management, Data storage management, Data transformation and presentation

Back

Data entry

Front

What is metadata?

Back

Data about data

Front

What is the main advantage of using a DBMS over a file system?

Back

Improved data sharing and integrity

Front

Which type of database supports multiple users at the same time? Options: Single-user database, Multiuser database, Desktop database, Centralized database

Back

Multiuser database

Front

What of the following is not the task of a Data Processing Specialist? Develop application, Create data files for its department, Preparing Reports

Back

Manage Data files across departments

Front

What is the purpose of data integrity management in a DBMS?

Back

To enforce rules that minimize redundancy and maximize consistency

Front

Which of the following is the limitation of traditional file systems? Store data as columns of fields and rows, Data redundancy, Data cannot be updated, New data cannot be inserted

Back

Data redundancy