Introduction to Computing MCQs with Answers
Practice important Introduction to Computing MCQs with answers and explanations.
Chapter: 160
Q2241:
What is a common method for addressing database errors in inexpensive personal use systems?
A. Reloading from a backup copy and manually updating
B. Automating error correction processes
C. Using advanced data encryption techniques
D. Implementing real-time error detection
Correct Answer:
A
Chapter: 160
Q2242:
Fill in the blank: In large, multiuser commercial database systems, maintaining integrity involves guarding against __________.
A. Partial completion of operations and inadvertent interactions
B. Technical details of database implementation
C. Small database sizes and low costs
D. User inconvenience and financial loss
Correct Answer:
A
Chapter: 160
Q2243:
What role does a DBMS play in large commercial database systems?
A. It maintains the database’s integrity by preventing issues
B. It provides technical support to users
C. It limits the size of the database
D. It handles the encryption of sensitive data
Correct Answer:
A
Chapter: 160
Q2244:
Fill in the blank: For personal use database systems, the inconvenience of errors is typically __________ compared to the cost of prevention.
A. Smaller
B. Greater
C. Larger
D. Equal
Correct Answer:
A
Chapter: 160
Q2245:
Which of the following is NOT a concern for personal use database systems?
A. Loss or corruption of data
B. Maintaining database integrity
C. Manual error correction
D. Reloading from backup copy
Correct Answer:
B
Chapter: 160
Q2246:
What is a significant difference between personal use and commercial multiuser database systems?
A. The level of data integrity maintenance required
B. The size of the database
C. The user interface design
D. The cost of the database system
Correct Answer:
A
Chapter: 160
Q2247:
Fill in the blank: The cost of incorrect or lost data in large commercial systems can be __________.
A. Enormous and devastating
B. Minimal and manageable
C. Negligible and inconsequential
D. Fixed and predictable
Correct Answer:
A
Chapter: 160
Q2248:
In the context of database management, what is a major role of the DBMS in a commercial environment?
A. Guarding against partial or incorrect operations
B. Making database modifications easier
C. Reducing the database's complexity
D. Providing user-friendly interfaces
Correct Answer:
A
Chapter: 161
Q2249:
What is the purpose of the commit point in a transaction?
A. It marks the end of a transaction and ensures changes are permanent
B. It indicates the start of a transaction
C. It is used for transaction rollback
D. It records errors in transactions
Correct Answer:
A
Chapter: 161
Q2250:
What does a rollback do in a database system?
A. Undoes the actions of a partially completed transaction
B. Commits a transaction to the database
C. Saves a snapshot of the database
D. Initiates a new transaction
Correct Answer:
A
Chapter: 161
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
Correct Answer:
A
Chapter: 161
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
Correct Answer:
A
Chapter: 161
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
Correct Answer:
A
Chapter: 161
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
Correct Answer:
A
Chapter: 161
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
Correct Answer:
A
Chapter: 161
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
Correct Answer:
A
Chapter: 161
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
Correct Answer:
A
Chapter: 161
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
Correct Answer:
A
Chapter: 161
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
Correct Answer:
A
Chapter: 162
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
Correct Answer:
A