Scribd
Upload
22 views2 pages

M.Tech PL/SQL Mid Question Bank 2024-25

This document is a question bank for the M.Tech I Year I Semester course on Database Programming with PL/SQL at Mallareddy Engineering College. It includes a list of subjective questions categorized by modules, covering topics such as PL/SQL block structure, data types, control structures, exceptions, and cursor structures. Each question specifies marks, Bloom's Taxonomy level, and course outcomes.

Uploaded by

Ashwini Korvipally
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
22 views2 pages

M.Tech PL/SQL Mid Question Bank 2024-25

This document is a question bank for the M.Tech I Year I Semester course on Database Programming with PL/SQL at Mallareddy Engineering College. It includes a list of subjective questions categorized by modules, covering topics such as PL/SQL block structure, data types, control structures, exceptions, and cursor structures. Each question specifies marks, Bloom's Taxonomy level, and course outcomes.

Uploaded by

Ashwini Korvipally
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

MALLAREDDY ENGINEERING COLLEGE (AUTONOMOUS)

[Link] I YEAR I Semester (MR 24) I Mid Question Bank 2024-25 (Subjective)

Subject Code and Name: DATABASE PROGRAMMING WITH PL/SQL

Branch/ Specialization: CSE/ (CSE) Code: D5103

Name of the Faculty: Mr K V VARAPRASAD

Module-1
[Link] Questions Marks BT CO
Level
1. Determine Construct the Block Structure in PL/SQL? Explain 4 L5 1
with the help of diagram?
2. Classify about the Behavior of Variables in Blocks? 4 L4 1
3. Determine the Basic Scalar and Composite Data Types in 4 L5 1
PL/SQL? Describe with the of example?
4. Construct the Control Structures in PL/SQL? Explain different 4 L6 1
types of Control Structures?
5. Classify the Exceptions in PL/SQL? Briefly explain types of 4 L2 1
exceptions?
6. Simplify the Bulk Operations in PL/SQL? Explain about the 4 L4 1
bulk collect and bulk bind in PL/SQL?
7. Examine the process of Procedures, and Packages in PL/SQL? 4 L4 1
8. Determine the Transaction Scope in PL/SQL? Explain about 4 L4 1
the Implicit and Explicit process in Transaction?
Module-2
[Link] Questions Marks BT CO
Level
1. Evaluate briefly about Lexical Modules in PL/SQL? Explain 4 L5 2
with help of examples?
2. Compare the Variables and Data Types in PL/SQL? 4 L4 2
3. Determine the rules of Conditional Statements and Iterative 4 L5 2
Statements? Illustrate about If Else and Case in Conditional
Statements?
4. Explain about the Cursor Structures in PL/SQL? Classify the 4 L5 2
types of Cursor?
5. Evaluate the Bulk Statements and Explain its uses? 4 L5 2
6. Compare the difference between Varray and Table Collections 4 L3 2
in PL/SQL?
7. Explain about the Associative Arrays in PL/SQL? How to 4 L5 2
initialize the Associative Arrays?
8. 4 L6 2
Elaborate the Oracle Collection API. in PL/SQL? Classify the
collections and records?

Module-3

[Link] Questions Marks BT CO


Leve
l
1. Simplify Function and Procedure Architecture in PL/SQL? 4 L4 3
Describe with the help neat diagram?
2. Illustrate about the Calling Subroutines in PL/SQL? 4 L5 3
3. Compare Positional Notation, Named Notation, Mixed 4 L5 3
Notation in PL/SQL?
4. Differentiate Exclusionary Notation, SQL Call Notation? 4 L6 3
Explain with examples?

Signature of the Faculty Signature of the HOD

You might also like