Types and Examples of Database Management Systems

What is a key characteristic of a DBMS?

It is a set of programs to access data (correct)
It is a collection of unrelated data
It runs on personal computers only
It is not an environment that is convenient and efficient to use

Which of the following is NOT an example of a DBMS?

Oracle
SQLite
MySQL
Microsoft Word (correct)

Which of these is a common application of a DBMS in the banking industry?

Computerized transactions (correct)
Inventory systems
Registration and grades
Employee records

What is the main difference between the file-based approach and the database approach to data management?

The database approach is more convenient (A) Signup and view all the answers

Which of the following is NOT a common application of a DBMS in the manufacturing industry?

Airline reservations (C) Signup and view all the answers

What is the main advantage of using a DBMS over a manual approach to data management?

It is more convenient and efficient (C) Signup and view all the answers

What is the main advantage of the database approach compared to a file-based approach?

Data can be stored in one place and shared easily (D) Signup and view all the answers

What is the main reason organizations adopt the database approach?

To reduce long lead times and high costs in new application development (A) Signup and view all the answers

What is a key characteristic of the database approach?

It allows changing data storage structures and operations without having to change the DBMS access programs (B) Signup and view all the answers

What is the purpose of the DBMS catalog in the database approach?

To store the description of the database, called meta-data (C) Signup and view all the answers

What is a key benefit of the database approach compared to a file-based approach?

It enables ad hoc questions to be answered more rapidly (B) Signup and view all the answers

What is the main architectural difference between the database approach and a file-based approach?

The database approach uses a centralized data store, while the file-based approach uses distributed data files (B) Signup and view all the answers

What is the primary purpose of a data model?

To provide a collection of concepts for describing the structure of a database (B) Signup and view all the answers

Which of the following is NOT typically included in a data model?

Indexing strategies for physical data storage (D) Signup and view all the answers

In addition to basic operations for retrievals and updates, what is becoming more common to include in data models?

Concepts to specify the dynamic behavior of a database application (A) Signup and view all the answers

Which aspect of a database system is primarily concerned with data abstraction?

Data model (D) Signup and view all the answers

What is the primary benefit of data abstraction in database systems?

Better understanding of data structure and relationships (D) Signup and view all the answers

Which category of data models focuses on the highest level of abstraction?

Conceptual (high-level) data models (A) Signup and view all the answers

Who are considered sophisticated users?

Users that know advanced use of the system and packages on top of the system (B) Signup and view all the answers

What is the main focus of the analysis phase in the Database Development Life Cycle?

Fact-finding about the problem or opportunity (C) Signup and view all the answers

Who maintains personal databases by using easy-to-use ready-made program packages?

Stand-alone end-users (B) Signup and view all the answers

What is the primary goal of the planning phase in the Database Development Life Cycle?

Identifying information gap in an organization (D) Signup and view all the answers

Which group of individuals is responsible for testing and deploying the designed database for use?

Operators and maintenance personnel (A) Signup and view all the answers

What differentiates casual end-users from stand-alone end-users?

Frequency of database access (D) Signup and view all the answers

What is the software component of a Database Management System (DBMS) comprised of?

DBMS software, Operating System, Application Programs, and Network Software (if used over a network) (D) Signup and view all the answers

What is the primary purpose for which a Database Management System (DBMS) was designed?

To store and manipulate data (A) Signup and view all the answers

What is the term used to refer to the additional information stored by the DBMS about the actual data?

Metadata (B) Signup and view all the answers

Which of the following is an example of metadata that a DBMS stores about a person's name?

The size of the person's name (C) Signup and view all the answers

What does the term "procedure" refer to in the context of a Database Management System (DBMS)?

A set of instructions or guidelines for using the DBMS (B) Signup and view all the answers

What type of data does a database typically contain?

Operational data and metadata (D) Signup and view all the answers