Week2 - Data Control and Transaction Control Language / Explore

The questions can come in any order, so make sure you are selecting right option for all questions.

What is the main purpose of Data Control Language (DCL) in a database?

    (b) Controlling access and permissions on data

What action does the REVOKE statement perform in a database?

    (d) Revokes specific privileges from a user

Which TCL statement is used to permanently save the changes made during the current transaction?

    (a) COMMIT

What does the ROLLBACK statement do in the context of a database transaction?

    (b) Undoes the changes made during the transaction

How does DCL contribute to database security?

    (b) By controlling access and permissions on data

Which TCL statement is used to mark a specific point in a transaction to which you can later roll back?

    (c) SAVEPOINT

What is the primary purpose of Transaction Control Language (TCL) in a database?

    (d) Controlling the flow of transactions

In the context of databases, what does the acronym DCL stand for?

    (c) Data Control Language

What action does the ROLLBACK TO SAVEPOINT statement perform in a database transaction?

    (b) Undoes changes made up to a specific savepoint

Which DCL statement is used to grant specific privileges to a user in a database?

    (a) GRANT