Engineering Questions with Answers - Multiple Choice Questions

# Database MCQ – Atomic Domains

1 - Question

A domain is ______ if elements of the domain are considered to be indivisible units.
a) Atomic
b) Subatomic
c) Substructure
d) Subset

Explanation: A set of names is an example of a nonatomic value.

2 - Question

Identify the composite attributes
a) Salary
b) Credits
c) Section_id
d) None of the mentioned

Explanation: Composite attributes, such as an attribute address with component attributes street, city, state, and zip have nonatomic domains.

3 - Question

Consider the relation given below and ind the maximum normal form applicable to them
i. R(A, B) WITH productions { A --> B }
ii. R(A, B) WITH productions { B --> A }
iii. R(A, B) WITH productions {A —> B, B --> A }
iv. R(A, B, C) WITH productions {A -->B, B --> A, AB --> C }
a) i, ii and iii are in 3NF and iv is in BCNF
b) i and ii are in BCNF and iii and iv are in 3NF
c) All are in 3NF
d) All are in BCNF

Explanation: One of the more desirable normal forms that we can obtain is Boyce–Codd normal form (BCNF). It eliminates all redundancy that can be discovered based on functional dependencies.

4 - Question

Which one is based on multi-valued dependency:
a) First
b) Second
c) Third
d) Fourth

Explanation: One of the more desirable normal forms that we can obtain is Boyce–Codd normal form (BCNF). It eliminates all redundancy that can be discovered based on functional dependencies.

5 - Question

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

Explanation: Third normal form (3NF) relaxes this constraint slightly by allowing certain nontrivial functionaldependencieswhose left side is not a superkey.

6 - Question

If every non-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

Explanation: Third normal form (3NF) relaxes this constraint slightly by allowing certain nontrivial functionaldependencieswhose left side is not a superkey.

7 - Question

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

Explanation: BCNF eliminates all redundancy that can be discovered based on functional dependencies.

8 - Question

The term for information that describes what type of data is available in a database is:
a) Data dictionary
b) data repository
c) Index data

Explanation: Meta data is generally data about a data.

9 - Question

A data type that creates unique numbers for key columns in Microsoft Access is:
a) Autonumber
b) Boolean
c) Sequential key
d) Sequential number

Explanation: This can be taken as a primary key.

10 - Question

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