DBMS MCQ Question and Answer
DBMS MCQ Question and Answer
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)
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