Testbank for Database Systems Design, Implementation, & Management GRADED A+

VERIFIED
Chapter 1 1
CHAPTER

Question 1
Data and information are essentially the same thing.
A. True
B. False q9

Question 2
Data processing can be as simple as organizing data to reveal patterns.
A. True
B. False

Question 3
We are now said to be entering the “knowledge age.”
A. True
B. False

Question 4
Information implies familiarity, awareness, and understanding knowledge as it applies to an environment.
A. True
B. False

Question 5
Data constitute the building blocks of information. No.1
A. True
B. False

Question 6
Metadata present a more complete picture of the data in the database than the data itself.
A. True
B. False

Question 7
The only way to access the data in a database is through the DBMS q2.
A. True
B. False

Question 8
Database programming languages receive all application requests and translate them into the complex operations
required to fulfill those requests.
A. True
B. False

Question 9
The DBMS reveals much of the database’s internal complexity to the application programs and users.
A. True
B. False

Question 10
One disadvantage of the DBMS is that it increases the risk of data security breaches.
A. True
B. False q5

,Question 11
An operational database is sometimes referred to as an enterprise database.
A. True
B. False

Question 12
A data warehouse can store data derived from many sources.
A. True
B. False Q3

Question 13
The same data might be simultaneously structured and unstructured depending on the intended processing.
A. True
B. False

Question 14
Corporations use only structured data.
A. True
B. False q6

Question 15
Historically, a manual file system was composed of a system of file folders and filing cabinets.
A. True
B. False

Question 16
Initially the files within a computer file system were similar to manual files.
A. True
B. False

Question 17
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.
A. True
B. False

Question 18
A query language is a procedural language.
A. True
B. False

Question 19
One disadvantage of a database system over previous data management approaches is increased costs.
A. True
B. False

Question 20
One advantage of a database system over previous data management approaches is that the database system is
considerably less complex.
A. True
B. False

,Question 21
____ is a set of tools that work together to provide an advanced data analysis environment for retrieving, processing,
and modeling data from the data warehouse.
A. Online analytical processing
B. Semi-structured processing
C. Enterprise processing
D. XML processing

Question 22
The phrase ____ refers to an organization of components that define and regulate the collection, storage, management
and use of data within a database environment.
A. database management system
B. database management
C. management system
D. database system

Question 23
A ____ is a collection of related records.
A. database
B. Field
C. column
D. file

Question 24
The ____ serve(s) as the intermediary between the user and the database.
A. DBMS
B. Metadata
C. end-user data
D. programming language

Question 25
The database structure in a DBMS is stored as a ____.
A. file
B. collection of files
C. set of key/value pairs
D. collection of queries

Question 26
Accurate, relevant, and timely information is the key to ____.
A. data management
B. good decision making
C. knowledge
D. understanding

Question 27
A(n) ____ database is used by an organization and supports many users across many departments.
A. Desktop
B. Workgroup
C. enterprise
D. transactional

Question 28
A ____ database supports data distributed across several different sites.

, A. single-user
B. multiuser
C. centralized
D. distributed

Question 29
A(n) ____ might be written by a programmer or it might be created through a DBMS utility program.
A. Query
B. operating system
C. database management system
D. application program

Question 30
____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the
database.
A. Queries
B. End-user data
C. Metadata
D. Information

Question 31
____ is the body of information and facts about a specific subject.
A. Data
B. Information
C. Knowledge
D. A database

Question 32
____ data exist in a format that does not lend itself to processing that yields information.
A. Structured
B. Semi-structured
C. Unstructured
D. Historical

Question 33
XML data is ____.
A. structured
B. multi-structured
C. unstructured
D. semi-structured

Question 34
____ data are the result of formatting to facilitate storage, use and generation of information.
A. Structured
B. Semi-structured
C. Unstructured
D. Historical

Question 35
A ____ is a character or group of characters that has a specific meaning.
A .database
B. field
C .record