Home > Databases > Quizzes > Database Management System (DBMS) Practice Test: Relational Model
Database Management System (DBMS) Practice Test: Relational Model
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 4% • Most missed: “Database __________ which is the logical design of the database, and the databas…”
Database Management System (DBMS) Practice Test: Relational Model
Time left 00:00
25 Questions

1. The tuples of the relations can be of ________ order.
2. Choose the correct statement regarding superkeys
3. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.
4. The term _______ is used to refer to a row.
5. Which of the following data types does the SQL standard not support?
6. Choose the option that correctly explains in words, the function of the following relational algebra expression σyear≥2009 (book ⋈ borrow)
7. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
8. Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
9. Which of the following information does an SQL DDL not specify?
10. What does the “x” operator do in relational algebra?
11. For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigmA:)
12. What is the method of specifying a primary key in a schema description?
13. If a1, a2, a3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?
14. The term attribute refers to a ___________ of a table.
15. Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
16. What does the notnull integrity constraint do?
17. State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
18. A ________ in a table represents a relationship among a set of values.
19. Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
20. Which of the following commands do we use to delete all the tuples from a relation (R)?
21. A relational database consists of a collection of
22. Which of the following commands do we use to delete a relation (R) from a database?
23. What is the syntax to load data into the database? (Consider D as the database and a, b, c as datA:)
24. What action does ⋈ operator perform in relational algebra
25. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

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