Home > Databases > Quizzes > Database Management System (DBMS) Practice Test: Relational Database Design
Database Management System (DBMS) Practice Test: Relational Database Design
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 20% • Most missed: “What action does ⋈ operator perform in relational algebra”
Database Management System (DBMS) Practice Test: Relational Database Design
Time left 00:00
25 Questions

1. There are two functional dependencies with the same set of attributes on the left side of the arrow:
A->BC A->B
This can be combined as
2. What action does ⋈ operator perform in relational algebra
3. The main task carried out in the __________ is to remove repeating attributes to separate tables.
4. Which-one ofthe following statements about normal forms is FALSE?
5. Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible
6. Which forms are based on the concept of functional dependency:
7. Which, if any, of the two queries above will correctly (in SQL2) get the desired set of employee ID’s?
8. Which of the following is a tuple-generating dependencies?
9. The normal form which satisfies multivalued dependencies and which is in BCNF is
10. Fifth Normal form is concerned with
11. Which forms has a relation that possesses data about an individual entity:
12. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
13. In 2NF
14. Which of the following is not a key?
15. The____condition allows a general predicate over the relations being joined.
16. Which forms has a relation that possesses data about an individual entity?
17. Tables in second normal form (2NF):
18. We can use the following three rules to find logically implied functional dependencies. This collection of rules is called
19. Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
20. Which of the following is not Armstrong’s Axiom?
21. 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
22. Which is a bottom-up approach to database design that design by examining the relationship between attributes:
23. 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
24. Empdt1(empcode, name, street, city, state, pincode). For any pincode, there is only one city and state. Also, for given street, city and state, there is just one pincode. In normalization terms, empdt1 is a relation in
25. n which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

⚡ 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.