Question 1

The testing and evaluation phase of the Database Life Cycle (DBLC)occurs after applications programming.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

In DBLC,the phase after the database initial study is .

Accepted Answer

A) operation 
B) database design 
C) database initial study 
D) implementation and loading 
A) operation 
B) database design 
C) database initial study 
D) implementation and loading

Question 4

The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC).

Accepted Answer

A) analysis 
B) detailed systems design 
C) implementation 
D) maintenance 
A) analysis 
B) detailed systems design 
C) implementation 
D) maintenance

Question 5

The first step in developing the conceptual model using ER diagrams is to .

Accepted Answer

A) normalize the entities 
B) complete the initial ER diagram 
C) identify,analyze,and refine the business rules 
D) define the attributes,primary keys,and foreign keys for each of the entities 
A) normalize the entities 
B) complete the initial ER diagram 
C) identify,analyze,and refine the business rules 
D) define the attributes,primary keys,and foreign keys for each of the entities

Question 6

"What are the requirements of the current system's end users?" is a question asked during the phase of the Systems Development Life Cycle (SDLC).

Accepted Answer

A) planning 
B) analysis 
C) implementation 
D) maintenance 
A) planning 
B) analysis 
C) implementation 
D) maintenance

Question 7

The Systems Development Life Cycle's (SDLC's)planning phase yields a general overview of the company and its objectives.

Accepted Answer

A) True 
 B)False

Question 8

is the process that establishes the need for,and the extent of,an information system.

Accepted Answer

The answer of is the process that establishes the need...

Question 9

In most modern relational DBMSs,a new database implementation requires the creation of special storage-related constructs to house the end-user tables.

Accepted Answer

A) True 
 B)False

Question 10

The first step in the ER model verification process is to .

Accepted Answer

A) identify each module and its components 
B) identify the ER model's central entity 
C) verify all processes against the ER model 
D) identify each module's internal transaction requirements 
A) identify each module and its components 
B) identify the ER model's central entity 
C) verify all processes against the ER model 
D) identify each module's internal transaction requirements

Question 11

List and describe the different levels at which database backups can be performed.

Accepted Answer

A full backup,or dump,of the entire data

Question 12

The proposed system is subject to limits known as ,which are external to the system.

Accepted Answer

The answer of The proposed system is subject to limits...

Question 13

"Should the existing system be replaced?" is a question that is asked during the stage of the Systems Development Life Cycle (SDLC).

Accepted Answer

A) planning 
B) analysis 
C) implementation 
D) maintenance 
A) planning 
B) analysis 
C) implementation 
D) maintenance

Question 14

A rule is a brief and precise narrative of a policy,procedure,or principle within a specific organization's environment.

Accepted Answer

The answer of A rule is a brief and precise...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

After the initial declarations in Database Life Cycle (DBLC),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.

Accepted Answer

A) True 
 B)False

Question 17

is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.

Accepted Answer

A) Normalization 
B) Virtualization 
C) Specialization 
D) Generalization 
A) Normalization 
B) Virtualization 
C) Specialization 
D) Generalization

Question 18

Selecting database management system (DBMS)software is part of the phase of the Database Life Cycle (DBLC).

Accepted Answer

A) database initial study 
B) database design 
C) implementation and loading 
D) testing and evaluation 
A) database initial study 
B) database design 
C) implementation and loading 
D) testing and evaluation

Question 19

When selecting DBMS ,items to consider include processors,RAM,and disk space.

Accepted Answer

The answer of When selecting DBMS ,items to consider include...

Question 20

The database administrator must be prepared to perform routine maintenance activities within the database.

Accepted Answer

A) True 
 B)False

The testing and evaluation phase of the Database Life Cycle (DBLC)occurs after applications programming.

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

In DBLC,the phase after the database initial study is .

The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC).

The first step in developing the conceptual model using ER diagrams is to .

"What are the requirements of the current system's end users?" is a question asked during the phase of the Systems Development Life Cycle (SDLC).

The Systems Development Life Cycle's (SDLC's)planning phase yields a general overview of the company and its objectives.

is the process that establishes the need for,and the extent of,an information system.

In most modern relational DBMSs,a new database implementation requires the creation of special storage-related constructs to house the end-user tables.

The first step in the ER model verification process is to .

List and describe the different levels at which database backups can be performed.

The proposed system is subject to limits known as ,which are external to the system.

"Should the existing system be replaced?" is a question that is asked during the stage of the Systems Development Life Cycle (SDLC).

A rule is a brief and precise narrative of a policy,procedure,or principle within a specific organization's environment.

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

After the initial declarations in Database Life Cycle (DBLC),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.

is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.

Selecting database management system (DBMS)software is part of the phase of the Database Life Cycle (DBLC).

When selecting DBMS ,items to consider include processors,RAM,and disk space.

The database administrator must be prepared to perform routine maintenance activities within the database.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language SQL

Advanced SQL

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 9: Database Design

The testing and evaluation phase of the Database Life Cycle (DBLC)occurs after applications programming.

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

In DBLC,the phase after the database initial study is .

The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC).

The first step in developing the conceptual model using ER diagrams is to .

"What are the requirements of the current system's end users?" is a question asked during the phase of the Systems Development Life Cycle (SDLC).

The Systems Development Life Cycle's (SDLC's)planning phase yields a general overview of the company and its objectives.

is the process that establishes the need for,and the extent of,an information system.

In most modern relational DBMSs,a new database implementation requires the creation of special storage-related constructs to house the end-user tables.

The first step in the ER model verification process is to .

List and describe the different levels at which database backups can be performed.

The proposed system is subject to limits known as ,which are external to the system.

"Should the existing system be replaced?" is a question that is asked during the stage of the Systems Development Life Cycle (SDLC).

A rule is a brief and precise narrative of a policy,procedure,or principle within a specific organization's environment.

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

After the initial declarations in Database Life Cycle (DBLC),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.

is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.

Selecting database management system (DBMS)software is part of the phase of the Database Life Cycle (DBLC).

When selecting DBMS ,items to consider include processors,RAM,and disk space.

The database administrator must be prepared to perform routine maintenance activities within the database.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Ermodeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language SQL

Advanced SQL

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Big Data Analytics and NoSQL

Database Connectivity and Web Technologies

Database Administration and Security

Filters