The DBMS stands for Database Management System and it is actually a very important software. The role of this software is to interact correctly with different applications, end-users, as well as the database itself. This interaction gives this software the capacity to capture and analyze the concerned data.
Questions regarding this software are frequently asked in different interviews and if you are not able to answer them correctly, then you might end up missing the job. So, here we will be listing some of the dbms mcq questions that are considered as very important for different kinds of examinations and interviews.
You can go through these mcq questions to get a brief idea about your interview preparation. If you are going to give any examinations, then you can practice these mcqs before that to get some knowledge regarding the examination questions.
Important Dbms mcq questions for interviews
1. Which of the following is the property of transaction that protects data from system failure?
A. Atomicity
B. Isolation
C. Durability
D. Consistency
2. Which is the lowest level of abstraction that describes how the data are actually stored?
A. Physical
B. Abstract
C. View
D. User
3. Which of the following is the full form of TCL?
A. Ternary control language
B. Transaction control language
C. Transaction central language
D. Transmission control language
4. Select the correct definition of relation.
A. Subset of a cartesian product of list of domains
B. Subset of a cartesian product of list of tuple
C. Subset of a cartesian product of list of attributes
D. Subset of a cartesian product of list of relations
5. Which of the following is known as the minimal super key?
A. Primary key
B. Candidate key
C. Foreign key
D. None
6. How is the ER diagram represented?
A. Circle
B. Ellipse
C. Triangle
D. Square
7. Identify the concurrency based protocol?
A. Lock based protocol
B. Two phase locking protocol
C. Timestamp ordering protocol
D. All
8. What is the name of the query that is placed within a WHERE or HAVING clause of another query?
A. Multi query
B. Subquery
C. Super query
D. Master query
9. After which operation is the modify operation done?
A. Look-up
B. Insert
C. Delete
D. All
10. Which of the following normal forms contains information about a single entity?
A. 1NF
B. 2NF
C. 3NF
D. 4NF
11. Which of the following is the full form of NTFS?
A. New Tree File System
B. New Technology FIle System
C. New Table File System
D. Both B and C
12. Select the definition of the correct key which is used to represent relation between two tables?
A. Candidate key
B. Foreign key
C. Primary key
D. Super key
13. To select some particular columns, which of the following command is used?
A. PROJECTION
B. SELECTION
C. JOIN
D. UNION
14. Select the correct advantages of view.
A. Derived columns
B. Data security
C. Hiding of complex queries
D. All of the above
15. What is a table joined with itself called?
A. Join
B. Self join
C. Outer join
D. Equi join
Common dbms mcq questions for exams
1. What do you mean by one to many relationships?
A. One class may have many teachers
B. One teacher can have many classes
C. Many classes may have many teachers
D. Many teachers may have many classes
2. The term “FAT” is stands for_____
A. File Allocation Tree
B. File Allocation Table
C. File Allocation Graph
D. All of the above
3. Which of the following can be considered as the maximum size that is supported by NTFS?
A. 4GB
B. 16TB
C. 64TB
D. 8TB
4. Which of the following can be used to extract or filter the data & information from the data warehouse?
A. Data redundancy
B. Data recovery tool
C. Data mining
D. Both B and C
5. Which one of the following refers to the “data about data”?
A. Directory
B. Sub Data
C. Warehouse
D. Meta Data
6. To which of the following the term “DBA” referred?
A. Data Bank Administrator
B. Database Administrator
C. Data Administrator
D. None of the above
7. Rows of a relation are known as the _.
A. Degree
B. Tuples
C. Entity
D. All of the above
8. Which one of the following is a type of Data Manipulation Command?
A. Create
B. Alter
C. Delete
D. All of the above
9. Which of the following is a top-down approach in which the entity’s higher level can be divided into two lower sub-entities?
A. Aggregation
B. Generalization
C. Specialization
D. All of the above
10. Which of the following refers to the number of attributes in a relation?
A. Degree
B. Row
C. Column
D. All of the above
11. Which of the following commands is used to save any transaction permanently into the database?
A. Commit
B. Rollback
C. Savepoint
D. None of the above
12. The database management system can be considered as the collection of __ that enables us to create and maintain the database.
A. Translators
B. Programs
C. Keys
D. Language activity
Tough dbms mcq questions list
1. What is the limitation in Hierarchical Database Model?
A. Lack Structural Independence
B. Complex Implementation
C. Tough to handle many-many relationship
D. All of the above
2. Which of the following is a limitation in the Network data Model?
A. Simple
B. Difficult design
C. Low-maintenance
D. Low-cost
3. What is TRUE about relational database model?
A. Set theory and predicate logic are used in this model.
B. Relational databases were replaced by many other models such as object-oriented models, object-relational models, and others during the era of the relational database.
C. There are two main terms used in a relational database model: instance and schema.
D. All of the above
4. Which of the following is a cloud database?
A. Amazon Web Services
B. Snowflake Computing
C. Google cloud spanner
D. All of the above
5. Which of the following is key-value store NoSQL database system?
A. HBase
B. MongoDB
C. Redis
D. Accumulo
6. What is/are the disadvantage(s) of NoSQL?
A. Open Source
B. GUI is not available
C. Backup
D. All of the above
7. Which of the following components is NOT present in Relational Database?
A. Instance
B. Schema
C. Keys
D. None of the above
8. Which of the following is present in the Graph Database?
A. Node
B. Edge
C. Both A. and B.
D. None of the above
9. Which among the following is a property of the Relational Model?
A. Classes
B. Inheritance
C. Query Processing
D. Encapsulation
10. Which among the following is a property of Object-oriented programming?
A. Atomicity
B. Objects
C. Durability
D. Concurrency
Conclusion
So, we have listed some of the most important dbms mcq questions that the candidates must be aware of. Along with that, we have also focused on some questions that are very common in different examinations and interviews. Lastly, we have enumerated some of the toughest dbms questions that are directed towards the candidates during the advanced stages of interview. So, solve all these questions correctly in order to get the desired success in your examinations and interviews.