TU Papers Notes

BCA 8th Semester
Database Programming 2024 Board Question Paper - Tribhuvan University (TU) 2024

Views: …
Tribhuvan University official logo

Tribhuvan University

Faculty of Humanities & Social Science
OFFICE OF THE DEAN
TUpapers.com TUpapers.com

Bachelor In Computer Application

Course Title: Database Programming

Code No: CACS 484

Semester: VIII

Full Marks: 60 Pass Marks: 24 Time: 3 hours

Candidates are required to answer the question in their own words as far as possible.

Group B
Attempt any SIX question.
[6x5=30]
2.

Explain Oracle database architecture in detail.

3.

Explain the different DDL commands used in oracle.

4.

What is identifier? Explain the different properties of identifier.

5.

Explain the different types of collections in PLSQL.

6.

Explain how user defined exception can be raised with example.

7.

What is row level trigger? Explain BEFORE row triggers & AFTER row triggers with examples.

8.

What are packages? What does a PL/SQL Package Consist of?

Group C

Attempt any TWO questions

[2x10=20]
9.

Differentiate between stored procedure and stored function with example. How parameterized stored procedure can be used? Explain with example.

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.

Differentiate between implicit and explicit cursors. Write a program to display the name and salary of the employee using cursor explaining different control steps.