Database System Quizzes

Helpfulness: 0
Set Details Share
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:
1

____is the result of revealing the meaning of raw facts.

Information

2

End_user data is____.

raw facts of interest to the end user

3

______provide a description of the data characteristics and the set of relationships that link the data found within the database.

Metadata

4

______exists when different versions of the same data appear in different places.

Data Incnsistency

5

The response of the DBMS to a query is the _____.

Query result set.

6

Data Warehouse contains historical data obtained from the______.

operational databases

7

_____data exist in the format in which they were collected.

unstructured

8

_______data exist in a format that does not lend itself to processing that yields information.

Unstructured

9

______is defined as the condition in which all the data in the database are consistent with the real-world events and conditions.

Data Integrity

10

The term_____ refers to an organization of components that define and regulate the collection,storage, management and use of data within a database environment.

Database system.

11

Business rules are derived from____.

A detailed description of an organization's operations

12

A noun in a business rule translates to a(n)___ in the data model.

Entity

13

A verb associating two nouns in a business rule translates to a(n)___in the data model.

Relationship.

14

A(n)___ represents a particular type of object in the real world.

Entity

15

The___model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.

entity relationship

16

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

Entity

17

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

attribute

18

A(n)__ is bidirectional.

Relationship

19

____are important because they help to ensure data integrity.

Constraints

20

Students and classes have a ____relationship.

Many-to-many

21

The logical view of the relational database is facilitated by the creation of data relationships based on a logical construct knows as a(n)___.

Relation

22

In a relational table, each column has a specific range of values knows as the ____domain

Attribute

23

In the relational model,___are important because they are used to ensure that each row in a table is uniquely identifiable.

Keys

24

Attribute A determines attribute B(that is, B is functionally _____ on A) if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Dependent

25

A(n)____key can be described as a superkey without unnecessary attributes.

candidate

26

If the foreign key contains either matching values or nulls, the table that makes use of that foreign key is said to exhibit ___integrity.

referential

27

To avoid nulls, some designers use special codes, known as____, to indicated the absence of some value.

Flags

28

The relational operators have the property of ____; that is, the use of relational algebra operators on existing relations(tables)produce new relations.

Closure

29

PRODUCT yields all possible pairs of rows from two tables--also known as the ____product.

Cartesian

30

The___ is the real power behind the relational database, allowing the use of independent tables linked by common attributes

JOIN

31

A(n)___links tables on the basis of an equality condition that compares specified columns of each table.

equijoin

32

The___joins are especially useful when you are trying to determine what value(s) in related tables cause(s) referential problems.

Outer

33

A(n)____provides a detailed description of all tables found with the user/designer-created database

data dictionary

34

The___relationship is the relational database norm.

1:M

35

If one department chair--a professor--can chair only one department and one department can hae only one department chair, the the entities PROFESSOR and DEPARTMENT exhibit a(n)___relationship.

1:1

36

The ___relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

M:N

37

The proper use of ___keys is crucial to controlling data redundacy

Foreign

38

A(n)___is an orderly arrangement used to logically access rows in a table.

Index

39

The index Key can have multiple attributes, this is call a(n)____index

composite

40

Codd's rule of ____states that every value in a table is guaranteed to be accessible through a combination of table name, primary key value, and column name.

Guaranteed Access.

41

The Chen model is especially useful to illustrate the database from a(n)___perspective.

Conceptual

42

Successful database design is, first and foremost, based on ___requirements.

End-user.

43

A derived attribute____.

need not be physically stored within the database.

44

Cardinality expresses___ number of entity occurrences associated with one occurrence of the related entity

the specific.

45

A____attribute can be further subdivided to yield additional attributes.

composite

46

If an entity can exist apart from one or more related entities, it is said to be ___-independent

existence

47

A___relationship exists when two entities are associated.

binary

48

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

domain

49

What type of attribute cannot be created in a DBMS?

Multivalued

50

A relationship name should be a(n)___.

verb

51

From a Structural point of view, 2NF is better than this

1NF

52

It produces a lower normal form

denormalization

53

it cause data redundancies of data on every row entry

duplication

54

Any attribute whose value determines other values within a row

determinant

55

A process to help reduce the likelihood of data anomalies

normalization

56

it derives its name from the face that a group of multiple entries of the same type can exist for any single key attribute occurrence.

repeating group

57

Any attribute that is at least part of a key

prime attribute

58

a diagram that depicts all dependencies found within a given table structure.

dependency diagram

59

a dependency bases on only a part of a composite primary key.

partial dependency

60

Refers to the level of detail represented by the values stored in a table's row.

granularity

61

Relational models view the data as part of a table or collection of tables in which all key values must be idenified

True

62

Repeating groups must be eliminated by making sure that each row defines a single entity

True

63

Converting a database format to 1NF to 2NF is a complex process.

False

64

A table is in 2NF if it is in 1NF and it includes no partial dependecies

True

65

It is possible for a table in 2NF to exhibit transitive dependency, where one or more attributes may be functionally dependent on non-key attributes.

True

66

Denormalization is a process for assigning attributes to entities

False

67

Dependencies that are based on only a part of a composite primary key are called transitive dependencies

False

68

Repeating groups must be eliminated by making sure that each column defines a single entity.

False

69

All relational tables satisfy the 1NF requirements.

True

70

Atomic attributes are attributes that can be further divided.

False