Module 3: Database Modeling Building Blocks.

 

Database Modeling Building Blocks.

1. Which of the following place restriction on values of database? (Any two)

A. trigger

B. constraints

C. black box

D. data type

Answer: B,D

2. Which of the following is not a method of preventing data from integrity loss?

A. Entity relationship diagram

B. Computer security

C. Database back up 

D. Properly designed interface

Answer: A

3. The idea of a relational database system and normalization is that data in a specific table is not directly associated with all other items in that same table.

A. True

B. False

Answer: B

4. Which of the following applies structure and definition to a chunk of data within each repeated record?

A. Table

B. Item

C. Row

D. Field

Answer: D

5. Which of the following statements are true?

A. Complex data types encompass object data types

B. Video is an example of collection of array

C. A pointer provides the advantage of not having to specify too much in advance with respect to how much bytes the pointer value occupies.

D. User defined data type cannot be created by programmer.

Answer: A, C