What does the ON DELETE CASCADE option specify when defining a foreign key constraint?
ON DELETE CASCADE maintains referential integrity by automatically cascading deletions from the referenced parent table down to the referencing child table.
Which SQL command is used to assign privileges and permissions (such as SELECT, INSERT) to database users?
GRANT is a Data Control Language (DCL) command used to provide privileges to database users or roles.
Which SQL command is used to take back or cancel permissions previously granted to a user?
REVOKE is a DCL command used to retract privileges previously assigned via the GRANT statement.
Which command permanently saves all changes made by transactions to the database disk storage?
COMMIT is a Transaction Control Language (TCL) command that marks the successful end of a transaction and makes all updates permanent and durable.
Which command undoes transactions that have not yet been saved to the database?
ROLLBACK is a TCL command used to restore the database to its last committed state or to a defined savepoint, undoing uncommitted changes.