76 Questions
Which level of data abstraction describes how the data are actually stored?
Physical level
Which level of data abstraction describes what data are stored in the database?
Logical level
Which of the following is the primary goal of a database-management system (DBMS)?
To provide a way to store and retrieve database information
What is the central aspect of a database application?
The data themselves
What do modern database applications include?
Highly sophisticated, worldwide enterprises
Which of the following is an example of a web-based service that uses a database?
Online banking systems
What is the primary mode of use for the majority of users of database applications?
Online transaction processing
What is the purpose of data analytics in the context of database systems?
To draw conclusions and infer rules from data
Which of the following is NOT a challenge in conventional file-processing environments?
Security problems
What is the purpose of maintaining consistency constraints in a database system?
To prevent data values from falling below zero
Why is it difficult to ensure atomicity in a conventional file-processing system?
Because the system may experience failures
What can happen when multiple users update the data simultaneously in a file-processing system?
Concurrent-access anomalies
Which data model is widely used in database design?
Entity-Relationship Model
What is the purpose of a database system?
To provide users with an abstract view of the data
Which data model uses a collection of tables to represent both data and relationships among those data?
Relational Model
What does each row of a table in the relational model represent?
A piece of information
Which of the following is a key characteristic of database systems?
They manage large collections of data
Which of the following is an example of a database application with structured data?
A university's records regarding courses, students, and course registration
What is the purpose of abstraction in a database system?
To provide a simpler, abstract view of the information
Which of the following is an example of a database-system application?
All of the above
Which of the following is a disadvantage of keeping organizational information in a file-processing system?
Data redundancy and inconsistency
What is one purpose of database systems?
To store and manipulate data
Why are organizations willing to invest a lot of money in data mining?
To make accurate predictions
What is the field of data mining a combination of?
Artificial intelligence and statistical analysis
Which of the following best describes the primary goal of a database-management system (DBMS)?
To provide a way to store and retrieve database information that is both convenient and efficient
What is the central aspect of a database application?
The data themselves
Why are some of the most valuable corporations valuable?
Because of the information they own
Which of the following is a key characteristic of a database system?
Structured and organized data
What is the purpose of a database system?
To store and organize data
Which of the following is an example of a database-system application?
Tracking sales and customer information
What is the purpose of abstraction in a database system?
To hide the complexity from users
Which of the following is NOT an example of a web-based service that uses a database?
Navigation systems
What is the primary purpose of data analytics in the context of database systems?
To draw conclusions and infer rules from data
Which level of data abstraction describes the user's view of the data?
External level
What is the purpose of maintaining consistency constraints in a database system?
To enforce data integrity and accuracy
Which of the following is NOT a problem associated with conventional file-processing environments?
Security problems
What is the purpose of maintaining consistency constraints in a database system?
To prevent integrity problems
Which of the following is a potential issue when multiple users update the data simultaneously in a file-processing system?
Concurrent-access anomalies
Why is it difficult to ensure atomicity in a conventional file-processing system?
Lack of transaction support
Which level of data abstraction describes what data are stored in the database, and what relationships exist among those data?
Logical level
What is the purpose of using complex data structures at the physical level of data abstraction?
To improve data retrieval efficiency
What is the primary reason for using multiple levels of data abstraction in a database system?
To hide the complexity from users
Which of the following is a disadvantage of keeping organizational information in a file-processing system?
Data redundancy and inconsistency
What is one purpose of database systems?
To store and manage large amounts of data
What is the field of data mining a combination of?
Knowledge-discovery techniques and statistical analysis
Which of the following is NOT a challenge in conventional file-processing environments?
Lack of application programs to meet specific needs
Which data model is the most widely used in database systems?
Relational Model
What is the purpose of the relational model in a database system?
To represent both data and the relationships among those data using tables
Which level of data abstraction describes the user's view of the data in a database system?
External level
What is the main purpose of a database system?
To solve problems with file-processing systems
Which of the following is a key characteristic of a database system?
Database systems are designed to manage large bodies of information.
What is the purpose of maintaining consistency constraints in a database system?
To avoid possible anomalous results when data are shared among several users
Which level of data abstraction describes the user's view of the data in a database system?
External level
Which data model is widely used in database design?
Relational Model
What is the purpose of a database system?
To provide users with an abstract view of the data
Which level of data abstraction describes how the data are actually stored?
Physical Level
What is the primary reason for using multiple levels of data abstraction in a database system?
To hide certain details of how the data are stored and maintained
Which of the following is NOT an example of a database-system application?
Social-networking site
Which level of data abstraction involves complex low-level data structures?
Physical level
What is the main purpose of a database system?
To manage collections of data
Which of the following is a disadvantage of keeping organizational information in a file-processing system?
Difficulty in managing complex data relationships
Which level of data abstraction describes how the data are actually stored?
Physical level
What is the purpose of using complex data structures at the physical level of data abstraction?
To retrieve data efficiently
Which level of data abstraction describes the entire database in terms of a small number of relatively simple structures?
Logical level
Which of the following is NOT a challenge in conventional file-processing environments?
Security problems
What is the primary reason for using multiple levels of data abstraction in a database system?
To hide the complexity from users
What is the purpose of maintaining consistency constraints in a database system?
To ensure data integrity
Which level of data abstraction involves the use of complex physical-level structures?
Physical level
Which of the following is a disadvantage of keeping organizational information in a file-processing system?
Data redundancy and inconsistency
What is one purpose of database systems?
To store and organize data
What is the primary mode of use for the majority of users of database applications?
Querying and retrieving data
Which of the following is a key characteristic of a database system?
Efficient implementation techniques
Which of the following is NOT an example of a web-based service that uses a database?
Document databases
What is the primary goal of a database-management system (DBMS)?
To store and retrieve data
What is the purpose of data analytics in the context of database systems?
To analyze data and draw conclusions
Which level of data abstraction describes the user's view of the data in a database system?
External level
Input: chapter 1 of the textbook.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
