Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Multiple Choice Questions
Q2251: What is a common cause for a database to be found in an inconsistent state?
- A: Equipment malfunction or an incomplete transaction
- B: Proper transaction completion
- C: Successful transaction commit
- D: Normal database operations
View Answer
A
Q2252: Fill in the blank: The log in a database system records __________ of each transaction's activities.
- A: Actions
- B: Errors
- C: Results
- D: States
View Answer
A
Q2253: What is the role of the log during an equipment malfunction?
- A: It is used to reconstruct completed transactions since the last backup
- B: It is used to start a new transaction
- C: It helps in rolling back completed transactions
- D: It records transaction errors
View Answer
A
Q2254: What does cascading rollback refer to?
- A: The situation where rolling back one transaction may require rolling back other dependent transactions
- B: The process of completing a transaction
- C: The logging of transaction errors
- D: The process of starting new transactions
View Answer
A
Q2255: When is a transaction considered to be committed?
- A: When all steps have been recorded in the log and changes are guaranteed to be reflected in the database
- B: When the transaction starts
- C: When an error occurs
- D: When the database is backed up
View Answer
A
Q2256: Fill in the blank: In a DBMS, rolling back transactions might be necessary due to __________ or errors in accessing data.
- A: Deadlocks
- B: Equipment malfunctions
- C: Successful transactions
- D: Completed transactions
View Answer
A
Q2257: What can be a consequence of cascading rollback?
- A: Additional transactions might need to be rolled back, potentially affecting other transactions
- B: The database will become consistent and correct
- C: The system will automatically repair itself
- D: The DBMS will shut down to prevent errors
View Answer
A
Q2258: What happens if a transaction reaches its commit point?
- A: The transaction is guaranteed to be reflected in the database
- B: The transaction is rolled back
- C: The transaction is paused
- D: The transaction is reinitiated
View Answer
A
Q2259: Fill in the blank: A log in a database system is typically stored in __________ storage to prevent data loss.
- A: Non-volatile
- B: Volatile
- C: Temporary
- D: Active
View Answer
A
Q2260: What problem occurs when one transaction tries to compute totals while another is transferring funds?
- A: The incorrect summary problem
- B: The lost update problem
- C: The deadlock problem
- D: The transaction timeout problem
View Answer
A