Database Questions and Answers – Atomic Domains

This set of Database Multiple Choice Questions & Answers (MCQs) focuses on “Atomic Domains”.

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

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

2. Identify the composite attributes
a) Salary
b) Credits
c) Section_id
d) None of the mentioned
View Answer

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

3. Consider the relation given below and ind the maximum normal form applicable to them

advertisement
advertisement
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
View Answer

Answer: d
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. Which one is based on multi-valued dependency:
a) First
b) Second
c) Third
d) Fourth
View Answer

Answer: d
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. 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
View Answer

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

6. 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
View Answer

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

7. 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
View Answer

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

8. 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
d) Metadata
View Answer

Answer: d
Explanation: Meta data is generally data about a data.

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

Answer: a
Explanation: This can be taken as a primary key.

10. 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
View Answer

Answer: a
Explanation: Given a set F of functional dependencies on a schema, we can prove that certain other functional dependencies also hold on the schema.

Sanfoundry Global Education & Learning Series – Database Management System.

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.