Ch. 1 & Ch. 2 Flashcards
Processed data, or ________, can be used as the foundation for decision making.
a. raw data
b. information
c. queries
d. DP
b. information
Accurate, relevant, and timely ________ is the key to good decision making.
a. processing
b. data
c. information
d. relationships
c. information
What is the name for data about data?
a. metadata
b. raw data
c. superdata
d. unique data
a. metadata
Data management is a discipline that focuses on ________.
a. the management of end users
b. the help items to be used by end users
c. the proper generation, storage, and retrieval of data
d. the proper generation, storage, and retrieval of information
c. the proper generation, storage, and retrieval of data
What is a benefit of using a DBMS?
a. It helps create an environment for end users to have access to more data.
b. It provides full security to data using private/public key encryption.
c. It provides seamless Internet access to database data.
d. It creates automatic backups.
a. It helps create an environment for end users to have access to more data.
The ________ receives all application requests and translates them into the complex operations required to fulfill requests.
a. DBMS
b. workgroup
c. DB
d. query
a. DBMS
An ad hoc query is a ________. a. spur of the moment question b. question that will not return any results
c. pre- scheduled question
d. pre-planned question
a. spur of the moment question
What is the name for an answer to a query that the DBMS sends back to the application?
a. query result set
b. DBMS result
c. data result
d. question result
a. query result set
A single-user database that runs on a personal computer is called a(n) ________ database. a. workgroup
b. desktop
c. enterprise
d. distributed
b. desktop
A database that supports data distributed across several different sites is called a(n) ________ database.
a. workgroup
b. enterprise
c. desktop
d. distributed
d. distributed
A ________ focuses primarily on storing data used to generate information required to make tactical or strategic decisions.
a. data warehouse
b. workgroup database
c. production database
d. distributed database
a. data warehouse
Another name for a production database is a ________ database.
a. development
b. transactional
c. data mining
d. warehouse
b. transactional
John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ________.
a. create a new query
b. utilize the Database Wizard c. create a new table
d. create a new form
a. create a new query
Which of the following products do not provide an enterprise database?
a. MS Access
b. IBM DB2
c. MS SQL Server
d. Oracle RDBMS
a. MS Access
The design of a ________ database recognizes the use of historical and aggregated data. a. production
b. data warehouse
c. multiuser
d. single-user
b. data warehouse
Data processing (DP) specialists are in existence because of ________.
a. the increase in the number of computers
b. the need to speed up processing of data
c. the need to track data and produce required reports
d. the advent of database management systems
c. the need to track data and produce required reports
A ________ system is composed of software, hardware, data, procedures and people.
a. database
b. computer
c. software
d. file
a. database
A record consists of a ________.
a. collection of related records b. set of one or more fields
c. group of files
d. character
b. set of one or more fields
All fields for a specific entity can be grouped together as a ________.
a. record
b. file
c. database
d. field
a. record
A(n) ________ allows the user to specify what must be done without specifying how it must be done.
a. object-oriented language
b. script
c. procedural language
d. nonprocedural language
d. nonprocedural language
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.
a. mining
b. integrity
c. inconsistency
d. independence
d. independence
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 ________.
a. data dependence
b. logical data format
c. data independence
d. physical data format
a. data dependence
________ independence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data.
a. Logical
b. Structural
c. Physical
d. Fragmentation
b. Structural
Data ________ exists when the same data are stored unnecessarily at different places.
a. dependency
b. fragmentation
c. redundancy
d. inconsistency
c. redundancy
A data ________ develops when all of the required changes in the redundant data are not made successfully.
a. anomaly
b. redundancy
c. dependence
d. inconsistency
a. anomaly
________ are the people who use application programs to run the organization’s daily operations.
a. End users
b. Data practitioners
c. Database programmers
d. Managers
a. End users
________ are considered database architects.
a. Systems administrators
b. Database designers
c. Systems analysts and programmers
d. Database administrators
b. Database designers
Where does the DBMS store the definitions of data elements and their relationships?
a. data file
b. data dictionary
c. data map
d. index
b. data dictionary
Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________.
a. development
b. upgrades
c. enhancements
d. tuning
d. tuning
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) ________.
a. access control
b. security system
c. table generator
d. query language
d. query language
________ is the de facto query language and data access standard supported by the majority of DBMS vendors. a. Structured Query Language b. 4GL
c. Access Query Language
d. DBMS
a. Structured Query Language
A(n) ________ of the overall database design is required to overcome the fact that data are viewed in different ways by different people.
a. analysis
b. review
c. footprint
d. blueprint
d. blueprint
A customer ________ would be described by attributes such as customer last name, customer first name, customer phone, customer address, and customer credit limit.
a. relationship
b. model
c. constraint
d. entity
d. entity
The basic building blocks of all data models are entities, attributes, relationships, and ________.
a. queries
b. constraints
c. business rules
d. multiples
b. constraints
What type of relationship is expressed with the phrase “Painter paints Painting”?
a. M:N
b. M:1
c. 1:M
d. 1:1
c. 1:M
What type of relationship is expressed with the phrase “Employee manages Store”?
a. 1:M
b. 1:1
c. M:N
d. M:1
b. 1:1
What type of relationship is expressed with the phrase “Student takes Class”?
a. M:N
b. 1:1
c. 1:M
d. M:1
a. M:N
What is the fastest and most direct source of business rules? a. company documentation
b. a database design document c. interviews with end users
d. the Internet
c. interviews with end users
A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization.
a. attribute
b. entity
c. constraint
d. business rule
d. business rule
As a general rule, a noun in a business rule will translate into a(n) ________ in the model.
a. constraint
b. entity
c. relationship
d. attribute
b. entity
The hierarchical database model is based on a ________. a. lack of a child segment
b. matrix
c. lack of a parent segment
d. tree structure
d. tree structure
The hierarchical database model depicts a set of ________ relationships.
a. many-to-one
b. one-to-many
c. many-to-many
d. one-to-one
b. one-to-many
A ________ is the equivalent of a file system’s record type. a. child
b. parent
c. segment
d. root
c. segment
Which data model was developed most recently?
a. network model
b. relational
c. XML
d. file system
c. XML
Within the network model, the ________ is the conceptual organization of the entire database as viewed by the database administrator.
a. subschema
b. data management language c. schema
d. DBTG
c. schema
A relational database is a collection of ________.
a. field values
b. tables
c. common fields
d. records
b. tables
A relation is a matrix consisting of a series of row and column ________.
a. intersections
b. models
c. links
d. systems
a. intersections
One of the advantages of a relational data model is ________.
a. structural dependence
b. easier database design
c. complex database design
d. conceptual complexity
b. easier database design
For most relational database software, the query language is ________.
a. RDBMS
b. 4GL
c. String Query Language (SQL)
d. Structured Query Language (SQL)
d. Structured Query Language (SQL)
From an end-user perspective, any SQL-based relational database application involves three parts: a user interface, a set of tables stored in the database, and the ________.
a. relationships between the tables
b. business rules
c. RDBMS
d. SQL engine
d. SQL engine
Each row in the relational table is known as an entity ________.
a. relationship
b. instance
c. model
d. attribute
b. instance
How is an entity represented in an ERD?
a. diamond
b. triangle
c. circle
d. rectangle
d. rectangle
What is the name for the most current (and most used) notation of the ERD?
a. Chen model
b. SQL
c. Crow’s Foot notation
d. Date model
c. Crow’s Foot notation
In the object-oriented data model (OODM), both data and their relationships are contained in a single structure known as a(n) ________.
a. attribute
b. object
c. entity
d. constraint
b. object
Classes are organized as a class ________.
a. object
b. system
c. hierarchy
d. method
c. hierarchy
In the OO data model, a class ________ represents a real-world action such as finding a selected PERSON’s name.
a. interface
b. method
c. inheritance
d. hierarchy
b. method
The ERDM is primarily geared to business applications, while the OODM tends to focus on ________ applications.
a. educational
b. personal
c. non-commercial Internet
d. very specialized engineering and scientific
d. very specialized engineering and scientific
Database models can be grouped into two categories: conceptual models and ________ models.
a. query
b. physical
c. logical
d. implementation
d. implementation
XML databases have emerged to address the need to manage ________ data within the native XML format.
a. structured
b. relational
c. unstructured
d. object-oriented
c. unstructured
Data models were developed to ________.
a. allow DBMSs to maintain loose control over the database activities
b. deposit data within a single file
c. model real-world objects or events
d. keep data within multiple data repositories
c. model real-world objects or events
Which model represents the end users’ view of the data environment?
a. internal
b. conceptual
c. physical
d. external
d. external
The most widely used conceptual model is the ________ model.
a. OO
b. implementation
c. E-R
d. internal
c. E-R
The ________ model presents a global view of the entire database.
a. logical
b. conceptual
c. network
d. physical
b. conceptual
A(n) ________ model is independent of both hardware and software.
a. developmental
b. conceptual
c. external
d. logical
b. conceptual
Which model operates at the lowest level of abstraction?
a. internal
b. conceptual
c. external
d. physical
d. physical
Which model is the representation of the database as “seen” by the DBMS?
a. internal
b. conceptual
c. physical
d. external
a. internal
