Question 1

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

Accepted Answer

Unlike with the initial version,in the subsequent versions not all requirements will be collected from scratch.Original requirements provide the starting point for additions and alterations.Many of the additions and modifications result from observations and feedback by the end users during the use of the previous version,indicating the ways in which the database system can be improved or expanded.Other new requirements may stem from changes in the business processes that the database system supports,or changes in underlying technology.

Question 2

Conceptual data modeling is another term for requirements visualization.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is an example of analytical information?

Accepted Answer

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 
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 6

A DBMS can be used for creation of databases.

Accepted Answer

A) True 
 B)False

Question 7

Elaborate on why implicit requirement changes are not permitted.

Accepted Answer

Every time the set of requirements is ch

Question 8

Information can be used for:

Accepted Answer

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

Question 9

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

Accepted Answer

The type of interaction between the end

Question 10

What does the database metadata contain?

Accepted Answer

The database metadata contains the names

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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 
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

Question 13

What is the difference between conceptual and logical database modeling?

Accepted Answer

Logical database modeling refers to the

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

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 
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 18

Requirements can be refined and/or expanded following:

Accepted Answer

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

Question 19

What is metadata?

Accepted Answer

Metadata is the data that desc

Question 20

What is the purpose of a DBMS?

Accepted Answer

A database management system (

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

Conceptual data modeling is another term for requirements visualization.

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

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

Which of the following is an example of analytical information?

A DBMS can be used for creation of databases.

Elaborate on why implicit requirement changes are not permitted.

Information can be used for:

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

What does the database metadata contain?

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

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

What is the difference between conceptual and logical database modeling?

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

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

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

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

Requirements can be refined and/or expanded following:

What is metadata?

What is the purpose of a DBMS?

Database Requirements and ER Modeling

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Database Implementation and Use

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Overview of Dbms Functionalities and Database Administration

Filters

Exam 1: Introduction

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

Conceptual data modeling is another term for requirements visualization.

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

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

Which of the following is an example of analytical information?

A DBMS can be used for creation of databases.

Elaborate on why implicit requirement changes are not permitted.

Information can be used for:

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

What does the database metadata contain?

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

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

What is the difference between conceptual and logical database modeling?

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

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

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

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

Requirements can be refined and/or expanded following:

What is metadata?

What is the purpose of a DBMS?

Database Requirements and ER Modeling

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Database Implementation and Use

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Overview of Dbms Functionalities and Database Administration

Filters