30 Questions
What is a key characteristic of a DBMS?
It is a set of programs to access data
Which of the following is NOT an example of a DBMS?
Microsoft Word
Which of these is a common application of a DBMS in the banking industry?
Computerized transactions
What is the main difference between the file-based approach and the database approach to data management?
The database approach is more convenient
Which of the following is NOT a common application of a DBMS in the manufacturing industry?
Airline reservations
What is the main advantage of using a DBMS over a manual approach to data management?
It is more convenient and efficient
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
What is the main reason organizations adopt the database approach?
To reduce long lead times and high costs in new application development
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
What is the purpose of the DBMS catalog in the database approach?
To store the description of the database, called meta-data
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
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
What is the primary purpose of a data model?
To provide a collection of concepts for describing the structure of a database
Which of the following is NOT typically included in a data model?
Indexing strategies for physical data storage
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
Which aspect of a database system is primarily concerned with data abstraction?
Data model
What is the primary benefit of data abstraction in database systems?
Better understanding of data structure and relationships
Which category of data models focuses on the highest level of abstraction?
Conceptual (high-level) data models
Who are considered sophisticated users?
Users that know advanced use of the system and packages on top of the system
What is the main focus of the analysis phase in the Database Development Life Cycle?
Fact-finding about the problem or opportunity
Who maintains personal databases by using easy-to-use ready-made program packages?
Stand-alone end-users
What is the primary goal of the planning phase in the Database Development Life Cycle?
Identifying information gap in an organization
Which group of individuals is responsible for testing and deploying the designed database for use?
Operators and maintenance personnel
What differentiates casual end-users from stand-alone end-users?
Frequency of database access
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)
What is the primary purpose for which a Database Management System (DBMS) was designed?
To store and manipulate data
What is the term used to refer to the additional information stored by the DBMS about the actual data?
Metadata
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
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
What type of data does a database typically contain?
Operational data and metadata
Explore the different types of DBMS systems, from small personal computer systems to large mainframe systems. Learn about the key components of a DBMS such as interrelated data, programs for data access, and the convenience and efficiency it provides. Get familiar with examples of popular DBMS systems.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
