Data and Database Administration Questions and Answers

Q: Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.

Correct answer: TrueBackward recovery, or rollback, applies the before-images in reverse order to undo the effects of a transaction that did not complete. It restores the database to the state it held before the transaction began, which is what makes atomicity possible - a transaction either happens entirely or not at all.

Q: A disaster recovery plan does not need to include the shipment of database backups to other sites.

Correct answer: FalseBackups held only on the site they protect are destroyed with it, so offsite storage is precisely what makes a disaster recovery plan a disaster recovery plan rather than a failure recovery plan. Shipping copies to another location, physically or electronically, is a core requirement.

Q: With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.

Correct answer: FalseConcurrency control exists to prevent exactly that interference. Locking or timestamping ensures that concurrent transactions produce the same result as if they had run one after another, so the database is not compromised. Without concurrency control the statement would be true.

Q: Data modeling and database design are key responsibilities of data and data base administration.

Correct answer: TrueData administration owns the enterprise data model and the standards; database administration owns the physical design, tuning and operation. Both are design responsibilities rather than merely operational ones, which is why the roles sit alongside development rather than beneath it.

Q: Incorrect data is easy to detect.

Correct answer: FalseIncorrect data is usually well-formed and plausible - a valid date that is the wrong date, a real address belonging to someone else - so it passes every format check and is discovered only when someone acts on it. This is why quality has to be built in at the point of capture rather than inspected for afterwards.

31.

Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.

A.True
B.False

Answer: A

Correct answer: True

Backward recovery, or rollback, applies the before-images in reverse order to undo the effects of a transaction that did not complete. It restores the database to the state it held before the transaction began, which is what makes atomicity possible - a transaction either happens entirely or not at all.

Discuss in Forum

32.

A disaster recovery plan does not need to include the shipment of database backups to other sites.

A.True
B.False

Answer: B

Correct answer: False

Backups held only on the site they protect are destroyed with it, so offsite storage is precisely what makes a disaster recovery plan a disaster recovery plan rather than a failure recovery plan. Shipping copies to another location, physically or electronically, is a core requirement.

Discuss in Forum

33.

With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.

A.True
B.False

Answer: B

Correct answer: False

Concurrency control exists to prevent exactly that interference. Locking or timestamping ensures that concurrent transactions produce the same result as if they had run one after another, so the database is not compromised. Without concurrency control the statement would be true.

Discuss in Forum

34.

Data modeling and database design are key responsibilities of data and data base administration.

A.True
B.False

Answer: A

Correct answer: True

Data administration owns the enterprise data model and the standards; database administration owns the physical design, tuning and operation. Both are design responsibilities rather than merely operational ones, which is why the roles sit alongside development rather than beneath it.

Discuss in Forum

35.

Incorrect data is easy to detect.

A.True
B.False

Answer: B

Correct answer: False

Incorrect data is usually well-formed and plausible - a valid date that is the wrong date, a real address belonging to someone else - so it passes every format check and is discovered only when someone acts on it. This is why quality has to be built in at the point of capture rather than inspected for afterwards.

Discuss in Forum

Data and Database Administration Questions and Answers

Topics

Other Subjects

About Us

Data and Database Administration Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications