Wednesday , November 18 2026
Breaking News

Database Management System DBMS Certification Exam Answers 2026 (All 100 Questions)

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.

A. Referential ✔
B. Primary
C. Referencing
D. Specific

Correct answer: A. Referential

2. _____________ is a hardware component that is most important for the operation of a database management system.

A. Microphone
B. High speed, large capacity disk to store data ✔
C. High-resolution video display
D. Printer

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.

A. Data and the DBMS
B. Application and SQL
C. Database application and the database ✔
D. The user and the software

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 ____________

A. DDL (Data Definition Langauge)
B. TCL (Transaction Control Language)
C. DCL (Data Control Language)
D. DML (Data Manipulation Langauge) ✔

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?

A. DDL(Data Definition Language) ✔
B. Relational Schema
C. Query
D. DML(Data Manipulation Language)

Correct answer: A. DDL(Data Definition Language)

6. Which one of the following refers to the "data about data"?

A. Directory
B. Meta Data ✔
C. Warehouse
D. Sub 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?

A. Logical Level
B. Conceptual Level
C. Physical Level ✔
D. File Level

Correct answer: C. Physical Level

8. In general, a file is basically a collection of all related______.

A. Database
B. Rows & Columns
C. Fields
D. Records ✔

Correct answer: D. Records

9. During transaction before commit which of the following statement is done automatically in case of shutdown?

A. Rollback ✔
B. Commit
C. View
D. Flashback

Correct answer: A. Rollback

10. Which of the following SQL command is used for removing (or deleting) a relation form the database?

A. Remove
B. Drop ✔
C. Delete
D. Rollback

Correct answer: B. Drop

11. Rectangles in ER diagram represents?

A. Attributes
B. Tables
C. Entity sets ✔
D. Tuples

Correct answer: C. Entity sets

12. Select the correct definition of relation.

A. Subset of a cartesian product of list of tuple
B. Subset of a cartesian product of list of attributes
C. Subset of a cartesian product of list of relations
D. Subset of a cartesian product of list of domains ✔

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?

A. INSERT ✔
B. APPEND
C. ALTER TABLE
D. ADD ROW

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.

A. Many-to-one relationship
B. Many-to-many relationship ✔
C. One-to-one relationship
D. One-to-many relationship

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?

A. Full media
B. Graphics media
C. Multimedia ✔
D. Hypertext

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?

A. SAVE
B. PACK
C. ZIP
D. COMMIT ✔

Correct answer: D. COMMIT

17. The statement in SQL which allows changing the definition of a table is

A. Alter. ✔
B. Update.
C. Create.
D. select.

Correct answer: A. Alter.

18. E-R model uses this symbol to represent a weak entity set?

A. Diamond
B. Doubly outlined rectangle ✔
C. Dotted rectangle.
D. None of these

Correct answer: B. Doubly outlined rectangle

19. SET concept is used in:

A. Relational Model
B. E-R Model
C. Network Model ✔
D. Hierarchical Model

Correct answer: C. Network Model

20. _______ produces the relation that has attributes of R1 and R2

A. Difference
B. Intersection
C. Product
D. Cartesian product ✔

Correct answer: D. Cartesian product

21. A DBMS is:

A. An operating system
B. Software for creating, managing and querying databases ✔
C. A programming language
D. A spreadsheet only

Correct answer: B. Software for creating, managing and querying databases

22. An RDBMS stores data in:

A. Only files
B. Tables with rows and columns related by keys ✔
C. Only documents
D. Only graphs

Correct answer: B. Tables with rows and columns related by keys

23. Examples of RDBMS include:

A. MySQL, PostgreSQL, Oracle and SQL Server ✔
B. MongoDB and Redis only
C. Excel and Word
D. Photoshop and Figma

Correct answer: A. MySQL, PostgreSQL, Oracle and SQL Server

24. A table row is also called a:

A. Record or tuple ✔
B. Field
C. Index
D. Schema

Correct answer: A. Record or tuple

25. A table column is also called a:

A. Tuple
B. View
C. Record
D. Field or attribute ✔

Correct answer: D. Field or attribute

Questions 26 to 50

26. A primary key:

A. Is optional for all tables
B. Is always text
C. Uniquely identifies each row and cannot be NULL ✔
D. Can contain duplicates

Correct answer: C. Uniquely identifies each row and cannot be NULL

27. A foreign key:

A. Is always unique
B. References the primary key of another table to enforce relationships ✔
C. Is a password
D. Cannot be null

Correct answer: B. References the primary key of another table to enforce relationships

28. A candidate key is:

A. Only the primary key
B. Any minimal set of columns that can uniquely identify rows ✔
C. A foreign key
D. An index

Correct answer: B. Any minimal set of columns that can uniquely identify rows

