Exam 2: Database Development Process

The ____________________ design stage uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.

(Short Answer)

4.8/5

(36)

Question 41

The process of database design and implementation is ____ development.

(Multiple Choice)

4.9/5

(29)

Question 42

____ coupling describes the extent to which modules are independent of one another.

(Multiple Choice)

4.8/5

(31)

Question 43

After the initial declarations in a study, the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.

(True/False)

4.8/5

(34)

Question 44

The first step in the DBLC is ____.

(Multiple Choice)

5.0/5

(37)

Question 45

The primary objective in database design is to create complete, denormalized, redundant, and fully integrated conceptual, logical, and physical database models.

(True/False)

4.8/5

(32)

Question 46

Installation and fine tuning are part of the ____ phase of the SDLC.

(Multiple Choice)

4.9/5

(45)

Question 47

The conceptual design step that defines the DBMS and data model to use is ____.

(Multiple Choice)

4.8/5

(39)

Question 48

The term "database development" is used to describe the process of database design and implementation.

(True/False)

4.9/5

(39)

Question 49

After testing is concluded, end-user training is not necessary.

(True/False)

4.9/5

(32)

Question 50

During the testing phase, the system is subjected to exhaustive testing until it is ready for use.

(True/False)

4.9/5

(30)

Question 51

A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.

(True/False)

4.9/5

(46)

Question 52

The advent of very sophisticated application generators and ____________________ tools has substantially decreased coding and testing time.

(Short Answer)

4.8/5

(35)

Question 53

The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.

(True/False)

4.8/5

(28)

Question 54

List and briefly describe the three types of system maintenance activities.

(Essay)

4.9/5

(29)

Question 55

In the detailed systems design phase, steps are laid out for conversion from the old system to the new system.

(True/False)

4.8/5

(30)

Question 56

The SDLC's planning phase yields a general overview of the company and its objectives.

(True/False)

4.9/5

(36)

Question 57

What are the factors affecting the purchasing decision for DBMS software?

(Essay)

4.9/5

(36)

Question 58

The ____________________ design goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details.

(Short Answer)

4.7/5

(29)

Question 59

Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful.

(True/False)

4.7/5

(32)

Question 60

Showing 41 - 60 of 100

The ____________________ design stage uses data modeling to create an abstract database structure that represents real-world objects in the most realistic way possible.

The process of database design and implementation is ____ development.

____ coupling describes the extent to which modules are independent of one another.

After the initial declarations in a study, the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations.

The first step in the DBLC is ____.

The primary objective in database design is to create complete, denormalized, redundant, and fully integrated conceptual, logical, and physical database models.

Installation and fine tuning are part of the ____ phase of the SDLC.

The conceptual design step that defines the DBMS and data model to use is ____.

The term "database development" is used to describe the process of database design and implementation.

After testing is concluded, end-user training is not necessary.

During the testing phase, the system is subjected to exhaustive testing until it is ready for use.

A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.

The advent of very sophisticated application generators and ____________________ tools has substantially decreased coding and testing time.

The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.

List and briefly describe the three types of system maintenance activities.

In the detailed systems design phase, steps are laid out for conversion from the old system to the new system.

The SDLC's planning phase yields a general overview of the company and its objectives.

What are the factors affecting the purchasing decision for DBMS software?

The ____________________ design goal is to design an enterprise-wide database based on a specific data model but independent of physical-level details.

Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful.

The Database Approach

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters