QUESTION 1 What is the purpose of the ROLLBACK command? O none of these answers

Question

QUESTION 1 What is the purpose of the ROLLBACK command? O none of these answers O The ROLLBACK command rolls back all the updates since the last COMMIT. O The ROLLBACK command rolls back all the updates since the last ROLLBACK. O The ROLLBACK command advances all the updates since the last COMMIT QUESTION 2 The DCL commands are used by the business end users of a database system. True False QUESTION 3 The data manipulation DBMS component is used: By no end users By end users, via front-end applications only By end users, either directy or via front-end applications end use rectly on

Explanation / Answer

Q1) What is the purpose of the ROLLBACK command?

Answer)

The ROLLBACK command rolls back all the updates since the last COMMIT.

In DBMS, the ROLLBACK command is the command which is used to undo all the operations on the DBMS to the point where the last commit took place.

Q2) The DCL commands are used by the business end users of a database system.

Answer)

True.

DCL includes commands such as GRANT and REVOKE which are used to give or withdraw user’s access privileges to database. Thus DCL is used by administrator and like to give access to users for accessing and performing several operations on the database. As business users consist of administrators also, thus the above statement is true.

Q3) The data manipulation DBMS component is used:

Answer)

By end users, via front-end applications only.

The reason of the above answer is that end users cannot directly access the database. End users can make operation on the system such that DML statements are executed and user performs the operation on the front-end.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.