29. A composite key consists of:

A. Only text columns
B. One column only
C. No columns
D. Two or more columns together ✔

Correct answer: D. Two or more columns together

30. Referential integrity ensures:

A. Data is encrypted
B. Foreign key values match existing primary key values ✔
C. Indexes exist
D. Tables are sorted

Correct answer: B. Foreign key values match existing primary key values

31. An ER diagram shows:

A. Network routes
B. File sizes
C. Entities, attributes and relationships ✔
D. CPU usage

Correct answer: C. Entities, attributes and relationships

32. A one-to-many relationship means:

A. No relationships
B. One-to-one only
C. One record relates to many records in another table ✔
D. Every record relates to every record

Correct answer: C. One record relates to many records in another table

33. A many-to-many relationship is implemented using:

A. A view only
B. A junction (associative) table ✔
C. A single column
D. An index only

Correct answer: B. A junction (associative) table

34. Normalisation aims to:

A. Reduce redundancy and improve data integrity ✔
B. Increase duplication
C. Speed up all reads always
D. Remove keys

Correct answer: A. Reduce redundancy and improve data integrity

35. First Normal Form (1NF) requires:

A. Only one table
B. Atomic values and no repeating groups ✔
C. Transitive dependencies
D. No primary key

Correct answer: B. Atomic values and no repeating groups

36. Second Normal Form (2NF) removes:

A. Atomic values
B. Indexes
C. Partial dependencies on part of a composite key ✔
D. All keys

Correct answer: C. Partial dependencies on part of a composite key

37. Third Normal Form (3NF) removes:

A. Primary keys
B. Transitive dependencies on non-key attributes ✔
C. Tables
D. Atomic values

Correct answer: B. Transitive dependencies on non-key attributes

38. Denormalisation is sometimes used to:

A. Add constraints
B. Enforce 3NF
C. Remove all data
D. Improve read performance at the cost of redundancy ✔

Correct answer: D. Improve read performance at the cost of redundancy

39. SQL is divided into sublanguages including:

A. DDL, DML, DCL and TCL ✔
B. JSON and XML
C. HTML and CSS
D. C and C++

Correct answer: A. DDL, DML, DCL and TCL

40. DDL commands include:

A. CREATE, ALTER and DROP ✔
B. COMMIT and ROLLBACK
C. SELECT and INSERT
D. GRANT and REVOKE

Correct answer: A. CREATE, ALTER and DROP

41. DML commands include:

A. COMMIT only
B. SELECT, INSERT, UPDATE and DELETE ✔
C. GRANT only
D. CREATE and DROP

Correct answer: B. SELECT, INSERT, UPDATE and DELETE

42. DCL commands include:

A. CREATE and ALTER
B. SELECT only
C. INSERT and UPDATE
D. GRANT and REVOKE ✔

Correct answer: D. GRANT and REVOKE

43. TCL commands include:

A. COMMIT, ROLLBACK and SAVEPOINT ✔
B. GRANT and REVOKE
C. SELECT and JOIN
D. CREATE and DROP

Correct answer: A. COMMIT, ROLLBACK and SAVEPOINT

44. TRUNCATE differs from DELETE because it:

A. Removes all rows quickly without row-by-row logging (typically) ✔
B. Removes the table structure
C. Only removes one row
D. Requires a WHERE clause

Correct answer: A. Removes all rows quickly without row-by-row logging (typically)

45. DROP TABLE:

A. Removes the table structure and its data ✔
B. Removes only data
C. Renames the table
D. Adds a column

Correct answer: A. Removes the table structure and its data

46. ALTER TABLE is used to:

A. Modify a table’s structure ✔
B. Query data
C. Grant permissions
D. Insert rows

Correct answer: A. Modify a table’s structure

47. The WHERE clause:

A. Groups rows
B. Filters rows ✔
C. Joins tables
D. Sorts results

Correct answer: B. Filters rows

48. ORDER BY … DESC sorts:

A. In descending order ✔
B. In ascending order
C. Randomly
D. By primary key only

Correct answer: A. In descending order

49. GROUP BY is used with:

A. Aggregate functions like SUM and COUNT ✔
B. Only DELETE
C. Only indexes
D. Only CREATE

Correct answer: A. Aggregate functions like SUM and COUNT

50. HAVING filters:

A. Rows before grouping
B. Groups after aggregation ✔
C. Columns
D. Tables

Correct answer: B. Groups after aggregation

Questions 51 to 75

51. An INNER JOIN returns:

A. All rows from both tables
B. Only rows with matching values in both tables ✔
C. No rows
D. Only unmatched rows

Correct answer: B. Only rows with matching values in both tables

52. A LEFT OUTER JOIN returns:

A. Only right rows
B. Only matching rows
C. Nothing
D. All rows from the left table and matches from the right ✔

