Home > Databases > Quizzes > DBMS Basics Practice Test: Normalization
DBMS Basics Practice Test: Normalization
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 37% • Most missed: “Which forms has a relation that possesses data about an individual entity?”
Quiz questions on different normal forms, multivalued dependencies and decomposition algorithms, user interfaces and different application programs. Database normalization is a technique that organizes data in a relational database into tables, removing duplicate data, and improving data integrity. It also helps to prevent anomalies like deletion, update, and insertion.  Normalization is a multi-step process that involves: Dividing large tables into smaller tables and Linking the tables using relationships.  The four major types of normal forms are: 1NF, 2NF, 3NF, and BCNF.  Most database... Show more
DBMS Basics Practice Test: Normalization
Time left 00:00
25 Questions

1. Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into
instructor (ID, name, dept name, salary)department (dept name, building, budget)This comes under
2. Which one is based on multi-valued dependency:
3. Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
4. In the __________ normal form, a composite attribute is converted to individual attributes.
5. Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:
6. Which-one ofthe following statements about normal forms is FALSE?
7. The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into
employee1 (ID, name)employee2 (name, street, city, salary)This type of decomposition is called
8. Suppose relation R(A,B) currently has tuples {(1,2), (1,3), (3,4)} and relation S(B,C) currently has {(2,5), (4,6), (7,8)}. Then the number of tuples in the result of the SQL query:
SELECT * FROM R NATURAL OUTER JOIN S; IS:
9. If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
10. Identify the composite attributes
11. A graphical or text depiction of the relationship between different groups of content on a website is a:
12. R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
13. The normal form which satisfies multivalued dependencies and which is in BCNF is
14. A method of modelling and describing user tasks for an interactive application is referred to as:
15. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
16. Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
17. If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.
18. Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by
19. If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
20. In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
21. Which of the normal form is based on multivalued dependencies?
22. In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?
23. A graphical or text depiction of the relationship between different groups of content on a website is referred to as a:
24. Which of the following is not Armstrong’s Axiom?
25. We can use the following three rules to find logically implied functional dependencies. This collection of rules is called

⚡ Recently practiced quizzes in this topic
Live quiz activity
DBMS Basics Practice Test: SQL - Queries, Constraints and Triggers Database Fundamentals Transact-SQL (T-SQL) Practice Test PostgreSQL Fundamentals Test SQL Server Vocab Redis Practice Test (NoSQL) DBMS Basics Practice Test: Indexing and Hashing Database Management System (DBMS) Practice Test: All Topics SQL Fundamentals Test SQL MCQs
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.