DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
31. Data integrity can be maintained by
- Pre-defined subsets of the existing tables /SQL statements
- Occupy the disk space
- All the views are updatable
- Both b) and c)
32. Locks can be applicable for __________
- views
- indices
- triggers
- All of the above
33. The Advantages of the Normalization are except
- minimize storage redundancy
- provided optimum flexibilities
- Ensure proper and meaning full DML operations
- All the above
34. Which of the following is not true about the data dictionary
- Un-intentional query results
- Reveals new requirements in business
- Improved performance
- None of the above
35. Which is mandatory for transaction complete
- Is an integrated set of system tables
- Is stored in regular tables
- Can be maintained by the users
- Is accessed via vendor supplied views
36. which of the following are database objects
- A rollback or commit of the transaction is guaranteed
- Obeys user defined integrity constraints
- Both a) and b)
- None of the above
37. Tuple means
- consume space
- improve Query performance
- reduce insert/update performance
- all the above
39. ACID properties stands for
- Atomicity, Consistency, Isolation and durability
- Atomicity, Creativity, Isolation and durability
- Authority, Consistency, Isolation and durability
- None of the above
40. If Isolation level is set to Phantom Reads , Which of the following transaction integrity issues will resolved
- Serializable
- Dirty Reads
- Phantom Reads
- Non-Repeatable Reads