Scribd
Upload
479 views5 pages

DCL and TCL Queries for Database Management

This document contains questions and answers about data control languages, transfer control languages, and database transactions. It asks the student to write queries to grant and revoke privileges between tables, implement save points, rollbacks and commits during transactions, and view data in a table before and after transactions. The goal is to study DCL, TCL commands, and handling transactions in a database.

Uploaded by

Chandresh Padmani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
479 views5 pages

DCL and TCL Queries for Database Management

This document contains questions and answers about data control languages, transfer control languages, and database transactions. It asks the student to write queries to grant and revoke privileges between tables, implement save points, rollbacks and commits during transactions, and view data in a table before and after transactions. The goal is to study DCL, TCL commands, and handling transactions in a database.

Uploaded by

Chandresh Padmani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 5

CE246-DBMS 18CE091

Practical – 9
Aim To study various Data Control Languages (DCL),Transfer Control Language (TCL)
commands
Q-1 Develop a query to grant all privileges of employees table into departments table.

Q-2 Develop a query to grant some privileges of employees table into departments table.

U & P U Patel Department of Computer Engineering


CE246-DBMS 18CE091

Q-3 Develop a query to revoke all privileges of employees table from departments table..

Q-4 Develop a query to revoke some privileges of employees table from departments table.

Q-5 Write a query to implement the save point.

U & P U Patel Department of Computer Engineering


CE246-DBMS 18CE091

Q-6 Insert into employees values(‘c03’,’nishit’,50000,’c01’);

Q-7 Select * from employees;

U & P U Patel Department of Computer Engineering


CE246-DBMS 18CE091

Q-8 Write a query to implement the rollback.

Q-9 Select * from employees;

U & P U Patel Department of Computer Engineering


CE246-DBMS 18CE091

Q10 Write a query to implement the commit.

Sign: Grade:

U & P U Patel Department of Computer Engineering

You might also like