Tutorial CD115 Week 4

1. Which of the following is the correct first phase of the Database Life Cycle (DBLC)?

• Database design

• Database initial study

• Implementation and loading

• Testing and evaluation

2. What is the main purpose of the database initial study phase?

• To choose database software

• To normalize tables

• To analyze company needs and define objectives

• To install the DBMS

3. Which activity is NOT part of the database design phase?

• Create conceptual design

• Create physical design

• Load or convert data

• Select DBMS software

4. Which of the following best describes the implementation and loading phase?

• Evaluating the system performance

• Loading data into tables after DBMS installation

• Conducting normalization

• Drawing ER diagrams

5. What is the main goal of the testing and evaluation phase?

• 
  Backup and recovery

• 
  Entity relationship modeling

• 
  Ensure security, performance, and correct operation

• 
  Select storage organization

6. Which of the following is a typical activity during the operation phase?

• 
  Virtualization

• Regular backups

• C. Query normalization

• 
  Solving real-time performance issues

7. In which phase would adaptive maintenance and user access control typically occur?

• 
  Database design

• 
  Implementation and loading

• 
  Maintenance and evolution

• 
  Testing and evaluation

8. What is the relationship between DBLC and SDLC?

• 
  DBLC is not related to SDLC

• 
  DBLC is part of SDLC

• 
  SDLC follows DBLC

• 
  They are the same process

9. Which of the following tools can be used during the data loading process?

• 
  ER diagrams

• 
  SQL scripts and ETL tools

• 
  DBMS selection form

• 
  Access control panel

10. What does physical database design define?

• Relationships between entities

• 
  Storage structure, indexes, and access control

• Business rules and cardinalities

• User interface layouts