Home > Consumer Behavior 101 > 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. Which of the following information does an SQL DDL not specify?
2. What does the notnull integrity constraint do?
3. Choose the correct command to delete an attribute A from a relation R
4. What does the “x” operator do in relational algebra?
5. Which of the following commands do we use to delete a relation (R) from a database?
6. Choose the correct statement regarding superkeys
7. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
8. A relational database consists of a collection of
9. What is an Instance of a Database?
10. In precedence of set operators, the expression is evaluated from
11. What is a foreign key?
12. State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
13. A ________ in a table represents a relationship among a set of values.
14. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________
15. The tuples of the relations can be of ________ order.
16. Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
17. Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?
18. A domain is atomic if elements of the domain are considered to be ____________ units.
19. Choose the option that correctly explains in words, the function of the following relational algebra expression σyear≥2009 (book ⋈ borrow)
20. 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?
21. For select operation the ________ appear in the subscript and the ___________ argument appears in the paranthesis after the sigmA:)
22. 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.
23. Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
24. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
25. What is the syntax to load data into the database? (Consider D as the database and a, b, c as datA:)

⚡ Recently practiced quizzes in this topic
Live quiz activity
Consumer Behavior 101 Practice Test: The Influence of Culture on Consumer Behavior Consumer Behavior 101 Practice Test: Personality and Consumer Behavior Consumer Behavior 101 Practice Test: Basics of Consumer Behavior Consumer Behavior 101 Practice Test: The Family and Its Social Class Standing Consumer Behavior 101 Practice Test: Consumer Motivation Consumer Behavior 101 Practice Test: Consumer Perception Consumer Behavior 101 Practice Test: Communication and Consumer Behavior Consumer Behavior 101 Practice Test: Consumer Attitude Formation and Change Consumer Behavior 101 Practice Test: Basics of Consumer Research Process Consumer Behavior 101 Practice Test: Consumers and the Diffusion of Innovations
 
❤ 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 | 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.