Deck 1: Introduction

Question 1

Front-end applications facilitate:

A)Direct use
B)Indirect use
C)Both direct and indirect use
D)Neither direct nor indirect use

Answer 1

B

Question 2

Which of the following is an example of a daily operational procedure or task supported by an operational database?

A)Deducting the correct amount of money from a customer's checking account upon an ATM withdrawal
B)Issuing a correct bill to a customer who purchased an airline ticket
C)Both A and B
D)None of the above

Answer 2

C

Question 3

Joe is an example of:

A)Data
B)Metadata
C)Data Type
D)DBMS

Answer 3

A

Question 4

FirstName is an example of:

A)Data
B)Metadata
C)Data Type
D)DBMS

Question 5

Implicit changes of requirements are permitted during:

A)Database deployment
B)Logical modeling
C)Database use
D)Implicit changes of requirements are not permitted

Question 6

End users can vary in:

A)Their level of technical sophistication
B)The amount of data they need
C)The frequency with which they access the database system
D)All of the above.

Question 7

Requirements can be refined and/or expanded following:

A)Database deployment
B)Logical modeling
C)Database use
D)All of the above

Question 8

The difference in the scope of databases is reflected in the:

A)Number of the development steps
B)Cost in time and resources required for each of the development steps
C)Level of importance of each of the development steps
D)Order of the development steps

Question 9

Which of the following is typically found in the database metadata?

A)Employee names
B)Data types
C)Student ages
D)Product prices

Question 10

Database implementation involves using ________ to implement the database model as an actual database.

A)Front-end applications
B)DBMS
C)Database system
D)Indirect interaction

Question 11

Which of the following is a database use action?

A)Securing data
B)Storing data
C)Modifying data
D)Modeling data

Question 12

The description of the structure and the properties of the data fits into which category?

A)Information
B)Data
C)Metadata
D)DBMS

Question 13

DBMS is software used for the following purpose:

A)Creation of databases
B)Insertion,storage,retrieval,update,and deletion of the data in the database
C)Maintenance of databases
D)All of the above

Question 14

________ are in charge of implementing the database model as a functioning database using the DBMS software.

A)Database analysts
B)Database architects
C)Database developers
D)DBAs

Question 15

Information can be used for:

A)Operational purposes only
B)Analytical purposes only
C)Operational and analytical purposes
D)Neither for operational nor for analytical purposes

Question 16

Which of the following is a component of a database system?

A)Database
B)DBMS
C)Front-end applications
D)All of the above

Question 17

Which of the following is a part of the database requirements step?

A)Database deployment
B)Logical modeling
C)Conceptual modeling
D)Database implementation

Question 18

Which of the following is a format in which data can appear?

A)Text
B)Numbers
C)Image
D)All of the above

Question 19

Which of the following is an example of analytical information?

A)Information about the amount of money in a checking account
B)Information showing which airline routes in the United States have the most sales
C)Information about the cost of a product
D)Information showing the destination and origin of a particular airline route in the United States

Question 20

Which of the following requires that the end user knows how to issue commands to the specific DBMS?

A)Direct interaction
B)Indirect interaction
C)Both direct and indirect interaction
D)Neither direct nor indirect interaction

Question 21

The new version of a database is created following the same development steps as the initial version.

Question 22

The type of interaction between the end user and the database that involves front-end applications is called direct interaction.

Question 23

Database administration encompasses the tasks related to the maintenance and supervision of a database system.

Question 24

Information that is collected in database systems can be used,in general,for two purposes: an operational purpose and a transactional purpose.

Question 25

Metadata is a subset of data that is most recently entered.

Question 26

A DBMS can be used for insertion and retrieval of the data in the database.

Question 27

The term data refers to facts that are recorded and can be accessed.

Question 28

Analytical information is based on operational information.

Question 29

Indirect interaction requires that the end user knows how to issue commands to the specific DBMS.

Question 30

Databases of different scope are developed following different fundamental development steps.

Question 31

Conceptual data modeling is another term for requirements visualization.

Question 32

The terms data and information should never be used as synonyms for each other.

Question 33

Front-end applications are created in order to provide a mechanism for easy interaction between the database and the DBMS.

Question 34

The term operational information refers to the information collected and used in support of day-to-day operational needs.

Question 35

A DBMS is a presentation software (such as MS Power Point).

Question 36

Analytical databases collect and present operational information in support of daily operational procedures and processes.

Question 37

The logical database model is created prior to the conceptual database model.

Question 38

During a proper requirements collection process,the requirements can be added iteratively and implicitly.

Question 39

A DBMS can be used for creation of databases.

Question 40

The term information refers to the data that is accessed by a user for some particular purpose.

Question 41

What does the database metadata contain?

Question 42

Create an example that shows data without its metadata and then the same data with its metadata.

Question 43

What is a database and what is its purpose?

Question 44

Explain the relationship between the terms data and information.

Question 45

Elaborate on why implicit requirement changes are not permitted.

Question 46

What is the difference between developing the initial and subsequent versions of the database system?

Question 47

What is the difference between conceptual and logical database modeling?

Question 48

What is metadata?

Question 49

Show a diagram that illustrates the principal activities in the process of the development of the database system.

Question 50

Illustrate a typical database system architecture.

Question 51

Using an example,describe the relationship between a DBMS and a database.

Question 52

What is the purpose of a DBMS?

Question 53

Explain the iterative nature of the database requirements phase.

Question 54

Describe and illustrate the relationship between the operational and analytical information.

Question 55

What is a database system?

Question 56

Describe the two types of interaction between the end user and the database.

Question 57

List the general categories of people involved with database projects and systems.