WorksheetsDatabase Concepts Quiz
Total questions: 78
Worksheet time: 39hrs 0mins
Which of the following is defined as raw facts and the building blocks of information?
Data
Information
Metadata
Knowledge
What is considered unprocessed information?
Data
Knowledge
Metadata
Decision making
Which term refers to data processed to reveal meaning?
Facts
Information
Metadata
Raw data
A database is described as a shared, integrated computer structure that houses which of the following?
End user data and information
Metadata and queries
End user data and metadata
Data mining results and reports
What is end user data?
Information processed for decisions
Data about data
Raw facts stored in the database
Queries made by users
What is metadata?
Raw data
Data about data
Processed information
End user reports
What is a DBMS?
A collection of raw facts
A system that processes information into data
A collection of programs that manages database structure and controls access to data
A set of reports for managers
Which of the following is possible with a DBMS?
Share data among multiple applications or users
Prevent access to all users
Only allow single-user access
Convert data into sound files
The DBMS makes data management more efficient and effective because:
It hides data from users
It promotes better-managed data and reduces inconsistency
It allows only managers to view data
It eliminates the need for databases
With a DBMS, end users have better access to what?
Raw data only
Reports only
More and better-managed data
Backup files only
A DBMS promotes what kind of view of an organization's operations?
Fragmented view
Integrated view
Hierarchical view
Sequential view
Which of the following is greatly reduced when using a DBMS?
Data entry
Data inconsistency
Metadata use
Raw facts
A DBMS makes it possible to quickly produce answers to what type of queries?
Standard queries
Ad hoc queries
Metadata queries
Backup queries
Which system manages the interaction between the end user and the database?
Database Management System (DBMS)
File System
Operating System
Metadata Manager
What type of database supports only one user at a time?
Multi-user database
Desktop database
Single-user database
Enterprise database
Which type of database is a single-user database running on a personal computer?
Desktop database
Enterprise database
Workgroup database
Centralized database
What type of database supports multiple users at the same time?
Centralized database
Distributed database
Multi-user database
Desktop database
Which multi-user database supports a small group of users or a single department?
Workgroup database
Enterprise database
Centralized database
Distributed database
Which multi-user database supports a large group of users or an entire organization?
Desktop database
Centralized database
Workgroup database
Enterprise database
What type of database supports data located at a single site?
Centralized database
Distributed database
Workgroup database
Transactional database
What type of database supports data distributed across several sites?
Centralized database
Distributed database
Enterprise database
Data warehouse
Which type of database supports a company's day-to-day operations?
Data warehouse
Transactional (or production) database
Enterprise database
Distributed database
Which type of database stores data used to generate information required for tactical or strategic decisions?
Transactional database
Workgroup database
Data warehouse
Centralized database
Which of the following is often used to store historical data and requires 'data massaging'?
Data warehouse
Transactional database
Centralized database
Workgroup database
Why is database design important?
To ensure faster internet speed
To define the database's expected use and avoid redundant data
To allow only one user at a time
To improve computer hardware
What is a consequence of a poorly designed database?
Easier decision making
Increased data accuracy
Errors leading to bad decisions and possible organizational failure
Stronger metadata generation
Why is it useful to understand file systems even though they are largely obsolete?
To replace DBMS completely
To understand the complexity of database design and avoid past problems
To learn how to build only manual file cabinets
To eliminate metadata usage
Which traditional system was composed of a collection of file folders kept in file cabinets?
Manual file system
Computer file system
DBMS
Enterprise system
In manual file systems, organization within folders was based on what?
Data processing requirements
Data's expected use, ideally logically related
File system errors
Random storage
Why did manual file systems become time-consuming and cumbersome?
Metadata was not available
Growing collections of file folders made finding and using data difficult
They supported too many users simultaneously
They required DBMS software
What did the conversion from manual file systems to computer file systems often require?
Hiring of database administrators
Hiring of data processing (DP) specialists
Development of enterprise systems
Use of ad hoc queries
What did DP specialists create during the conversion to computer file systems?
Metadata reports only
File structures, software, and application programs
DBMS platforms
Distributed data warehouses
What was the result of the early conversion from manual to computer file systems?
Standardized DBMS platforms
Numerous 'home-grown' systems
Fully integrated enterprise databases
Elimination of redundancy
Initially, computer files were similar in design to what?
Metadata systems
Manual files
Enterprise DBMS
Distributed databases
Which term refers to a logically connected set of one or more fields that describes a person, place, or thing?
Field
Data
Record
File
Which of the following might include a customer's name, address, phone number, date of birth, credit limit, and unpaid balance?
Record
File
Field
Data
Which term is defined as a collection of related records?
Data
Field
Record
File
Which of the following might contain data about vendors of ROBCOR Company or records for students currently enrolled at Gigantic University?
File
Record
Field
Data
Which of the following is a character or group of characters (alphabetic or numeric) that has a specific meaning?
Data
Field
Record
File
In early file systems, who typically owned each file?
The entire organization
The database administrator
The individual or department that commissioned it
The sales manager
As early systems grew, what happened to the demand for DP programming skills?
It decreased
It stayed the same
It grew
It disappeared
In file system data management, which generation of language required programmers to specify both the task and how it must be done?
First-generation language
Second-generation language
Third-generation language (3GL)
Fourth-generation language (4GL)
Which generation of language allows users to specify what must be done without specifying how?
First-generation language
Third-generation language (3GL)
Fourth-generation language (4GL)
Fifth-generation language
Why was programming in 3GL time-consuming?
Programmers had to manage physical file structures and complex coding
Queries were automated
It required no knowledge of the system
Programs were reusable
Why were ad hoc queries impossible in 3GL file systems?
Data storage was limited
Writing new programs was required for each new report
Files could not be modified
Security settings blocked queries
What happened as the number of files increased in 3GL systems?
System administration became easier
System administration became difficult
Files became self-organizing
Metadata eliminated errors
Why were file structure changes problematic in 3GL file systems?
They required no modifications in existing programs
They required modifications in all programs using that file
They were automated by metadata
They improved efficiency immediately
What often happened after modifications in 3GL programs?
Errors were introduced, requiring debugging
Automatic fixes were applied
Data was restored instantly
Security increased
Why were security features often omitted in file systems?
They were unnecessary
They were difficult to understand
They were hard to program
They were built into hardware
What is structural dependence?
Access to data depends on the computer's operating system
Access to a file depends on its structure
Data relies on multiple users
Files must be stored physically together
What is data dependence?
Data relies on structural independence
Changes in database structure affect program access
Data remains unchanged regardless of structure
Data is always independent of the file format
How does a human being view the data?
Physical data format
Logical data format
Metadata view
Structural format
How does the computer "see" the data?
Metadata format
Logical data format
Physical data format
Field definition format
What is the purpose of flexible record definition and naming conventions?
To improve hardware
To anticipate reporting requirements by breaking fields into components
To eliminate the need for metadata
To reduce file ownership
What is the main problem caused by data redundancy?
Increased speed
Data inconsistency
Greater efficiency
Faster queries
When different and conflicting versions of the same data appear in different places, what has occurred?
Data inconsistency
Data validation
Structural independence
Metadata duplication
Which anomaly occurs when changes must be made to existing records?
Insertion anomaly
Deletion anomaly
Modification anomaly
Structural anomaly
Which anomaly occurs when entering new records?
Modification anomaly
Insertion anomaly
Deletion anomaly
Redundancy anomaly
Which anomaly occurs when deleting records?
Modification anomaly
Insertion anomaly
Deletion anomaly
Redundancy anomaly
How do databases differ from file systems?
File systems contain logically related data
Databases contain logically related data stored in a single repository
File systems use metadata extensively
Databases have many unrelated files
Which of the following are the five main parts of a database system?
Hardware, Software, People, Procedures, Data
Hardware, Files, Metadata, Queries, Reports
Software, Data, Metadata, Records, Fields
Database, Queries, Tables, Programs, Users
Which type of software is part of the database system environment?
Operating system software, DBMS software, application programs, utility software
Security software only
Networking software only
Internet browsers only
Which DBMS function defines data elements and their relationships?
Data dictionary management
Data storage management
Data transformation
Data integrity management
Which DBMS function stores data, forms, and report definitions?
Data storage management
Security management
Metadata management
Application interface
Which DBMS function translates logical requests into commands to physically locate and retrieve data?
Data dictionary management
Data transformation and presentation
Backup and recovery management
Multi-user access control
Which DBMS function enforces user security and data privacy?
Security management
Backup and recovery
Data integrity management
Data dictionary management
Which DBMS function creates structures that allow multiple users to access the data?
Data storage management
Multi-user access control
Application programming interface
Database communication interface
Which DBMS function provides backup and recovery procedures?
Security management
Data storage management
Backup and recovery management
Data dictionary management
Which DBMS function promotes and enforces rules to eliminate integrity problems?
Data transformation
Data integrity management
Security management
Metadata enforcement
Which DBMS function provides data access through a query language?
Data storage management
Data integrity management
Database access languages and APIs
Backup and recovery management
Which DBMS function allows databases to accept end-user requests within a network environment?
Data dictionary management
Database communication interfaces
Security management
Multi-user access control
Information is derived from what?
Metadata
Reports
Data
Files
Which tool is used to implement and manage a database?
File system
DBMS
Metadata dictionary
Operating system
What defines the structure of a database?
Database design
Metadata management
Query language
Logical format
Why is good database design important?
It speeds up the operating system
It reduces hardware requirements
It prevents errors and supports good decision-making
It eliminates metadata
What preceded databases?
Cloud computing
File systems
Distributed networks
Artificial intelligence
Why did file systems become difficult to manage as they grew?
They lacked a DBMS
They had too much metadata
They had built-in redundancy tools
They were designed for multiple users only
Why were DBMS developed?
To replace operating systems
To address the weaknesses of file systems
To eliminate metadata
To manage networks
