Database Management System DBMS Certification exam answers 2026: This page lists all 100 questions of the official Database Management System DBMS Certification exam by Itronix Solutions, each with its four answer options and the correct answer highlighted in green. Use it to revise every topic before you attempt the test and earn your verifiable certificate.
About this certification: A database management system (DBMS) is software to create and manage databases, allowing users to create, read, update and delete data in a database.
| Certification | Database Management System DBMS Certification |
| Provider | Itronix Solutions |
| Category | Programming & Development |
| Total questions | 100 multiple-choice questions |
| Marks | 1 mark per question (100 marks) |
| Passing score | 80% (80 out of 100) |
| Retake | Available if you do not pass |
| Certificate | Verifiable online certificate |
Take the exam: Database Management System DBMS Certification on Itronix Solutions. See every other Itronix exam in our complete list of Itronix certification answers.
Database Management System DBMS Exam Questions and Answers
Questions 1 to 25
1. The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.
Correct answer: A. Referential
2. _____________ is a hardware component that is most important for the operation of a database management system.
Correct answer: B. High speed, large capacity disk to store data
3. The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.
Correct answer: C. Database application and the database
4. The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________
Correct answer: D. DML (Data Manipulation Langauge)
5. Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?
Correct answer: A. DDL(Data Definition Language)
6. Which one of the following refers to the "data about data"?
Correct answer: B. Meta Data
7. Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?
Correct answer: C. Physical Level
8. In general, a file is basically a collection of all related______.
Correct answer: D. Records
9. During transaction before commit which of the following statement is done automatically in case of shutdown?
Correct answer: A. Rollback
10. Which of the following SQL command is used for removing (or deleting) a relation form the database?
Correct answer: B. Drop
11. Rectangles in ER diagram represents?
Correct answer: C. Entity sets
12. Select the correct definition of relation.
Correct answer: D. Subset of a cartesian product of list of domains
13. In SQL, which command is used to add new rows to a table?
Correct answer: A. INSERT
14. A _______ means that one record in a particular record type can be related to many records in another record type and vice-versa.
Correct answer: B. Many-to-many relationship
15. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
Correct answer: C. Multimedia
16. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
Correct answer: D. COMMIT
17. The statement in SQL which allows changing the definition of a table is
Correct answer: A. Alter.
18. E-R model uses this symbol to represent a weak entity set?
Correct answer: B. Doubly outlined rectangle
19. SET concept is used in:
Correct answer: C. Network Model
20. _______ produces the relation that has attributes of R1 and R2
Correct answer: D. Cartesian product
21. A DBMS is:
Correct answer: B. Software for creating, managing and querying databases
22. An RDBMS stores data in:
Correct answer: B. Tables with rows and columns related by keys
23. Examples of RDBMS include:
Correct answer: A. MySQL, PostgreSQL, Oracle and SQL Server
24. A table row is also called a:
Correct answer: A. Record or tuple
25. A table column is also called a:
Correct answer: D. Field or attribute
Questions 26 to 50
26. A primary key:
Correct answer: C. Uniquely identifies each row and cannot be NULL
27. A foreign key:
Correct answer: B. References the primary key of another table to enforce relationships
28. A candidate key is:
Correct answer: B. Any minimal set of columns that can uniquely identify rows
29. A composite key consists of:
Correct answer: D. Two or more columns together
30. Referential integrity ensures:
Correct answer: B. Foreign key values match existing primary key values
31. An ER diagram shows:
Correct answer: C. Entities, attributes and relationships
32. A one-to-many relationship means:
Correct answer: C. One record relates to many records in another table
33. A many-to-many relationship is implemented using:
Correct answer: B. A junction (associative) table
34. Normalisation aims to:
Correct answer: A. Reduce redundancy and improve data integrity
35. First Normal Form (1NF) requires:
Correct answer: B. Atomic values and no repeating groups
36. Second Normal Form (2NF) removes:
Correct answer: C. Partial dependencies on part of a composite key
37. Third Normal Form (3NF) removes:
Correct answer: B. Transitive dependencies on non-key attributes
38. Denormalisation is sometimes used to:
Correct answer: D. Improve read performance at the cost of redundancy
39. SQL is divided into sublanguages including:
Correct answer: A. DDL, DML, DCL and TCL
40. DDL commands include:
Correct answer: A. CREATE, ALTER and DROP
41. DML commands include:
Correct answer: B. SELECT, INSERT, UPDATE and DELETE
42. DCL commands include:
Correct answer: D. GRANT and REVOKE
43. TCL commands include:
Correct answer: A. COMMIT, ROLLBACK and SAVEPOINT
44. TRUNCATE differs from DELETE because it:
Correct answer: A. Removes all rows quickly without row-by-row logging (typically)
45. DROP TABLE:
Correct answer: A. Removes the table structure and its data
46. ALTER TABLE is used to:
Correct answer: A. Modify a table’s structure
47. The WHERE clause:
Correct answer: B. Filters rows
48. ORDER BY … DESC sorts:
Correct answer: A. In descending order
49. GROUP BY is used with:
Correct answer: A. Aggregate functions like SUM and COUNT
50. HAVING filters:
Correct answer: B. Groups after aggregation
Questions 51 to 75
51. An INNER JOIN returns:
Correct answer: B. Only rows with matching values in both tables
52. A LEFT OUTER JOIN returns:
Correct answer: D. All rows from the left table and matches from the right
53. A FULL OUTER JOIN returns:
Correct answer: B. All rows from both tables with matches where available
54. A CROSS JOIN returns:
Correct answer: C. The Cartesian product of two tables
55. A self join is:
Correct answer: C. A table joined with itself
56. UNION combines:
Correct answer: A. Results of two queries removing duplicates
57. UNION ALL differs from UNION by:
Correct answer: C. Keeping duplicate rows
58. A subquery is:
Correct answer: A. A query nested inside another query
59. A view is:
Correct answer: D. A virtual table based on a stored query
60. An index improves:
Correct answer: D. Query lookup speed at the cost of extra storage and write overhead
61. A clustered index determines:
Correct answer: D. The physical order of data in the table
62. A stored procedure is:
Correct answer: B. A saved set of SQL statements that can be executed
63. A trigger is:
Correct answer: B. SQL code that runs automatically in response to table events
64. A transaction is:
Correct answer: D. A unit of work that is executed completely or not at all
65. ACID properties are:
Correct answer: A. Atomicity, Consistency, Isolation and Durability
66. Atomicity means:
Correct answer: B. All operations in a transaction succeed or none do
67. Isolation means:
Correct answer: B. Concurrent transactions do not interfere with each other
68. Durability means:
Correct answer: A. Committed changes persist even after failures
69. A deadlock occurs when:
Correct answer: D. Two transactions wait for each other’s locks indefinitely
70. NULL in SQL represents:
Correct answer: B. A missing or unknown value
71. To check for NULL you use:
Correct answer: C. IS NULL
72. COUNT(column) counts:
Correct answer: B. Non-NULL values in that column
73. COALESCE returns:
Correct answer: B. The first non-NULL value in a list
74. CASE in SQL provides:
Correct answer: C. Conditional logic within queries
75. LIKE ‘A%’ matches values that:
Correct answer: A. Start with A
Questions 76 to 100
76. BETWEEN is used to:
Correct answer: B. Filter values within a range
77. DISTINCT returns:
Correct answer: D. Unique values
78. Window functions such as ROW_NUMBER():
Correct answer: B. Compute values across related rows without collapsing them
79. A CTE is defined using:
Correct answer: D. WITH
80. Constraints such as UNIQUE and CHECK:
Correct answer: B. Enforce rules on data
81. DEFAULT constraint:
Correct answer: D. Provides a value when none is specified
82. AUTO_INCREMENT or IDENTITY:
Correct answer: D. Generates sequential numeric values automatically
83. Database backups are essential for:
Correct answer: B. Recovery from data loss
84. Data redundancy means:
Correct answer: B. Unnecessary duplication of data
85. A schema in databases is:
Correct answer: A. The structure or blueprint of the database
86. Data independence means:
Correct answer: D. Changes in one level of schema do not affect others
87. SQL injection is prevented by:
Correct answer: A. Using parameterised queries
88. Role-based permissions in databases are managed with:
Correct answer: B. GRANT and REVOKE
89. NoSQL databases differ from RDBMS by:
Correct answer: C. Using flexible models like documents or key-value
90. Microsoft SQL Server uses the SQL dialect:
Correct answer: B. T-SQL (Transact-SQL)
91. TOP in SQL Server is used to:
Correct answer: A. Limit the number of rows returned
92. SQL Server Management Studio (SSMS) is:
Correct answer: D. A tool to manage SQL Server databases
93. Oracle’s procedural SQL extension is:
Correct answer: A. PL/SQL
94. The main purpose of a DBMS is to:
Correct answer: A. Store, organise and retrieve data efficiently and securely
95. MIN() returns:
Correct answer: D. The smallest value in a column
96. MAX() returns:
Correct answer: C. The largest value in a column
97. SUM() returns:
Correct answer: D. The total of numeric values
98. AVG() returns:
Correct answer: D. The average of numeric values
99. INSERT INTO is used to:
Correct answer: D. Add new rows to a table
100. UPDATE … SET is used to:
Correct answer: A. Modify existing rows
How to Pass the Database Management System DBMS Exam
- Read every question carefully; most options look similar, so look for the most precise answer.
- Revise the questions above topic by topic rather than memorising letters, because option order can change in the live test.
- You need 80 correct answers out of 100 to pass, so aim to understand at least 85 to stay safe.
- If you do not clear it on the first attempt, review the questions you missed and use the retake option.
Frequently Asked Questions
How many questions are in the Database Management System DBMS Certification exam?
The exam has 100 multiple-choice questions, each worth 1 mark.
What is the passing score for the Database Management System DBMS Certification?
You need at least 80% (80 out of 100) to pass and receive the certificate.
Can I retake the Database Management System DBMS Certification exam?
Yes. If you score below 80%, you can retry the test after reviewing the topics.
Is the Itronix certificate verifiable?
Yes. Every certificate issued by Itronix Solutions has a unique ID that can be checked on the Itronix verify-certificate page.
More Programming & Development Certification Answers
- Advanced Java Certification Exam Answers
- Android Development Certification Exam Answers
- Automation Testing Certification Exam Answers
- Blockchain Certification Exam Answers
- C & C++ Programming Language Certification Exam Answers
- Certified Quality Engineer Professional Certification Exam Answers
- Core Java Programming Professional Certification Exam Answers
- Data Structures and Algorithm Certification Exam Answers
Disclaimer: These answers are provided for learning and revision. Questions and answers are checked regularly; if you find a mistake, let us know in the comments.
Priya Dogra – Free Certifications, Exam Answers & Career Guides Free certification exam answers, courses, scholarships and career guides for learners worldwide