7132 Module 01 Chapter 1 Practice Quiz

Database programming languages receive all application requests and translate them into the complex operations required to fulfill those request

True
False

False
A ___ is a collection of related records

• Schema
• Field
• Column
• File

File
When data are entered into a form and saved, they are placed in the underlying data base as knowledge

True
False

True?
A desktop database is a ___ database

Single User
Multiuser
Workgroup
Distributed

Single-User
Data processing can be as simple as organizing data to reveal patterns
True
False
True
A XML data base supports the storage and management of ___ XML data
Structured
Multistructured
Fully Structured
Semi Structured
Semi Structured
Data anomaly is defined as the condition which all of the data in the database are consistent with the real-world events and conditions

True
False

False
The term ___ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment

Structured data
Transaction
Management system
Database system

Database system
The response of the DBMS to a query is the ____
Ad hoc query
Ad hoc response
Query result set
Integrated view of the data
Query result set
End-user data is ___
Knowledge about the end users
Raw facts of interest to the end user
Information about a specific subject
Raw facts of interest to the end user
Accurate, relevant, and timely information is the key to __

Data management
Good decision making
Knowledge
Understanding

Good decision making?
Data and information are essentially the same thing
false
_____ relates to the activites that make the database execute transactions more efficiently in terms of storage and access speed
a. Performance tuning
b. database design
c. query access
d. database management
Performance tuning
Which of the following refers to the situation where different version of the same data are stored at different places because they weren’t updated consistently?

A. Data query
B. Data integrity
C. Data dictionary
D. Data redundancy

data redundancy
_____ serves as the intermediary between the user and the database

a. DBMSs
B.Metadata
C. End-user data
d. programming languages

DBMSs
The database structure in a DBMS is stored as a ___
a. single file
b. collection of files
c. set of key/value pairs
d. collection of queries
collection of files
____ refer to a type of database that stores most of its data in RAM rather than in hard disks
a. integrated databases
b. cloud databases
c. desktop databases
d. in-memory databases
in-memory databases
An advantage of database system is that you needn’t perform frequent updates and apply latest patches
True/False
false
A data warehouse can store data derived from many sources
True/False
true
Data constitute the building blocks of information
True/False
True
An operational database is sometimes referred to as an enterprise database
True/False
False