Database Systems, Chapter 1
Quiz
What is a benefit of using a DBMS?
- they provide full security to data using private/public key encryption
- they create automatic backups
- they help create an environment for end users to have access to more data
- they provide seamless Internet access to database data
What is the name for an answer to a query that the DBMS sends back to the application?
- DBMS result
- query result set
- question result
- data result
A single-user database that runs on a personal computer is called a(n) ____ database.
- workgroup
- distributed
- enterprise
- desktop
The content of any given field is the ____.
- database
- field value
- entity
- table
Data processing (DP) specialists are in existence because of _______.
- the increase in the number of computers
- the advent of database management systems
- the need to convert manual files to a matching computer file system
- the need to speed up processing of data
_____ are considered database architects.
- Database administrators
- Systems administrators
- Database designers
- Systems analysts and programmers
Programming in a(n) ____ may be a time-consuming and high-skill activity.
- COB
- AIS
- 3GL
- DMB
The ____ receives all application requests and translates them into the complex operations required to fulfill requests.
- query
- workgroup
- DBMS
- DP
A ____ focuses primarily on storing data used to generate information required to make tactical or strategic decisions.
- distributed database
- workgroup database
- data warehouse
- production database
Accurate, relevant, and timely ____ is the key to good decision making.
- information
- processing
- data
- relationships
The word ____ indicates that the facts have not yet been processed to reveal their meaning.
- raw
- information
- data
- dictionary
What is the maximum number of users normally supported by a workgroup database?
- 10
- 30
- 50
- 100
Which of the following would result in a data anomaly?
- inconsistent redundant data
- modification of data
- timeliness of data
- obsolescence of data
Processed data, or ____, can be used as the basis for decision making.
- raw data
- information
- queries
- DP
What is the most common classification applied to a DBMS?
- number of users
- database site location(s)
- expected type and extent of use
- software manufacturer
Which of the following products do not provide an enterprise database?
- MS Access
- MS SQL Server
- IBM DB2
- Oracle RDBMS
Data ____ exists when the same data are stored unnecessarily at different places.
- dependency
- redundancy
- inconsistency
- fragmentation
What is the name for data about data?
- unique data
- raw data
- metadata
- superdata
A ____ allows the user to specify what must be done without specifying how it must be done.
- 1GL
- 2GL
- 3GL
- 4GL
Database management systems, operating systems, applications and utilities are all examples of ____.
- software
- hardware
- computer infrastructure
- input and output