Tribhuvan University
Bachelor of Computer Application
Semester 8 · TU Board 2023
Course Title: Database Programming (CACS484)
Full Marks: 60Pass Marks: 24Time: 3 hours
Candidates are required to answer the question in their own words as far as possible.
Group B
Attempt any SIX question.(6 × 5 = 30)
- 2.5
Explain the PL/SQL block structure with an example.
- 3.5
What are records and nested records in PL/SQL? Explain benefits of using records.
- 4.5
How functions can be called and parameterized in databases? Explain with examples.
- 5.5
What is a cursor? Explain different types of cursors used in database.
- 6.5
Why do we need to use triggers in the database? Explain the use of triggers with proper examples.
- 7.5
How user define exceptions can be created in PL/SQL? Explain with proper example.
- 8.5
Write short notes (any two): a) INSTEAD OF trigger b) Packages c) Parameterized cursor
Group C
Attempt any TWO questions(2 × 10 = 20)
- 9.10
Explain PL/SQL architecture. Differentiate between SQL and PL/SQL Also explain the conditional constructs used in PL/SQL.
- 10.10
Define stored procedure. Explain different parameter modes used in stored procedures. Also differentiate between functions and stored procedure with examples.
Answer comingAlso asked in 2024
- 11.10
Explain row trigger and statement trigger with examples. Explain any five SQL*PLUS commands.
— The End —