SQL Code Development DS0-001 Practice Questions (Page 5)

Part of the Database fundamentals domain, which accounts for 24% of the DS0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–14 in this domain), expect 2–4 from this objective — we provide 22 practice questions to prepare you well beyond it. (estimate)

22questions here

5free pages

6concepts

24%of the exam

Questions 21–22

21foundation · easy
A database system crashes immediately after a transaction is committed. After recovery, the database must ensure that the committed changes are still present. Which ACID property is responsible for this guarantee?
Select an answer first
22application · easy
A database administrator is performing a series of updates to a `products` table. They want to be able to undo the changes made after a certain point without undoing the entire transaction. Which TCL command should they use to mark a point within the transaction?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DS0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DS0-001” is a trademark of its owner, used for identification only.

SQL Code Development DS0-001 Practice Questions (Page 5)

Questions 21–22

A database system crashes immediately after a transaction is committed. After recovery, the database must ensure that the committed changes are still present. Which ACID property is responsible for this guarantee?

A database administrator is performing a series of updates to a `products` table. They want to be able to undo the changes made after a certain point without undoing the entire transaction. Which TCL command should they use to mark a point within the transaction?

Keep studying — Database fundamentals