Home > Databases > Quizzes > RDBMS Basics Practice Test: Relational Model and SQL
RDBMS Basics Practice Test: Relational Model and SQL
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 24% • Most missed: “What is the result of the following query?”
Quiz questions on relational model basics, SQL data definition, basic and set operations, aggregrate functions, nested subqueries and database modifications. The relational model describes how modeled items (entities) can have different attributes and are related to other entities through relationships. These relationships can be one-to-one, many-to-many, one-to-many, or complex, multientity relationships. A relational database is based on a relational model of data, and all relational databases use SQL for maintaining and querying the database. The model organizes data into one or more... Show more
RDBMS Basics Practice Test: Relational Model and SQL
Time left 00:00
25 Questions

1. The _____ aggregation operation adds up all the values of the attribute
2. 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?
3. What does the notnull integrity constraint do?
4. What is the result of the following query?
SELECT studname
WHERE marks > SOME
(SELECT marks
WHERE SECTION = 'c'
);
5. The ________ comparison checker is used to check “each and every” condition
6. The where clause is a predicate involving attributes of the relation in the ______ clause.
7. Which keyword is used to rename a relation in a query?
8. To change a value in a tuple without changing all the values in the tuple, we use the _____ statement
9. Using the _______ clause retains only one copy of identical tuples
10. What does the following query do?
select name, ID, branch
from student, department
where student.branch = department.branch;
11. What is the function of the intersect operation?
12. Which of the following cannot be used to modify the data in a database
13. Choose the correct statement regarding superkeys
14. What values does the count(*) function ignore?
15. The ________ clause is used to list the attributes desired in the result of a query
16. Choose the correct option regarding the following query
INSERT INTO course
('CS-67' , 'course name', 'any' , 5
);
17. Which of the following information does an SQL DDL not specify?
18. What action does ⋈ operator perform in relational algebra
19. Which of the following commands do we use to delete all the tuples from a relation (R)?
20. State true or false: Any attribute which is present in the having clause without being aggregated must not be present in the group by clause.
21. How many relations can a delete command operate on?
22. What is a foreign key?
23. Which of the following logical connectives is not included in SQL?
24. Choose the option that correctly explains in words, the function of the following relational algebra expression
σyear≥2009 (book ⋈ borrow)
25. Choose the correct command to delete an attribute A from a relation R

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