Home > Databases > Quizzes > Database Management System (DBMS) Practice Test: Basics of DBMS
Database Management System (DBMS) Practice Test: Basics of DBMS
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 50% • Most missed: “Designers use which of the following to tune the performance of systems to suppo…”
Database Management System (DBMS) Practice Test: Basics of DBMS
Time left 00:00
25 Questions

1. An ________ is a set of entities of the same type that share the same properties, or attributes.
2. Object based logical model(s) are used to describe data at - [Select Appropriate Option(s)]
3. The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
4. Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality
5. Database is generally __________
6. In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
7. Which of the following is example of Object based logical model ?
8. For a weak entity set to be meaningful, it must be associated with another entity set, called the
9. The descriptive property possessed by each entity set is _________
10. If in redundant file common fields are not matching then it results in _____________.
11. A collection of related data.
12. Which of the following is a Data Model?
13. A characteristic of an entity.
14. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
15. Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
16. Entity Relationship model consists of collection of basic objects called _________ and relationship among these objects.
17. In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.
18. Data Models in DBMS are classified into ______ categories.
19. In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Which dependency have lead to this relation ?
20. Duplication of data at several places is called as _______________.
21. Entity is a _________
22. DBMS manages the interaction between __________ and database.
23. _____________ can help us detect poor E-R design.
24. An entity set that does not have sufficient attributes to form a primary key is termed a __________
25. IMS stands for?

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