TRANSACTION CONTROL LANGUAGE (TCL) and DATA CONTROL LANGUAGE (DCL)

Grant SELECT privilege on EMP table to a user named USER1.

(GRANT – BASIC SELECT)

Grant SELECT and INSERT privileges on EMP table to USER2.

(GRANT – MULTIPLE PRIVILEGES)

Grant all privileges on DEPT table to USER3.

(GRANT – ALL PRIVILEGES)

Grant SELECT privilege on EMP table to USER4 with GRANT OPTION.

(GRANT – WITH GRANT OPTION)

Grant UPDATE privilege only on SAL column of EMP table to USER5.

(GRANT – COLUMN LEVEL)

Grant DELETE privilege on EMP table to USER6.

(GRANT – DELETE)

Grant SELECT privilege on both EMP and DEPT tables to USER7.

(GRANT – MULTIPLE TABLES)

Grant privileges on EMP table to PUBLIC.

(GRANT – PUBLIC ACCESS)

Grant INSERT privilege on EMP table to USER8 with the ability to grant further.

(GRANT – WITH GRANT OPTION)

Grant UPDATE and DELETE privileges on EMP table to USER9.

(GRANT – UPDATE & DELETE)

Revoke SELECT privilege on EMP table from USER1.

(REVOKE – BASIC)

Revoke INSERT and UPDATE privileges on EMP table from USER2.

(REVOKE – MULTIPLE PRIVILEGES)

Revoke ALL privileges on DEPT table from USER3.

(REVOKE – ALL)

Revoke GRANT OPTION from USER4 on EMP table.

(REVOKE – GRANT OPTION)

Revoke UPDATE privilege on SAL column from USER5.

(REVOKE – COLUMN LEVEL)

Revoke DELETE privilege on EMP table from USER6.

(REVOKE – DELETE)

Revoke privileges granted to PUBLIC on EMP table.

(REVOKE – PUBLIC)

Revoke all privileges on EMP table from USER9.

(REVOKE – CLEANUP)

Insert a new employee record into EMP table and commit the changes.

(COMMIT – INSERT)

Update salary of employees in department 10 and commit the changes.

(COMMIT – UPDATE)

Delete employees with salary less than 1000 and commit the transaction.

(COMMIT – DELETE)

Insert multiple records into DEPT table and commit them together.

(COMMIT – MULTIPLE OPERATIONS)

Update department location and commit the changes.

(COMMIT – DEPT TABLE)

Insert a new employee into EMP table but rollback the transaction.

(ROLLBACK – INSERT)

Update salary of employees and then rollback the changes.

(ROLLBACK – UPDATE)

Delete records from EMP table and rollback the transaction.

(ROLLBACK – DELETE)

Perform multiple operations (INSERT, UPDATE, DELETE) and rollback all changes.

(ROLLBACK – MULTIPLE OPERATIONS)

Update department location and rollback before committing.

(ROLLBACK – DEPT TABLE)

Insert a new employee, update salary, and commit only after verifying results.

(TRANSACTION – COMMIT CONTROL)

Insert multiple employees, rollback one operation using SAVEPOINT, then commit remaining.

(TRANSACTION – SAVEPOINT + COMMIT)

Create a transaction where some operations are committed and others are rolled back.

(TRANSACTION – PARTIAL CONTROL)

Demonstrate use of SAVEPOINT in EMP table operations.

(TRANSACTION – SAVEPOINT)

Perform update on EMP table and rollback to a specific SAVEPOINT.

(TRANSACTION – ROLLBACK TO SAVEPOINT)

Grant privileges to a user, perform DML operations, and commit changes.

(GRANT + TRANSACTION)

Revoke privileges and verify access restrictions using EMP table.

(REVOKE – PRACTICAL SCENARIO)