Scribd
Upload
81 views

Unit 4 Dbms Assignment

This document contains assignments on database management systems (DBMS) topics for a course. It includes 3 sets of questions covering PL/SQL programming concepts like blocks, data types, procedures, and triggers. The questions ask students to explain SQL clauses like GROUP BY and HAVING, and PL/SQL concepts like implicit and explicit cursors, stored procedures versus triggers. Students are also asked to write PL/SQL programs demonstrating these concepts.

Uploaded by

Keerthika Angel
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
81 views

Unit 4 Dbms Assignment

This document contains assignments on database management systems (DBMS) topics for a course. It includes 3 sets of questions covering PL/SQL programming concepts like blocks, data types, procedures, and triggers. The questions ask students to explain SQL clauses like GROUP BY and HAVING, and PL/SQL concepts like implicit and explicit cursors, stored procedures versus triggers. Students are also asked to write PL/SQL programs demonstrating these concepts.

Uploaded by

Keerthika Angel
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/ 1

Sub DBMS

Subject: DBMS Branch: II CSE-CSC,AIML


Academic Year: 2022-23 Semester: II
Faculty: P.Srinivasa Reddy

UNIT-4 ASSIGNMENT QUESTIONS

Unit Assignment Course


Topic Blooms
No No/Set Outcome
Level
1a).Explain use of group by, having and order by clauses.
CO4
1b) Explain EXIT, ANY, ALL clauses 2
2a). Explain Transaction Control commands- Commit, Rollback
and Save point. CO3 4
b). Differentiate implicit and explicit cursors.
IV 4/Set-1
3a). Explain PL/SQL block structure and data types.
b). Write a PL/SQL program to find largest of two numbers using
procedure. CO3 2
c) Explain Triggers. Create a trigger for displaying difference in
salary, new salary and old salary.
1a). Differentiate between Group by and having by with example.
CO3 4
1b). Differentiate between where and having clause with example.

2a). Differentiate between EXIST, ANY and ALL with example.


IV 2b). Differentiate between Stored Procedures and Triggers with CO3 2
4/Set-2 example.
3a). Explain explicit cursor .Write a PL/SQL program and Create
an explicit cursor to fetch details of employees.
3b). Write a PL/SQL program and Create an implicit cursor and CO3 2
insert a row in
employee table
1. a). Explain PL/SQL block structure and data types.
b). Write a PL/SQL program to find largest of two numbers using
procedure. CO3 2
c) Explain Triggers. Create a trigger for displaying difference in
salary, new salary and old salary.
IV 4/Set-3 2a). Differentiate between EXIST, ANY and ALL with example.
2b). Differentiate between Stored Procedures and Triggers with CO3 4
example
3a). Explain Transaction Control commands- Commit, Rollback
and Save point. CO3 2
b). Differentiate implicit and explicit cursors.

You might also like