Correct answer: D. All rows from the left table and matches from the right

53. A FULL OUTER JOIN returns:

A. Only left rows
B. All rows from both tables with matches where available ✔
C. Only right rows
D. Only matches

Correct answer: B. All rows from both tables with matches where available

54. A CROSS JOIN returns:

A. Only matches
B. One row
C. The Cartesian product of two tables ✔
D. Only unmatched rows

Correct answer: C. The Cartesian product of two tables

55. A self join is:

A. An index
B. A view
C. A table joined with itself ✔
D. A join of three tables

Correct answer: C. A table joined with itself

56. UNION combines:

A. Results of two queries removing duplicates ✔
B. Indexes
C. Columns only
D. Two tables side by side

Correct answer: A. Results of two queries removing duplicates

57. UNION ALL differs from UNION by:

A. Joining tables
B. Removing duplicates
C. Keeping duplicate rows ✔
D. Sorting results

Correct answer: C. Keeping duplicate rows

58. A subquery is:

A. A query nested inside another query ✔
B. An index
C. A stored procedure
D. A trigger

Correct answer: A. A query nested inside another query

59. A view is:

A. An index
B. A physical copy of data always
C. A backup
D. A virtual table based on a stored query ✔

Correct answer: D. A virtual table based on a stored query

60. An index improves:

A. Data integrity only
B. Normalisation
C. Write speed always
D. Query lookup speed at the cost of extra storage and write overhead ✔

Correct answer: D. Query lookup speed at the cost of extra storage and write overhead

61. A clustered index determines:

A. Permissions
B. Backups
C. Only a separate lookup structure
D. The physical order of data in the table ✔

Correct answer: D. The physical order of data in the table

62. A stored procedure is:

A. A view only
B. A saved set of SQL statements that can be executed ✔
C. A table
D. A backup

Correct answer: B. A saved set of SQL statements that can be executed

63. A trigger is:

A. A user account
B. SQL code that runs automatically in response to table events ✔
C. An index
D. A manual script only

Correct answer: B. SQL code that runs automatically in response to table events

64. A transaction is:

A. A table
B. A single SELECT always
C. An index
D. A unit of work that is executed completely or not at all ✔

Correct answer: D. A unit of work that is executed completely or not at all

65. ACID properties are:

A. Atomicity, Consistency, Isolation and Durability ✔
B. Access, Commit, Index and Delete
C. Accuracy, Control, Integrity and Design
D. Availability, Cost, Insert and Drop

Correct answer: A. Atomicity, Consistency, Isolation and Durability

66. Atomicity means:

A. Data is small
B. All operations in a transaction succeed or none do ✔
C. Data is permanent always
D. Transactions run in parallel

Correct answer: B. All operations in a transaction succeed or none do

67. Isolation means:

A. Data is stored separately
B. Concurrent transactions do not interfere with each other ✔
C. Users are isolated
D. Tables are separate

Correct answer: B. Concurrent transactions do not interfere with each other

68. Durability means:

A. Committed changes persist even after failures ✔
B. Transactions are fast
C. Indexes are rebuilt
D. Data is temporary

Correct answer: A. Committed changes persist even after failures

69. A deadlock occurs when:

A. A query is slow
B. A user logs out
C. A table is dropped
D. Two transactions wait for each other’s locks indefinitely ✔

Correct answer: D. Two transactions wait for each other’s locks indefinitely

70. NULL in SQL represents:

A. False
B. A missing or unknown value ✔
C. Zero
D. An empty string always

Correct answer: B. A missing or unknown value

71. To check for NULL you use:

A. EQUALS NULL
B. == NULL
C. IS NULL ✔
D. = NULL

Correct answer: C. IS NULL

72. COUNT(column) counts:

A. All rows including NULLs
B. Non-NULL values in that column ✔
C. Only NULLs
D. Distinct values only

Correct answer: B. Non-NULL values in that column

73. COALESCE returns:

A. The last value
B. The first non-NULL value in a list ✔
C. The count
D. NULL always

Correct answer: B. The first non-NULL value in a list

74. CASE in SQL provides:

A. Table creation
B. Backups
C. Conditional logic within queries ✔
D. Indexing

Correct answer: C. Conditional logic within queries

75. LIKE ‘A%’ matches values that:

A. Start with A ✔
B. Equal A exactly
C. End with A
D. Contain only A

Correct answer: A. Start with A

Questions 76 to 100

76. BETWEEN is used to:

A. Join tables
B. Filter values within a range ✔
C. Sort data
D. Create indexes

Correct answer: B. Filter values within a range

77. DISTINCT returns:

A. The first row
B. Only NULLs
C. All duplicate values
D. Unique values ✔

Correct answer: D. Unique values

78. Window functions such as ROW_NUMBER():

