KESHAV MEMORIAL COLLEGE OF ENGINEERING
QUESTION BANK
(Regulation :R22)
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
Subject DATABASE PROGRAMMING WITH PL/SQL
Academic Year: 2024-2025 Year/Sem./Section M.Tech 1st yr/1/A
Faculty Name & Designation G. Keerthi ,Assistant Prof.
QUESTION BANK WITH BLOOMS TAXONOMY LEVEL (BTL)
(I. Remembering, II. Understanding, III.Applying, 4.Analyzing, 5.Evaluating,
6. Creating)
UNIT I : PL/SQL Basics: Block Structure, Behavior of Variables in Blocks, Basic Scalar and Composite
Data Types, Control Structures, Exceptions, Bulk Operations, Functions, Procedures, and Packages,
Transaction Scope.
PART-A(Short Questions)
Bloom’s Course
Q No. Questions Taxonomy Outcomes
Level
1. Write any 2 features of Pl/SQL. I CO1
2. What is delimiter? II CO1
Define Exceptions
3. II CO1
4. Explain Atomicity in Pl/SQL I CO1
What are the data types used in PL/SQL Scalar CO1
6. II
7. How variables are declared in PL/SQL I CO1
8. Write about Bulk Operations I CO1
9. What is Transaction Scope in PL/SQL. VI CO1
10. Differentiate between Scalar and Composite data types III CO1
PART–B(Long Questions)
1 Describe in detail Pl/SQL Control Structures with examples II
2 What are different data types used in PL/SQL III CO1
3. Define Functions. How functions are declared in PL/SQL II CO1
4 Draw and explain the block structure of PL/SQL I CO1
5 Illustrate different Procedures and Packages used in PL/SQL III CO1
UNIT II:BASIC STRUCTURES
Language Fundamentals & Control Structures: Lexical Units, Variables and Data Types, Conditional Statements, Iterative
Statements, Cursor Structures, Bulk Statements, Introduction to Collections, Object Types: Varray and Table Collections,
Associative Arrays, Oracle Collection API.
PART-A(Short Questions)
1. How are VARRAY declared? II CO2
2. Index-By Tables is also known as what? I CO2
3. List the examples of BULK SQL statements I CO2
4. What is the use of cursor statement V CO2
KESHAV MEMORIAL COLLEGE OF ENGINEERING
QUESTION BANK
(Regulation :R22)
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
Subject DATABASE PROGRAMMING WITH PL/SQL
Academic Year: 2024-2025 Year/Sem./Section M.Tech 1st yr/1/A
Faculty Name & Designation G. Keerthi ,Assistant Prof.
5. Define literals I CO2
6. List branching statements used in PL/SQL I CO2
7. Explain commonly used methods in the Collection API V CO2
8. Write about Oracle collection II CO2
9. What are different iterative statements used in PL/SQL I CO2
10.What is the use of CASE in conditional statement II CO2
PART–B(Long Questions)
1 What are different Lexical Units described in PL/SQL II CO2
2 Differentiate between Implicit cursor and Explicit cursor I CO2
3 How are associative arrays used in Pl/SQL IV CO2
4 Explain Nested tables and how are they declared III CO2
5 What are the 3 main types of Collections in PL/SQL VI CO2
UNIT-III: Functions and Procedures: Function and Procedure Architecture, Transaction Scope, Calling Subroutines,
Positional Notation, Named Notation, Mixed Notation, Exclusionary Notation, SQL Call Notation
PART-A(Short Questions)
1. IN OUT type parameter is used for? I CO3
2. What is the use of Return Type in function VI CO3
3 Write any 2 Difference between Procedures and Functions I CO3
4 Difference between COMMIT and RollBack VI CO3
5 What is the use of SAVEPOINT transaction II CO3
6 Define Mixed calling notation I CO3
7 Explain stored procedure call using positional notation II CO3
8 What are Association operator III CO3
9 How PL/SQL function calls using Named calling Notation V CO3
10 Write an example for mixed calling notation I CO3
PART–B(Long Questions)
1. How can u pass parameters to procedures? Explain types V CO3
2 What are the types of calling notations for subroutines I CO3
3. What are the 2 ways to execute procedure. VI CO3
4 Write the syntax of function and explain how functions are executed I CO3
5. Illustrate different Exclusionary notations used in PL/SQL III CO3
