Deck 5: Data at the Core of the Enterprise

Question 1

Information generally refers to facts that can be stored in a computer system.

Answer 1

False

Question 2

Knowledge is processed data that can be transferred from one person to another without loss of integrity.

Answer 2

False

Question 3

Entity relationship modeling can be used for which of the following data models:

A) hierarchical
B) network
C) object
D) relational

Answer 3

network
object
relational

Question 4

Entity relationship modeling can be used for which of the following data models:

A) hierarchical
B) network
C) object
D) relational

Question 5

A file made up of rows and columns where the rows are records and the columns describe the data.

A) attribute
B) flat file
C) table
D) tuple

Question 6

Another name for a relation is:

A) attribute
B) flat file
C) table
D) tuple

Question 7

The first model to separate data from its processing. It was able to handle large amounts of data but lacked the expressiveness needed to represent many business situations.

A) hierarchical
B) network
C) object
D) relational

Question 8

Developed as a joint effort by industry and government, this model sustains complicated data relationships but requires them to be specified ahead of time making the database difficult to maintain.

A) hierarchical
B) network
C) object
D) relational

Question 9

The move to an network database model is bound to happen.

Question 10

The move to an hierarchical database model is bound to happen.

Question 11

Based upon a rigorous theoretical foundation, this model gives end-users the flexibility to query the database in unplanned way but tends to offer slow response times.

A) hierarchical
B) network
C) object
D) relational

Question 12

This model attempts to transcend pure data description by capturing both data and process but suffers from the lack of clear industry standards.

A) hierarchical
B) network
C) object
D) relational

Question 13

Among the jobs of a DBA are:

A) backing up database
B) database tuning
C) denormalization
D) keeping system available

Question 14

Among the jobs of a DBA are:

A) denormalization
B) database tuning
C) keeping system available
D) backing up database

Question 15

Thirty years ago a megabyte of memory for large computers cost about:

A) $500
B) $5,000
C) $50,000
D) $500,000

Question 16

Thirty years ago a megabyte of memory for large computers cost about:

A) $500
B) $5,000
C) $50,000
D) $500,000

Question 17

The most essential element of an enterprise system is likely to be the database management system.

Question 18

Which of the following is a DML command?

A) ALTER
B) EXIT
C) INSERT
D) SELECT

Question 19

Which of the following is a DDL command?

A) ALTER
B) UPDATE
C) INSERT
D) DROP