Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

LIS 3784 > Quiz's > Flashcards

Quiz's Flashcards

1
Q

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

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

A

legacy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

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

A

constraint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Data that describe the properties of other data are:

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

A

d. None of these.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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.

A

d. entity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A ____ database supports data distributed across several different sites.

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

A

d. distributed

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

A desktop database is a ____ database.

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

A

a. single-user

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

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

A

c. enterprise

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

b. workgroup

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

c. query result set

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

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

A

b. entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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. a detailed description of an organization’s operations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

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

A

d. constraint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

____ are important because they help to ensure data integrity.

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

A

d. Constraints

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

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

A

a. attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

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

A

d. logically, physically

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

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

A

a. Logical

17
Q

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

A

b. primary keys

18
Q

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

A

d. determines

19
Q

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

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

A

c. table

20
Q

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

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

A

d. conceptual

21
Q

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

A

c. CRS_CODE and CLASS_SECTION

22
Q

A ____ identifier is composed of more than one attribute.

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

A

c. composite

23
Q

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

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

A

a. domain

24
Q

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

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

A

c. underlining

25
Q

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

A

b. person’s age

26
Q

____ 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

A

b. Household phone numbers

27
Q

A ____ attribute can have only one value.

a. composite
b. simple
c. single-valued
d. multivalued

A

c. single-valued

28
Q

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

A

d. person’s social security number

29
Q

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

A

b. need not be physically stored within the database

30
Q

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

A

b. enhanced entity relationship model

31
Q

____ 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

A

d. An entity supertype

32
Q

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

a. primary

33
Q

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

A

b. only one

34
Q

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

A

c. specialization hierarchy

35
Q

Data redundancy produces ____.

a. slower lookups
b. robust design
c. efficient storage use
d. data integrity problems

A

d. data integrity problems

36
Q

A table that displays data redundancies most likely yields ____.

a. consistencies
b. anomalies
c. fewer attributes
d. more entities

A

b. anomalies

37
Q

An attribute that is part of a key is known as a(n) ____ attribute.

a. important
b. nonprime
c. prime
d. entity

A

c. prime

38
Q

____ yields better performance.

a. Denormalization
b. Normalization
c. Atomization
d. Compression

A

a. Denormalization

39
Q

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

A

b. three

LIS 3784 (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions