Unit 3: SQL and Advanced Database Programming21CSC205P

PL/SQL Programming: Blocks, Procedures and Functions

Curriculum and historical examination lineage for PL/SQL Programming: Blocks, Procedures and Functions under Unit 3 (SQL and Advanced Database Programming) of Database Management Systems (21CSC205P) at SRMIST.

Appearances
4
Cataloged Exam Questions
Exam Papers
2
Distinct University Exams
Question Families
0
Recurring Conceptual Archetypes
SRMIST Status
Active
Regulation 2021 Syllabus
Assessment Cycle Weightage

Historical appearance distribution across SRMIST Formative Tests (CT1, CT2) and University End Semester examinations.

CT1
0
Cycle Test 1
CT2
0
Cycle Test 2
EndSem
4
Semester Exam
Marks Weightage Distribution

Factual marks weightage of questions asked on this topic in historical examinations.

1 Marks:3 questions
8 Marks:1 questions
Sample Past Exam Questions

Representative historical questions extracted directly from SRMIST examination papers.

Which is correct for the trigger? (A) It is an event driven one (B) It is executed manually (C) In PL/SQL there are 10 events (D) PL/SQL not support triggers for trigger [1]

Year: 2022•Assessment: EndSem
1 Marks

Which is not an exception in PL/SQL (A) No data found (B) Too many rows (C) Value error (D) Length string [1]

Year: 2022•Assessment: EndSem
1 Marks

What is trigger? How triggers are implemented in PL/SQL? [8]

Year: 2022•Assessment: EndSem
8 Marks

Identify the statement that best describes a view in a database. (A) A view is a type of index (B) A view is a stored procedure (C) A view is a virtual table that is based on the...

Year: 2023•Assessment: EndSem
1 Marks
Historical Papers Indexed (2)

Examinations where questions for PL/SQL Programming: Blocks, Procedures and Functions have appeared.

Database Management Systems - NOV 2022 Examination Paper
2022EndSem
Database Management Systems - MAY 2023 Examination Paper
2023EndSem
Other Exam Topics in Unit 3: SQL and Advanced Database Programming

Master PL/SQL Programming: Blocks, Procedures and Functions in MintAI

Practice past exam questions, test recurring archetypes, and view predictive probability for this topic before your upcoming exam.