DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q31
Data integrity can be maintained by
  • A Pre-defined subsets of the existing tables /SQL statements
  • B Occupy the disk space
  • C All the views are updatable
  • D Both b) and c)
Answer: Option D
Q32
Locks can be applicable for __________
  • A views
  • B indices
  • C triggers
  • D All of the above
Answer: Option C
Q33
The Advantages of the Normalization are except
  • A minimize storage redundancy
  • B provided optimum flexibilities
  • C Ensure proper and meaning full DML operations
  • D All the above
Answer: Option D
Q34
Which of the following is not true about the data dictionary
  • A Un-intentional query results
  • B Reveals new requirements in business
  • C Improved performance
  • D None of the above
Answer: Option C
Q35
Which is mandatory for transaction complete
  • A Is an integrated set of system tables
  • B Is stored in regular tables
  • C Can be maintained by the users
  • D Is accessed via vendor supplied views
Answer: Option C
Q36
which of the following are database objects
  • A A rollback or commit of the transaction is guaranteed
  • B Obeys user defined integrity constraints
  • C Both a) and b)
  • D None of the above
Answer: Option C
Q37
Tuple means
  • A consume space
  • B improve Query performance
  • C reduce insert/update performance
  • D all the above
Answer: Option D
Q38
RDMS is based on
  • A Hierarchical model
  • B relational
  • C Network
  • D none of these
Answer: Option B
Q39
ACID properties stands for
  • A Atomicity, Consistency, Isolation and durability
  • B Atomicity, Creativity, Isolation and durability
  • C Authority, Consistency, Isolation and durability
  • D None of the above
Answer: Option A
Q40
If Isolation level is set to Phantom Reads , Which of the following transaction integrity issues will resolved
  • A Serializable
  • B Dirty Reads
  • C Phantom Reads
  • D Non-Repeatable Reads
Answer: Option D

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test