Questions and Answers
Most data that can be encountered are best classified as _____.
A desktop database is a _____ database.
A workgroup database is a(n) _____ database.
A _____ is a collection of related records.
Signup and view all the answers
_____ serve as the intermediary between the user and the database.
Signup and view all the answers
Which of the following refers to the situation where different versions of the same data are stored at different places because they weren't updated consistently?
Signup and view all the answers
A(n) _____ database is used by an organization and supports many users across many departments.
Signup and view all the answers
The database structure in a DBMS is stored as a _____.
Signup and view all the answers
Data is said to be verifiable if:
Signup and view all the answers
An XML database supports the storage and management of _____ XML data.
Signup and view all the answers
_____ provide a description of the data characteristics and the set of relationships that link the data found within the database.
Signup and view all the answers
_____ data exist in the format in which they were collected.
Signup and view all the answers
The organization of data within folders in a manual file system is determined by _______.
Signup and view all the answers
Accurate, relevant, and timely information is the key to ____.
Signup and view all the answers
_____ are the result of formatting disorganized data in order to facilitate storage, use, and generation of information.
Signup and view all the answers
_____ data exist in a format that does not lend itself to processing that yields information.
Signup and view all the answers
Which of the following is true of spreadsheet applications?
Signup and view all the answers
A(n) _____ might be written by a programmer or it might be created through a DBMS utility program.
Signup and view all the answers
End-user data is _____.
Signup and view all the answers
A _____ is a logically connected set of one or more fields that describes a person, place, or thing.
Signup and view all the answers
The response of the DBMS to a query is the ___________
Signup and view all the answers
_____ exists when different versions of the same data appear in different places.
Signup and view all the answers
_____ is the body of information and facts about a specific subject.
Signup and view all the answers
_____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.
Signup and view all the answers
An operational database is sometimes referred to as an enterprise database.
Signup and view all the answers
The only way to access the data in a database is through the DBMS.
Signup and view all the answers
One disadvantage of the DBMS is that it increases the risk of data security breaches.
Signup and view all the answers
Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.
Signup and view all the answers
Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.
Signup and view all the answers
Data is the result of processing raw facts to reveal its meaning.
Signup and view all the answers
Data processing can be as simple as organizing data to reveal patterns.
Signup and view all the answers
Corporations use only structured data.
Signup and view all the answers
An advantage of database systems is that you needn't perform frequent updates and apply latest patches.
Signup and view all the answers
Data and information are essentially the same thing.
Signup and view all the answers
Structure is based on the type of processing to be performed on the data.
Signup and view all the answers
When data are entered into a form and saved, they are placed in the underlying database as knowledge.
Signup and view all the answers
Information is produced by processing ____.
Signup and view all the answers
_____ exists when the same data are stored unnecessarily at different places.
Signup and view all the answers
When a database stores the majority of data in RAM rather than in hard disks, it is referred to as a(n) _____ database.
Signup and view all the answers
A(n) _____ is a spur-of-the-moment question.
Signup and view all the answers
_____ is a special language used to represent and manipulate data elements in a textual format.
Signup and view all the answers
_____ exists when it is possible to make changes in the data storage characteristics without affecting an application program's ability to access data.
Signup and view all the answers
A(n) _____ is a specific request issued to the DBMS for data manipulation.
Signup and view all the answers
To reveal meaning, information requires ____.
Signup and view all the answers
Raw data must be properly _____ for storage, processing, and presentation.
Signup and view all the answers
A(n) _____ develops when all required changes in the redundant data are not made successfully.
Signup and view all the answers
A(n) _____ is a collection of programs that manages the database structure and controls access to the data stored in the database.
Signup and view all the answers
_____ relates to activities that make a database operate more efficiently in terms of storage and access speed.
Signup and view all the answers
Study Notes
Database Classifications
- Most data is classified as semistructured.
- A desktop database operates as a single-user database, ideal for individual use.
- A workgroup database supports multiple users, functioning as a multiuser database.
Database Structures and Components
- A file is a collection of related records within a database.
- Database Management Systems (DBMSs) act as intermediaries between users and databases.
- A collection of files stores the database structure in a DBMS.
Data Integrity and Types
- Data redundancy occurs when different versions of the same data exist at multiple locations.
- An enterprise database is used organization-wide and supports many departments.
- Verifiable data yields consistent results and is essential for data integrity.
Data Formats
- XML databases manage semistructured XML data effectively.
- Unstructured data exists in its original collection format without processing.
Data Management Concepts
- Metadata describes data characteristics and relationships in the database.
- Accurate, relevant, and timely information is crucial for effective decision-making.
- Structured data results from organizing disorganized data for better storage and use.
Applications and Queries
- Spreadsheet applications enhance the user's ability to interpret data rather than serve as databases.
- An application can be created through a DBMS utility or written by a programmer.
- A query generates a query result set from the DBMS in response to user requests.
Data and Knowledge
- End-user data consists of raw facts relevant to the user.
- Knowledge represents the accumulated information and facts about a specific subject.
Performance and Dependencies
- Performance tuning improves database execution efficiency regarding storage and access speed.
- Structural independence allows changes in file structures without affecting application access.
Data Processing and Anomalies
- Data processing can reveal patterns through simple logical organization.
- A data anomaly occurs when changes in redundant data are incomplete or unsuccessful.
Access and Storage
- Access to database data solely relies on the DBMS.
- In-memory databases store most data in RAM for faster access.
Other Key Concepts
- An ad hoc query is generated spontaneously for immediate data request needs.
- Extensible Markup Language (XML) facilitates data representation in a textual format.
- Data independence permits modifications in storage features while maintaining application access consistency.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge of key concepts in Chapter 1 of Database Systems with these flashcards. Each card presents a term and its corresponding definition, focusing on different types and classifications of databases. Perfect for quick review or preparation for exams.