Tribhuvan University
Bachelor of Computer Application
Semester 8 · TU Board 2024
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 Oracle database architecture in detail.
- 3.5
Explain the different DDL commands used in oracle.
- 4.5
What is identifier? Explain the different properties of identifier.
- 5.5
Explain the different types of collections in PLSQL.
- 6.5
Explain how user defined exception can be raised with example.
- 7.5
What is row level trigger? Explain BEFORE row triggers & AFTER row triggers with examples.
- 8.5
What are packages? What does a PL/SQL Package Consist of?
Group C
Attempt any TWO questions(2 × 10 = 20)
- 9.10
Differentiate between stored procedure and stored function with example. How parameterized stored procedure can be used? Explain with example.
Answer comingAlso asked in 2023
- 10.10
Write the queries for following operations: a) Create two tables (parent and child) maintaining referential integrity. b) Display the record using inner join (natural join) c) Demonstrate the Outer join (left outer, right outer and full outer join) d) Demonstrate the cross join
- 11.10
Differentiate between implicit and explicit cursors. Write a program to display the name and salary of the employee using cursor explaining different control steps.
— The End —