FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 9: Database Design

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

In the Systems Development Life Cycle(SDLC), the design of the system's processes begins in the detailed systems design phase.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is a hardware-induced database failure?

A) Memory chip errors
B) Viruses
C) Malware
D) Abortion due to deadlock

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

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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

The last step in the Database Life Cycle (DBLC) is .

The traditional Systems Development Life Cycle (SDLC) is divided into phases.

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

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

Making sure that the final product meets user and system requirements is the most critical phase.

A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC).

Installing the DBMS, creating the database, and loading or converting the data are part of the phase of the Database Life Cycle (DBLC) .

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

During the implementation phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.

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

The system and operational costs are addressed by the during the planning phase of the Systems Development Life Cycle (SDLC).

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

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

Physical design becomes simpler when data is distributed at different locations.

In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase.

The system is subjected to exhaustive testing during the testing phase of the Systems Development Life Cycle (SDLC).

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