nerdexam
CompTIA

CAS-002 · Question #73

You have entered information in the database. It has been changed and is reflected in the database. What has been done?

The correct answer is B. Commit. When information has been changed and the change is reflected, it has been committed. The commit operation completes a transaction and executes all changes just made by the user. These changes can be made to data or schema information. Because these changes are committed, they…

Technical Integration of Enterprise Components

Question

You have entered information in the database. It has been changed and is reflected in the database. What has been done?

Options

  • AIntegrity Check
  • BCommit
  • CRollback
  • DSavepoint

How the community answered

(26 responses)
  • B
    88% (23)
  • C
    4% (1)
  • D
    8% (2)

Explanation

When information has been changed and the change is reflected, it has been committed. The commit operation completes a transaction and executes all changes just made by the user. These changes can be made to data or schema information. Because these changes are committed, they are then available to all other applications and users. If a user attempts to commit a change and it cannot complete correctly, a rollback is performed. This ensures that partial changes do not take place and that data are not corrupted.

Topics

#database transactions#commit#DBMS operations

Community Discussion

No community discussion yet for this question.

Full CAS-002 Practice