A. Grant permissions
B. Compute values across related rows without collapsing them ✔
C. Create tables
D. Delete rows

Correct answer: B. Compute values across related rows without collapsing them

79. A CTE is defined using:

A. DEFINE
B. TEMP
C. VIEW only
D. WITH ✔

Correct answer: D. WITH

80. Constraints such as UNIQUE and CHECK:

A. Speed up queries only
B. Enforce rules on data ✔
C. Delete duplicates automatically
D. Create backups

Correct answer: B. Enforce rules on data

81. DEFAULT constraint:

A. Defines a key
B. Creates an index
C. Prevents NULL
D. Provides a value when none is specified ✔

Correct answer: D. Provides a value when none is specified

82. AUTO_INCREMENT or IDENTITY:

A. Creates backups
B. Encrypts data
C. Defines relationships
D. Generates sequential numeric values automatically ✔

Correct answer: D. Generates sequential numeric values automatically

83. Database backups are essential for:

A. Faster queries
B. Recovery from data loss ✔
C. Indexing
D. Normalisation

Correct answer: B. Recovery from data loss

84. Data redundancy means:

A. Data compression
B. Unnecessary duplication of data ✔
C. Data indexing
D. Data encryption

Correct answer: B. Unnecessary duplication of data

85. A schema in databases is:

A. The structure or blueprint of the database ✔
B. A single row
C. A backup file
D. A query result

Correct answer: A. The structure or blueprint of the database

86. Data independence means:

A. Data is stored once
B. Data has no relationships
C. Data is public
D. Changes in one level of schema do not affect others ✔

Correct answer: D. Changes in one level of schema do not affect others

87. SQL injection is prevented by:

A. Using parameterised queries ✔
B. Concatenating user input into SQL
C. Removing keys
D. Disabling indexes

Correct answer: A. Using parameterised queries

88. Role-based permissions in databases are managed with:

A. JOIN and UNION
B. GRANT and REVOKE ✔
C. COMMIT and ROLLBACK
D. INSERT and DELETE

Correct answer: B. GRANT and REVOKE

89. NoSQL databases differ from RDBMS by:

A. Requiring strict schemas
B. Always using SQL
C. Using flexible models like documents or key-value ✔
D. Having no data

Correct answer: C. Using flexible models like documents or key-value

90. Microsoft SQL Server uses the SQL dialect:

A. HiveQL
B. T-SQL (Transact-SQL) ✔
C. PL/SQL
D. PL/pgSQL

Correct answer: B. T-SQL (Transact-SQL)

91. TOP in SQL Server is used to:

A. Limit the number of rows returned ✔
B. Sort rows
C. Join tables
D. Delete tables

Correct answer: A. Limit the number of rows returned

92. SQL Server Management Studio (SSMS) is:

A. An ORM
B. A database engine
C. A web server
D. A tool to manage SQL Server databases ✔

Correct answer: D. A tool to manage SQL Server databases

93. Oracle’s procedural SQL extension is:

A. PL/SQL ✔
B. MySQL Script
C. T-SQL
D. NoSQL

Correct answer: A. PL/SQL

94. The main purpose of a DBMS is to:

A. Store, organise and retrieve data efficiently and securely ✔
B. Edit images
C. Write documents
D. Design websites

Correct answer: A. Store, organise and retrieve data efficiently and securely

95. MIN() returns:

A. The count
B. The largest value
C. The average
D. The smallest value in a column ✔

Correct answer: D. The smallest value in a column

96. MAX() returns:

A. The count
B. The smallest value
C. The largest value in a column ✔
D. The sum

Correct answer: C. The largest value in a column

97. SUM() returns:

A. The count
B. The minimum
C. The average
D. The total of numeric values ✔

Correct answer: D. The total of numeric values

98. AVG() returns:

A. The maximum
B. The total
C. The count
D. The average of numeric values ✔

Correct answer: D. The average of numeric values

99. INSERT INTO is used to:

A. Create a table
B. Update existing rows
C. Delete rows
D. Add new rows to a table ✔

Correct answer: D. Add new rows to a table

100. UPDATE … SET is used to:

A. Modify existing rows ✔
B. Delete tables
C. Create indexes
D. Insert rows

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

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.

About Priya Dogra

Priya Dogra runs priyadogra.com, where she shares free certification courses, internships, jobs, scholarships and exam preparation guides for Indian students and freshers. Follow her on YouTube, LinkedIn and Instagram for the latest opportunities.

Check Also

Unix/ Linux Certification exam answers 2026

Unix/ Linux Certification Exam Answers 2026 (All 100 Questions)

All 100 Unix/ Linux Certification exam questions with correct answers highlighted - updated 2026.

Leave a Reply

Your email address will not be published. Required fields are marked *