What Is A Benefit of Using A DBMS
What Is A Benefit of Using A DBMS
What Is A Benefit of Using A DBMS
2. What is the name for an answer to a query that the DBMS sends back to the application?
A. ? DBMS result
C. ? question result
D. ? data result
3. A single-user database that runs on a personal computer is called a(n) ____ database.
A. ? workgroup
B. ? distributed
C. ? enterprise
D. ? desktop
A. ? database
B. ? field value
C. ? entity
D. ? table
5. Data processing (DP) specialists are in existence because of _______.
A. ? Database administrators
B. ? Systems administrators
C. ? Database designers
A. ? COB
B. ? AIS
C. ? 3GL
D. ? DMB
8. The ____ receives all application requests and translates them into the complex operations
required to fulfill requests.
A. ? query
B. ? workgroup
C. ? DBMS
D. ? DP
9. A ____ focuses primarily on storing data used to generate information required to make
tactical or strategic decisions.
A. ? distributed database
B. ? workgroup database
C. ? data warehouse
D. ? production database
10. Accurate, relevant, and timely ____ is the key to good decision making.
A. ? information
B. ? processing
C. ? data
D. ? relationships
11. The word ____ indicates that the facts have not yet been processed to reveal their meaning.
A. ? raw
B. ? information
C. ? data
D. ? dictionary
12. What is the maximum number of users normally supported by a workgroup database?
A. ? 10
B. ? 30
C. ? 50
D. ? 100
13. Which of the following would result in a data anomaly?
B. ? modification of data
C. ? timeliness of data
D. ? obsolescence of data
14. Processed data, or ____, can be used as the basis for decision making.
A. ? raw data
B. ? information
C. ? queries
D. ? DP
A. ? number of users
D. ? software manufacturer
A. ? MS Access
B. ? MS SQL Server
C. ? IBM DB2
D. ? Oracle RDBMS
17. Data ____ exists when the same data are stored unnecessarily at different places.
A. ? dependency
B. ? redundancy
C. ? inconsistency
D. ? fragmentation
A. ? unique data
B. ? raw data
C. ? metadata
D. ? superdata
19. A ____ allows the user to specify what must be done without specifying how it must be done.
A. ? 1GL
B. ? 2GL
C. ? 3GL
D. ? 4GL
20. Database management systems, operating systems, applications and utilities are all
examples of ____.
A. ? software
B. ? hardware
C. ? computer infrastructure
Chapter 2
Data Models, Chapter 2
Quiz
A. ? implementation
B. ? ER
C. ? OO
D. ? internal
A. ? network
B. ? relational
C. ? semantic
D. ? entity relationship
3. In the OO data model, a class' ____ represents a real-world action such as finding a selected
PERSON's name.
A. ? inheritance
B. ? hierarchy
C. ? interface
D. ? method
A. ? member
B. ? owner
C. ? set
D. ? table
A. ? entity
B. ? internal
C. ? external
D. ? database
6. What type of relationship is expressed with the phrase "Employee manages Store"?
A. ? 1:*
B. ? 1:1
C. ? *:1
D. ? *:*
A. ? root
B. ? child
C. ? segment
D. ? parent
A. ? tree structure
D. ? matrix
9. The ERDM is primarily geared to business applications, while the OODM tends to focus on
____ applications.
A. ? educational
C. ? non-commercial Internet
D. ? personal
A. ? conceptual
B. ? external
C. ? developmental
D. ? logical
A. ? links
B. ? models
C. ? systems
D. ? intersections
14. What type of relationship is expressed with the phrase "Student takes Class"?
A. ? 1:*
B. ? 1:1
C. ? *:1
D. ? *:*
15. What modern development has drastically changed the role and scope of the database
market?
A. ? object-oriented programming
B. ? the Internet
C. ? Y2K
D. ? mainframes
B. ? has no standards
A. ? structural dependence
B. ? conceptual complexity
18. What is the fastest and most direct source of business rules?
A. ? company documentation
C. ? the Internet
A. ? conceptual
B. ? internal
C. ? external
D. ? physical
20. In response to the increasing complexity of applications, two new data models emerged: the
object-oriented data model and the ____ relational data model.
A. ? extended
B. ? flat-file
C. ? hierarchical
D. ? entity
Index =>
The entity relationship diagram is used to graphically represent the ________ database.
a. conceptual
b. condensed
c. logical
d. physical
a. domain
2
. b. range
c. set
d. key
a. bolding
3
. b. italics
c. special font
d. underlining
Which attribute(s) make up the primary key in the table definition CLASS
(CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)?
c. CLASS_SECTION
a. 0
5
. b. 1
c. 2
d. 6
A ________ identifier is a key that is composed of more than one attribute.
a. primary
6
. b. domain
c. foreign
d. composite
a. defined
7
. b. grouped
c. simple
d. complex
a. simple
8
. b. composite
c. single-valued
d. multivalued
a. Single-valued
9
. b. Simple
c. Composite
d. Multivalued
a. book title
1
0 b. bank account balance
.
c. person's name
a. multivalued
1
2 b. simple
.
c. derived
d. composite
The preferred way to represent multivalued attributes in a DBMS is to create a new entity
composed of the original multivalued attribute's components in a(n) ________ relationship with the
original entity.
1 a. 1:1
3
. b. weak
c. M:N
d. 1:M
a. person's name
1
5 b. person's phone number
.
c. person's age
a. double line
1
6 b. circle
.
c. dashed line
d. single line
a. databases
1
7 b. entities
.
c. objects
d. fields
a. (min, max)
1
8 b. [min ... max]
.
c. {min|max}
d. (max, min)
Cardinality expresses ________ number of entity occurrences associated with one occurrence of
the related entity.
1 a. an infinite
9
. b. an undetermined
d. a programmed
Knowing the ________ number of entity occurrences is very useful at the application software
level.
2
0 a. minimum
.
b. maximum and minimum
c. maximum
d. exact
If an entity's existence depends on the existence of one or more other entities it is said to be
________-dependent.
2 a. existence
1
. b. relationship
c. business
d. weak
If an entity can exist apart from one or more related entities, it is said to be ________-
independent.
2 a. existence
2
. b. business
c. weak
d. relationship
Connectivities and cardinalities are established by very concise statements known as ________.
a. derived attributes
2
3 b. business rules
.
c. relationships
d. assertions
a. solitary
2
4 b. unary
.
c. strong
d. weak
c. direct
d. strong
When the PK of a related entity does not contain a PK component of the parent entity, the
relationship is ________.
2 a. weak
6
. b. missing
c. strong
d. neutral
A ________ entity has a primary key that is partially or totally derived from the parent entity in the
relationship.
2 a. relationship
7
. b. weak
c. strong
d. business
In an ERD, the focus is on the ________ and the relationships between them.
a. indexes
2
8 b. keys
.
c. attributes
d. entities
The Crow's Foot model depicts the strong (identifying) relationship with a ________ line between
the entities.
2 a. bold
9
. b. solid
c. dashed
d. dotted
When loading data into two entities with a 1:M relationship, how should the data be loaded?
Remember that the nature of the relationship is often determined by the ________, who must use
professional judgment to determine which relationship type and strength best suit the database
transaction, efficiency, and information requirements.
3 a. RDBMS
1
. b. database designer
c. end user
d. ERD
a. undefined
3
2 b. weak
.
c. related
d. strong
The term ________ is used to label any condition in which one or more optional relationships
exist.
3 a. optionality
3
. b. cardinality
c. participation
d. connectivity
________ participation means that one entity occurrence does not require a corresponding entity
occurrence in a particular relationship.
3
4 a. Required
.
b. Indirect
c. Dependent
d. Optional
If no ________ symbol is depicted with an entity, the entity exists in a mandatory relationship with
the related entity.
3 a. cardinality
5
. b. optionality
c. strength
d. directional
Suppose that Tiny College offers several courses; each course has several classes. It is possible
for the department to create the entity COURSE first and then create the CLASS entity after
making the teaching assignments. In this case, what cardinality will appear for CLASS in the
ERD?
3
6 a. (0,1)
.
b. (1,1)
c. (0,N)
d. (1,N)
What cardinality is indicated by the Crow's Foot symbol that contains a line beside a crow's foot
shape?
3 a. (0,1)
7
. b. (1,1)
c. (0,N)
d. (1,N)
a. ternary
3
8 b. weak
.
c. binary
d. unary
b. weak
c. binary
d. unary
a. weak
4
0 b. ternary
.
c. binary
d. unary
A ________ relationship is one in which a relationship can exist between occurrences of the same
entity set.
a. dependent
4
1
. b. recursive
c. strong
d. weak
A(n) ________ entity is composed of the primary keys of each of the entities to be connected.
a. binary
4
2 b. composite
.
c. unary
d. associative
a. composite
4
3 b. strong
.
c. unary
d. weak
In the Crow's Foot model, the composite entity is identified by the ________ relationship line
between the parent and child entities.
4 a. dashed
4
. b. yellow
c. dotted
d. solid
a. sequential
4
5 b. optional
.
c. linear
d. iterative
a. cardinalities
4
7 b. optionalities
.
c. relationships
d. entities
A ________ attribute is an attribute that can be further subdivided to yield additional attributes.
a. composite
4
8 b. single-valued
.
c. multivalued
d. simple
A database design must conform to ________ standards.
a. design
4
9 b. ERD
.
c. notation
d. organizational
The database may have to sacrifice some of its "clean" design structures and/or some of its high
transaction speed to ensure ________.
a. transaction requirements
5
0 b. maximum information generation
.
c. space requirements
d. uniqueness
The word ________ indicates that the facts have not yet been processed to reveal their meaning.
a. information
1
. b. data
c. raw
d. dictionary
Processed data, or ________, can be used as the foundation for decision making.
a. raw data
2
. b. DP
c. information
d. queries
Raw data must be properly ________ for storage, processing, and presentation.
a. formatted
3
. b. arranged
c. grouped
d. sorted
a. It exists in a vacuum.
4
. b. It is assembled from raw data.
d. It cannot be duplicated.
Accurate, relevant, and timely ________ is the key to good decision making.
a. information
5
. b. data
c. relationships
d. processing
b. metadata
c. raw data
d. unique data
d. It helps create an environment for end users to have access to more data.
The ________ manages interaction between the end user and the database.
a. DM query engine
9
. b. DP
c. DBMQ
d. DBMS
The ________ receives all application requests and translates them into the complex operations required to fulfill r
a. workgroup
10
. b. DBMS
c. DP
d. query
c. pre-planned question
Wider access to well-managed data promotes a(n) ________ view of the organization's operations and a clearer v
a. automatic
12
. b. raw
c. transparent
d. integrated
What is the name for an answer to a query that the DBMS sends back to the application?
a. data result
13
. b. query result set
c. DBMS result
d. question result
A single-user database that runs on a personal computer is called a(n) ________ database.
a. distributed
14
. b. enterprise
c. desktop
d. workgroup
A database that supports data distributed across several different sites is called a(n) ________ database.
a. desktop
15
. b. workgroup
c. enterprise
d. distributed
16 A ________ focuses primarily on storing data used to generate information required to make tactical or strategic d
.
a. data warehouse
b. workgroup database
c. production database
d. distributed database
a. warehousing
17
. b. transactional
c. data mining
d. development
a. number of users
18
. b. database site location(s)
c. software manufacturer
John is working in the customer table and needs to know what customers are located in Florida. To find the inform
a. 10
20
. b. 30
c. 50
d. 100
b. MS Access
c. MS SQL Server
d. Oracle RDBMS
The design of a ________ database recognizes the use of historical and aggregated data.
a. multiuser
22
. b. data warehouse
c. single-user
d. production
a. computer
24
. b. software
c. database
d. file
a. closet
25
. b. data warehouse
c. database
d. file cabinet
d. group of files
a. file
27
. b. field
c. database
d. record
a. records
28
. b. information
c. relationships
d. data
A(n) ________ allows the user to specify what must be done without specifying how it must be done.
a. script
29
. b. nonprocedural language
c. object-oriented language
d. procedural language
Data ________ exists when it is possible to make changes in the data storage characteristics without affecting the
a. inconsistency
30
. b. independence
c. integrity
d. mining
31 Because all data access programs are subject to change when any of the file's data storage characteristics change
.
a. data dependence
c. data independence
a. structured
32
. b. logical
c. physical
d. outer
________ independence exists when it is possible to make changes in the file structure without affecting the applic
a. Logical
33
. b. Physical
c. Fragmentation
d. Structural
Data ________ exists when the same data are stored unnecessarily at different places.
a. dependency
34
. b. inconsistency
c. redundancy
d. fragmentation
a. timeliness of data
35
. b. modification of data
d. obsolescence of data
36 Data ________ is defined as "the condition in which all of the data in the database are consistent with the real-wor
.
a. redundancy
b. integrity
c. inconsistency
d. verification
A data ________ develops when all of the required changes in the redundant data are not made successfully.
a. anomaly
37
. b. redundancy
c. dependence
d. inconsistency
The term ________ refers to an organization of components that define and regulate the collection, storage, mana
a. DBMS
38
. b. hardware
c. database system
d. people
________ are the people who use application programs to run the organization's daily operations.
a. Managers
39
. b. Database programmers
c. Data practitioners
d. End users
Database management systems, operating systems, applications and utilities are all examples of ________.
a. hardware
40
. b. software
c. computer infrastructure
b. Systems administrators
d. Database designers
Where does the DBMS store the definitions of data elements and their relationships?
a. index
42
. b. data file
c. data dictionary
d. data map
________ are the instructions and rules that govern the design and use of the database system.
a. Software
43
. b. Data
c. Procedures
d. Hardware
Activities that make the database perform more efficiently in terms of storage and access speed are known as per
a. enhancements
44
. b. tuning
c. upgrades
d. development
The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a
a. access control
45
. b. table generator
c. security system
d. query language
46 ________ deals with fixing the database after a failure such as a hard disk malfunction.
.
a. Access control
b. Security
c. Backup
d. Recovery
________ is the de facto query language and data access standard supported by the majority of DBMS vendors.
a. 4GL
47
. b. Structured Query Language
c. DBMS
a. experience
1
. b. education
c. instinct
d. good judgment
A(n) ________ of the overall database design is required to overcome the fact that data are viewed in different way
a. analysis
2
. b. blueprint
c. footprint
d. review
A CUSTOMER ________ would be described by attributes such as customer last name, customer first name, custo
a. entity
3
. b. model
c. constraint
d. relationship
The basic building blocks of all data models are entities, attributes, relationships, and ________.
a. queries
4
. b. multiples
c. business rules
d. constraints
What type of relationship is expressed with the phrase "Painter paints Painting"?
a. M:N
5
. b. 1:1
c. M:1
d. 1:M
6 What type of relationship is expressed with the phrase "Employee manages Store"?
.
a. M:1
b. 1:1
c. 1:M
d. M:N
What type of relationship is expressed with the phrase "Student takes Class"?
a. 1:1
7
. b. M:1
c. M:N
d. 1:M
a. the Internet
8
. b. interviews with end users
d. company documentation
A(n) ________ is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific
a. attribute
9
. b. entity
c. constraint
d. business rule
As a general rule, a noun in a business rule will translate into a(n) ________ in the model.
a. constraint
10
. b. attribute
c. relationship
d. entity
c. matrix
a. many-to-many
12
. b. many-to-one
c. one-to-many
d. one-to-one
a. parent
13
. b. segment
c. root
d. child
a. XML
14
. b. extended relational
c. file system
d. relational
Within the network model, the ________ is the conceptual organization of the entire database as viewed by the da
c. DBTG
d. schema
b. set
c. table
d. DDL
a. field values
17
. b. tables
c. records
d. common fields
a. models
18
. b. links
c. systems
d. intersections
a. conceptual complexity
19
. b. complex database design
d. structural dependence
a. 4GL
20
. b. RDBMS
21 From an end-user perspective, any SQL-based relational database application involves three parts: a user interfac
.
a. SQL engine
b. RDBMS
d. business rules
a. instance
22
. b. attribute
c. model
d. relationship
a. rectangle
23
. b. circle
c. triangle
d. diamond
What is the name for the most current version of the ERD?
a. Chen model
24
. b. Crow's Foot notation
c. Date model
d. SQL
In the object-oriented data model (OODM), both data and their relationships are contained in a single structure kno
a. constraint
25
. b. attribute
c. entity
d. object
a. object
27
. b. hierarchy
c. system
d. method
In the OO data model, a class ________ represents a real-world action such as finding a selected PERSON's nam
a. hierarchy
28
. b. interface
c. method
d. inheritance
The ERDM is primarily geared to business applications, while the OODM tends to focus on ________ applications
a. educational
29
. b. personal
c. non-commercial Internet
Database models can be grouped into two categories: conceptual models and ________ models.
a. implementation
30
. b. physical
c. logical
d. query
31 In response to the increasing complexity of applications, two new data models emerged: the object-oriented data m
.
a. hierarchical
b. entity
c. extended
d. flat-file
a. Y2K
32
. b. object-oriented programming
c. mainframes
d. the Internet
XML databases have emerged to address the need to manage ________ data within the native XML format.
a. relational
34
. b. object-oriented
c. unstructured
d. structured
b. object-oriented
c. hierarchical
d. relational
a. hierarchical
37
. b. network
c. relational
d. object-oriented
a. knowledge
38
. b. abstraction
c. unification
d. difficulty
Which model represents the end users' view of the data environment?
a. internal
39
. b. physical
c. external
d. conceptual
a. physical model
40
. b. relational schema
c. external schema
d. conceptual model
b. internal
c. implementation
d. OO
a. network
42
. b. logical
c. conceptual
d. physical
a. developmental
43
. b. external
c. conceptual
d. logical
a. internal
44
. b. database
c. external
d. entity
a. relational
45
. b. network
c. semantic
d. entity relationship
b. external
c. physical
d. conceptual
When you can change the physical model without affecting the internal model, you have ________.
a. a logical database
47
. b. physical dependence
c. physical independence
d. conceptual separation