Normalization Questions

MCQ bookmark_border

1.

A domain is ______ if elements of the domain are considered to be indivisible units.

A

Atomic

B

Subatomic

C

Substructure

D

Subset

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

2.

Identify the composite attributes

A

Salary

B

Credits

C

Section_id

D

None of the mentioned

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

3.

a)

A

First

B

Second

C

Third

D

Fourth

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

4.

If a relation is in BCNF, then it is also in

A

1 NF

B

2 NF

C

3 NF

D

All of the mentioned

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

5.

key attribute is functionally dependent primary key, then the relation will be in

A

First normal form

B

Second normal form

C

Third form

D

Fourth normal form

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

6.

If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.

A

DKNF

B

BCNF

C

Fourth

D

Third

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

7.

a)

A

Data dictionary

B

data repository

C

Index data

D

Metadata

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

8.

a)

A

Autonumber

B

Boolean

C

Sequential key

D

Sequential number

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

9.

A dependency exist between two columns when

A

Together they constitute a composite key for the table

B

Knowing the value in one column determines the value stored in another column

C

The table is in 3NF

D

Together they constitute a foreign key

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

10.

In the __________ normal form, a composite attribute is converted to individual attributes.

A

First

B

Second

C

Third

D

Fourth

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion