Database Systems Chapter 1 (Lecture)
The ________ receives all application requests and translates them into the complex operations required to fulfill requests.
DBMS
What is a key characteristic of knowledge?
"new" Knowledge can be derived from "old" knowledge.
How many users does a workgroup database usually support?
50
The ________ manages interaction between the end user and the database.
DBMS
What is a benefit of using a DBMS?
It helps create an environment for end users to have access to more data.
Which of the following products do not provide an enterprise database?
MS Access
________ is the de facto query language and data access standard supported by the majority of DBMS vendors.
Structured Query Language (SQL)
John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ________.
create a new query
What is the most common classification applied to a DBMS?
expected type and extent of use
Where was a traditional file system normally stored?
file cabinet
Accurate, relevant, and timely ________ is the key to good decision making.
information
Human beings view data according to its ________ data format.
logical
________ are the instructions and rules that govern the design and use of the database system.
procedures
________ deals with fixing the database after a failure such as a hard disk malfunction.
recovery
A record consists of a ________.
set of one or more fields
An ad hoc query is a ________.
spur of the moment question
Data processing (DP) specialists are in existence because of ________.
the need to track data and produce required reports
A data ________ develops when all of the required changes in the redundant data are not made successfully.
anomaly
A raw fact such as a telephone number is known as ________.
data
Because all data access programs are subject to change when any of the file's data storage characteristics change (that is, changing the data type), the file system is said to exhibit ________.
data dependence
Where does the DBMS store the definitions of data elements and their relationships?
data dictionary
A ________ focuses primarily on storing data used to generate information required to make Tactical or strategic decisions.
data warehouse
The design of a ________ database recognizes the use of historical and aggregated data.
data warehouse
A ________ system is composed of software, hardware, data, procedures and people.
database
________ are considered database architects.
database designers
The term ________ refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.
database system
A single-user database that runs on a personal computer is called a(n) ________ database.
desktop
A database that supports data distributed across several different sites is called a(n) ________ database.
distributed
________ are the people who use application programs to run the organization's daily operations.
end users
Raw data must be properly ________ for storage, processing, and presentation.
formatted
Which of the following would result in a data anomaly?
inconsistent redundant data
Data ________ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.
independence
Processed data, or ________, can be used as the foundation for decision making.
information
Wider access to well-managed data promotes a(n) ________ view of the organization's operations and a clearer view of the big picture.
integrated
Data ________ is defined as "the condition in which all of the data in the database are consistent with the real-world events and conditions."
integrity
What is the name for data about data?
metadata
A(n) ________ allows the user to specify what must be done without specifying how it must be done.
nonprocedural language
The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________.
query language
What is the name for an answer to a query that the DBMS sends back to the application?
query result set
The word ________ indicates that the facts have not yet been processed to reveal their meaning.
raw
All fields for a specific entity can be grouped together as a ________.
record
Data ________ exists when the same data are stored unnecessarily at different places.
redundancy
Database management systems, operating systems, applications and utilities are all examples of ________.
software
________ independence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.
structural
Data management is a discipline that focuses on ________.
the proper generation, storage, and retrieval of data
Another name for a production database is a ________ database.
transactional
Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________.
tuning
