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?
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?
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?
