Quiz's

Question 1

Older systems that often contain data of poor quality are called ____ systems.

a. controlled
b. legacy
c. database
d. mainframe

Answer 1

legacy

Question 2

A rule that CANNOT be violated by database users is called a:

a. password.
b. constraint.
c. program.
d. view

Answer 2

constraint

Question 3

Data that describe the properties of other data are:

a. relationships.
b. logical.
c. physical.
d. None of these.

Answer 3

d. None of these.

Question 4

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.

Answer 4

d. entity.

Question 5

A ____ database supports data distributed across several different sites.

a. single-user
b. multiuser
c. centralized
d. distributed

Answer 5

d. distributed

Question 6

A desktop database is a ____ database.

a. single-user
b. multiuser
c. workgroup
d. distributed

Answer 6

a. single-user

Question 7

A(n) ____ database is used by an organization and supports many users across many departments.

a. desktop
b. workgroup
c. enterprise
d. transactional

Answer 7

c. enterprise

Question 8

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

Answer 8

b. workgroup

Question 9

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

Answer 9

c. query result set

Question 10

A(n) ____ is anything about which data are to be collected and stored.

a. attribute
b. entity
c. relationship
d. constraint

Answer 10

b. entity

Question 11

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

Answer 11

a. a detailed description of an organization’s operations

Question 12

A(n) ____ is a restriction placed on the data.

a. attribute
b. entity
c. relationship
d. constraint

Answer 12

d. constraint

Question 13

____ are important because they help to ensure data integrity.

a. Attributes
b. Entities
c. Relationships
d. Constraints

Answer 13

d. Constraints

Question 14

A(n) ____ is the equivalent of a field in a file system.

a. attribute
b. entity
c. relationship
d. constraint

Answer 14

a. attribute

Question 15

The relational database model enables you to view data ____ rather than ____.

a. relationally, hierarchically
b. hierarchically, relationally
c. physically, logically
d. logically, physically

Answer 15

d. logically, physically

Question 16

____ data can have only a true or false (yes or no) values.

a. Logical
b. Character
c. Date
d. Numeric

Answer 16

a. Logical

Question 17

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

Answer 17

b. primary keys

Question 18

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

Answer 18

d. determines

Question 19

The relational model’s creator, E. F. Codd, used the term relation as a synonym for ____.

a. index
b. key
c. table
d. relationship

Answer 19

c. table

Question 20

The ERD represents the ____ database as viewed by the end user.

a. condensed
b. physical
c. logical
d. conceptual

Answer 20

d. conceptual

Question 21

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

Answer 21

c. CRS_CODE and CLASS_SECTION

Question 22

A ____ identifier is composed of more than one attribute.

a. primary
b. foreign
c. composite
d. domain

Answer 22

c. composite

Question 23

The set of possible values for an attribute is a ____.

a. domain
b. range
c. set
d. key

Answer 23

a. domain

Question 24

In a text-based ER description, primary keys are indicated by ____.

a. bolding
b. italics
c. underlining
d. a special font

Answer 24

c. underlining

Question 25

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

Answer 25

b. person’s age

Question 26

____ 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

Answer 26

b. Household phone numbers

Question 27

A ____ attribute can have only one value. a. composite b. simple c. single-valued d. multivalued

Answer 27

c. single-valued

Question 28

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

Answer 28

d. person’s social security number

Question 29

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

Answer 29

b. need not be physically stored within the database

Question 30

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

Answer 30

b. enhanced entity relationship model

Question 31

____ 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

Answer 31

d. An entity supertype

Question 32

One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype. a. primary b. natural c. foreign d. surrogate

Answer 32

a. primary

Question 33

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

Answer 33

b. only one

Question 34

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

Answer 34

c. specialization hierarchy

Question 35

Data redundancy produces ____. a. slower lookups b. robust design c. efficient storage use d. data integrity problems

Answer 35

d. data integrity problems

Question 36

A table that displays data redundancies most likely yields ____. a. consistencies b. anomalies c. fewer attributes d. more entities

Answer 36

b. anomalies

Question 37

An attribute that is part of a key is known as a(n) ____ attribute. a. important b. nonprime c. prime d. entity

Answer 37

c. prime

Question 38

____ yields better performance. a. Denormalization b. Normalization c. Atomization d. Compression

Answer 38

a. Denormalization

Question 39

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

Answer 39

b. three