Additional Questions from Test Bank Flashcards
The database structure in a DBMS is stored as a _____.
A. collection of queries
B. collection of files
C. single file
D. set of key/value pairs
B. collection of files
An XML database supports the storage and management of _____ XML data.
A. fullystructured
B. multistructured
C. structured
D. semistructured
D. semistructured
A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user.
A. True
B. False
B. False
The hierarchical model is software-independent.
A. True
B. False
B. False
A data warehouse can store data derived from many sources.
A. True
B. False
A. True
In Chen notation, entities and relationships have to be oriented horizontally; not vertically.
A. True
B. False
B. False
Data is the result of processing raw facts to reveal its meaning.
A. True
B. False
B. False
VMS/VSAM is an example of the _____.
A. XML data model
B. relational data model
C. hierarchical model
D. file system data model
D. file system data model
A(n) _____ is the equivalent of a field in a file system.
A. relationship
B. attribute
C. entity
D. constraint
B. attribute
The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
A. object-oriented
B. hierarchical
C. entity relationship
D. network
C. entity relationship
A _____ is a logically connected set of one or more fields that describes a person, place, or thing.
A. database
B. record
C. column
D. file
B. record
_____ are important because they help to ensure data integrity.
A. Entities
B. Attributes
C. Relationships
D. Constraints
D. Constraints
An implementation-ready data model should contain a description of the data structure that will store the end-user data.
A. True
B. False
A. True
_____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.
A. Data quality
B. Data integrity
C. Data anomaly
D. Data ubiquity
B. Data integrity
When two or more tables share the same number of columns, and when their corresponding columns share the same or compatible domains, they are said to be _____.
A. difference-compatible
B. union-compatible
C. select-compatible
D. intersect-compatible
B. union-compatible
In the entity relationship model, a table row corresponds to an entity instance.
A. True
B. False
A. True
The CUSTOMER table’s primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of _____ integrity.
A. null
B. entity
C. relational
D. referential
B. entity
The Crow’s foot symbol with two vertical parallel lines indicates _____ cardinality.
A. (0,1)
B. (1,1)
C. (1,N)
D. (0,N)
B. (1,1)
To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent _____ relationships whenever possible.
A. weak
B. unary
C. binary
D. strong
C. binary
A _____ contains at least all of the attribute names and characteristics for each table in the system.
A. relational schema
B. database
C. data dictionary
D. logical schema
C. data dictionary
The first step in building an entity-relationship diagram (ERD) is _____.
A. identifying the business rules based on the description of operations
B. identifying the attributes and primary keys that adequately describe the entities
C. developing the initial ERD
D. creating a detailed narrative of the organization’s description of operations
D. creating a detailed narrative of the organization’s description of operations
Character data can contain any character or symbol intended for mathematical manipulation.
A. True
B. False
B. False
The _____ relationship is the “relational model ideal.”
A. 1:M
B. M:1
C. M:N
D. 1:1
A. 1:M
A _____ is any key that uniquely identifies each row.
A. candidate key
B. special key
C. foreign key
D. superkey
D. superkey
_____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.
A. UNION
B. DIFFERENCE
C. INTERSECT
D. SELECT
D. SELECT
A(n) _____ is the set of possible values for a given attribute.
A. range
B. identifier
C. domain
D. key
C. domain
Date attributes contain calendar dates stored in a special format known as the _____ date format.
A. logical
B. calendar
C. Epoch
D. Julian
D. Julian
In organizations that generate large number of transactions, _____ are often a top priority in database design.
A. logical design standards
B. relationships among entities
C. naming conventions
D. high processing speeds
D. high processing speeds
Referential integrity and participation are both bidirectional, meaning that they must be addressed in both directions along a relationship.
A. True
B. False
B. False
The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application.
A. derived
B. multivalued
C. single-valued
D. composite
A. derived
In the original Chen notation, each attribute is represented by an oval with the attribute name connected to an entity rectangle with a line.
A. True
B. False
A. True
At the implementation level, the supertype and its subtype(s) depicted in a specialization hierarchy maintain a(n) _____ relationship.
A. M:N
B. 1:1
C. 1:M
D. self-referencing
B. 1:1
Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed only once in the _____ relationship.
A. M:N
B. 1:M
C. 0:1
D. 1:1
A. M:N
The property of _____ enables an entity subtype to inherit the attributes and relationships of the supertype.
A. inheritance
B. subtype discriminator
C. specialization hierarchy
D. entity supertype
A. inheritance
Generalization is based on grouping unique characteristics and relationships of the subtypes.
A. True
B. False
B. False
An entity cluster is formed by combining multiple interrelated entities into _____.
A. a single entity object
B. a single abstract entity object
C. multiple entity objects
D. multiple abstract entity objects
B. a single abstract entity object
A partial completeness constraint is represented by _____.
A. a dotted line
B. a double horizontal line over a circle
C. two dashed lines
D. a single horizontal line under a circle
D. a single horizontal line under a circle
The “_____” characteristic of a primary key states that the selected primary key must not be composed of any attribute(s) that might be considered a violation.
A. unique values
B. nonintelligent
C. preferably single-attribute
D. security-compliant
D. security-compliant
_____ data refer to data whose values change over time and for which one must keep a history of the data changes.
A. Historical
B. Time-sensitive
C. Change-based
D. Time-variant
D. Time-variant
When designing a database, you should _____.
A. consider more important issues such as performance before normalizing
B. only normalize the database when performance problems occur
C. make sure that entities are in normal form before table structures are created
D. create table structures then normalize the database
C. make sure that entities are in normal form before table structures are created
Of the following normal forms, _____ is mostly of theoretical interest.
A. BCNF
B. DKNF
C. 1NF
D. 3NF
B. DKNF
_____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.
A. Report
B. Temporary
C. Data warehouse
D. Normalized
C. Data warehouse
A table where every determinant is a candidate key is said to be in _____.
A. 4NF
B. BCNF
C. 2NF
D. 1NF
B. BCNF
A table is in 4NF if it is in 3NF, and _____.
A. no column contains the same values
B. all attributes must be dependent on the primary key and must be dependent on each other
C. all attributes are unrelated
D. it has no multivalued dependencies
D. it has no multivalued dependencies
In order to meet performance requirements, portions of the database design may need to be occasionally denormalized.
A. True
B. False
A. True
Attributes should clearly define participation, connectivity, and document cardinality.
A. True
B. False
B. False
From a structural point of view, 3NF is better than _____.
A. 6NF
B. 4NF
C. 5NF
D. 2NF
D. 2NF
Dependencies based on only a part of a composite primary key are known as _____ dependencies.
A. incomplete
B. primary
C. composite
D. partial
D. partial