Database System 1930 - Quiz 2

1. Defining the objectives, scope and boundaries are done in the __________ phase of the DBLC.

• A. operation

• B. database initial study

• C. database design

• D. implementation and maintenance

2. Which of the following is NOT performed in the logical design of database?

• A. Define integrity and security measures.

• B. Using normalisation to validate the logical model.

• C. Validate logical model against user requirements.

• D. Map conceptual model to logical model component.

3. Only modified/ updated objects since last full backup are backed up is referred as __________.

• A. differential backup

• B. full backup

• C. image backup

• D. transaction log backup.

4. __________ describes the extent to which modules are independent of one another.

• A. Cohesivity

• B. Associativeness

• C. Module coupling

• D. Multiplicities

5. Clustered tables is a technique that stores related rows from two related tables in adjacent data blocks on disk.

• A. True

• B. False

6. There are two types of database design strategies, which are top-down design and bottom-up design.

• A. True

• B. False

7. An entity in ER-Model is modeled as __________ in UML.

• A. relationship

• B. attribute

• C. class

• D. constraints

8. Based on the UML notation, a __________ attribute can be modeled by listing the components below the attribute.

• A. single value

• B. composite

• C. multivalued

• D. simple

9. A derived attribute can be modeled by prefixing a dash (-) to the attribute’s name.

• A. True

• B. False

10. The relationship in UML is labeled in two direction, indicated by an arrow next to the relationship.

• A. True

• B. False