Tribhuvan University
Bachelor of Computer Application
Semester 8 · TU Board 2025
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
Define database programming. Describe the differences between procedural and non-procedural access to a database. [1+4]
- 3.5
What is a subquery? Explain the use of GROUP BY and HAVING clauses in SQL. [1+4]
- 4.5
Explain the concept of parameter modes (IN, OUT, IN OUT) in PL/SQL with examples. [5]
- 5.5
Define trigger. Write the syntax to create a row-level trigger in PL/SQL. [1+4]
- 6.5
Write a PL/SQL block using an explicit cursor to display all employee names from the Employee table. [5]
- 7.5
What are constants in PL/SQL? Give syntax and an example. [5]
- 8.5
Differentiate between anonymous blocks and named blocks in PL/SQL. [5]
Group C
Attempt any TWO questions(2 × 10 = 20)
- 9.10
Explain stored procedure. Explain views in SQL, their creation, modification, and deletion with examples. [3+7]
- 10.10
Explain the structure of a PL/SQL block with an example. Explain exception handling in PL/SQL with examples of predefined and user-defined exceptions. [5+5]
- 11.10
What are cursor parameters? Give an example. Describe the types of iterative control structures available in PL/SQL with examples. [4+6]
— The End —