Quiz's Flashcards
Older systems that often contain data of poor quality are called ____ systems.
a. controlled
b. legacy
c. database
d. mainframe
legacy
A rule that CANNOT be violated by database users is called a:
a. password.
b. constraint.
c. program.
d. view
constraint
Data that describe the properties of other data are:
a. relationships.
b. logical.
c. physical.
d. None of these.
d. None of these.
A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):
a. relationship.
b. property.
c. attribute.
d. entity.
d. entity.
A ____ database supports data distributed across several different sites.
a. single-user
b. multiuser
c. centralized
d. distributed
d. distributed
A desktop database is a ____ database.
a. single-user
b. multiuser
c. workgroup
d. distributed
a. single-user
A(n) ____ database is used by an organization and supports many users across many departments.
a. desktop
b. workgroup
c. enterprise
d. transactional
c. enterprise
A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
a. desktop
b. workgroup
c. enterprise
d. transactional
b. workgroup
The response of the DBMS to a query is the ____.
a. ad hoc query
b. ad hoc response
c. query result set
d. integrated view of the data
c. query result set
A(n) ____ is anything about which data are to be collected and stored.
a. attribute
b. entity
c. relationship
d. constraint
b. entity
Business rules are derived from ____.
a. a detailed description of an organization’s operations
b. standards and practices developed over the years
c. managers’ recommendations
d. governmental oversight organization standards
a. a detailed description of an organization’s operations
A(n) ____ is a restriction placed on the data.
a. attribute
b. entity
c. relationship
d. constraint
d. constraint
____ are important because they help to ensure data integrity.
a. Attributes
b. Entities
c. Relationships
d. Constraints
d. Constraints
A(n) ____ is the equivalent of a field in a file system.
a. attribute
b. entity
c. relationship
d. constraint
a. attribute
The relational database model enables you to view data ____ rather than ____.
a. relationally, hierarchically
b. hierarchically, relationally
c. physically, logically
d. logically, physically
d. logically, physically
____ data can have only a true or false (yes or no) values.
a. Logical
b. Character
c. Date
d. Numeric
a. Logical
In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable.
a. relations
b. primary keys
c. indexes
d. logical structures
b. primary keys
In the context of a database table, the statement “A ____ B” indicates that if you know the value of attribute A, you can look up the value of attribute B.
a. contains
b. is related to
c. owns
d. determines
d. determines
The relational model’s creator, E. F. Codd, used the term relation as a synonym for ____.
a. index
b. key
c. table
d. relationship
c. table
The ERD represents the ____ database as viewed by the end user.
a. condensed
b. physical
c. logical
d. conceptual
d. conceptual
The ____ attribute(s) make up the primary key in the table definition:
CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)
a. CRS_CODE
b. CLASS_SECTION
c. CRS_CODE and CLASS_SECTION
d. There is no primary key
c. CRS_CODE and CLASS_SECTION
A ____ identifier is composed of more than one attribute.
a. primary
b. foreign
c. composite
d. domain
c. composite
The set of possible values for an attribute is a ____.
a. domain
b. range
c. set
d. key
a. domain
In a text-based ER description, primary keys are indicated by ____.
a. bolding
b. italics
c. underlining
d. a special font
c. underlining
A ____ could be a derived attribute.
a. person’s name
b. person’s age
c. person’s social security number
d. person’s phone number
b. person’s age
____ might be represented with a multivalued attribute.
a. A person’s name
b. Household phone numbers
c. A bank account balance
d. A book title
b. Household phone numbers
A ____ attribute can have only one value.
a. composite
b. simple
c. single-valued
d. multivalued
c. single-valued
A(n) ____ might be represented with a single-valued attribute.
a. person’s phone number(s)
b. car’s color
c. employee’s educational background
d. person’s social security number
d. person’s social security number
A derived attribute ____.
a. must be stored physically within the database
b. need not be physically stored within the database
c. has many values
d. must be based on the value of three or more attributes
b. need not be physically stored within the database
The extended entity relationship model (EERM) is sometimes referred to as the ____.
a. entity relationship model
b. enhanced entity relationship model
c. entity clustering relationship model
d. extended entity relationship diagram
b. enhanced entity relationship model
____ is a generic entity type that is related to one or more entity subtypes.
a. A subtype discriminator
b. Inheritance
c. A specialization hierarchy
d. An entity supertype
d. An entity supertype
One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.
a. primary
b. natural
c. foreign
d. surrogate
a. primary
Within a specialization hierarchy, every subtype can have ____ supertype(s) to which it is directly related.
a. zero
b. only one
c. one or many
d. many
b. only one
The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
a. subtype discriminator
b. inheritance
c. specialization hierarchy
d. entity supertype
c. specialization hierarchy
Data redundancy produces ____.
a. slower lookups
b. robust design
c. efficient storage use
d. data integrity problems
d. data integrity problems
A table that displays data redundancies most likely yields ____.
a. consistencies
b. anomalies
c. fewer attributes
d. more entities
b. anomalies
An attribute that is part of a key is known as a(n) ____ attribute.
a. important
b. nonprime
c. prime
d. entity
c. prime
____ yields better performance.
a. Denormalization
b. Normalization
c. Atomization
d. Compression
a. Denormalization
Normalization works through a series of stages called normal forms. For most purposes in business database design, ____ stages (foms) are as high as you need to go in the normalization process.
a. two
b. three
c. four
d. five
b. three
