Home > Databases > Quizzes > RDBMS Basics Practice Test
RDBMS Basics Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 28% • Most missed: “Which of the following commands do we use to delete a relation (RDBMS) from a da…”
Relational Database Management Systems (RDBMS) are a specialized type of DBMS that uses the relational model of organizing data.  The key components of an RDBMS are: Tables: Store data Rows and columns: Store data Primary keys: Uniquely identify rows Foreign keys: Establish relationships between tables Indexes: Optimize data retrieval Constraints: Enforce data integrity  RDBMS also uses transactions and locking mechanisms to maintain data consistency and prevent multiple users from modifying data simultaneously.  Here are some basic features of RDBMS: Data integrity: Protects data... Show more
RDBMS Basics Practice Test
Time left 00:00
25 Questions

1. What is the result of the following query?
SELECT studentdatabasename
WHERE marks > SOME
(SELECT marks
WHERE SECTION = 'c'
);
2. Which of the following is the correct option for the given query?
SELECT DISTINCT name
WHERE ID IS NOT NULL;
3. Choose the correct option regarding the query
SELECT branch_name, COUNT
(DISTINCT customer_name
)
HAVING avg
(balance
) = 10000;
4. What is a relation in RDBMS?
5. Which of the following is the full form of RDBMS?
6. If the database modifications occur while the transaction is still active, the transaction is said to use the __________ modification technique
7. Which of the following is a good database management practice?
8. What is an Instance of a Database?
9. The schema for the relationship set linking a weak entity set to its corresponding strong entity set is redundant.
10. ________ is a predicate that we expect the database to always satisfy
11. If a transaction does not modify the database until it has committed it is said to use a _______ modification technique
12. Observe the given SQL query and choose the correct option.
SELECT database_name, RDBMS
(DISTINCT bankuser_name
)
GROUP BY branch_id
13. for each tuple tr in r do begin
FOR each tuple ts IN s do BEGIN
test pair
(tr , ts
) TO see IF they satisfy the JOIN condition _
END
What type of join is this?
14. Which of the following is the time of temporal data that record when a fact was recorded in a database?
15. Which of the following constraints RDBS doesn’t check before creating the tables?
16. If RDBMS1, RDBMS2, RDBMS3 are attributes in a relation and S is another relation, which of the following is an incorrect specification of an integrity constraint?
17. What is an RDBMS?
18. What is the format of entering date into a database while inserting data into it?
19. What does the following query do?
UPDATE student
SET marks = marks*1.10;
20. Which of the following systems use RDMS?
21. The dependency rules specified by the database designer are known as _______
22. Which of the following cannot be used to modify the data in a database?
23. ________ deletes a data item from a database.
24. Dynamic hashing allows us to?
25. Does RDBMS have ACID properties?

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