Filters
Question type

Study Flashcards

Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules.

A) True
B) False

Correct Answer

verifed

verified

The design of the system's processes is completed during the ____ phase of the SDLC.


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

E) A) and D)
F) None of the above

Correct Answer

verifed

verified

The first step in ____________________ design is to discover the data element characteristics.

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Installing the DBMS,creating the database,and loading or converting the data are part of the ____ phase of the DBLC.


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

E) None of the above
F) B) and C)

Correct Answer

verifed

verified

C

The database initial study phase of the DBLC involves ____.


A) defining objectives
B) introducing changes
C) testing the database
D) installing the DBMS

E) None of the above
F) A) and C)

Correct Answer

verifed

verified

A

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Database backups can be performed at different levels.List and describe these.

Correct Answer

verifed

verified

A full backup,or dump,of the entire data...

View Answer

The implementation and loading phase of the DBLC involves ____.


A) defining objectives
B) introducing changes
C) testing the database
D) installing the DBMS

E) A) and D)
F) None of the above

Correct Answer

verifed

verified

The process of creating an information system is known as ____ development.


A) systems
B) database
C) network
D) transformation

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

A

During decentralized design,after the ____ process has been completed,all modules are integrated into one conceptual model.


A) initial
B) verification
C) conceptual
D) logical

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

The conceptual design step that determines end-user views,outputs,and transaction-processing requirements is ____.


A) data analysis and requirements
B) entity relationship modeling and normalization
C) data model verification
D) distributed database design

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Once the data has been loaded into the database,the ____ tests and fine-tunes the database for performance,integrity,concurrent access,and security constraints.


A) programmer
B) manager
C) database administrator
D) systems administrator

E) B) and C)
F) B) and D)

Correct Answer

verifed

verified

There are ____ stages in the DBLC.


A) four
B) five
C) six
D) seven

E) A) and D)
F) A) and B)

Correct Answer

verifed

verified

After testing is concluded,the final ____________________ is reviewed and printed and end users are trained.

Correct Answer

verifed

verified

From a database point of view,the collection of data becomes meaningful only when the business ____________________ are defined.

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Because real-world database design is generally done by teams,you should strive to organize the design's major components into ____________________.

Correct Answer

verifed

verified

Showing 1 - 20 of 100

Related Exams

Show Answer