BCA 8th Semester
Database Programming 2023 Board Question Paper

Views: ...
tribhuvan university logo

Tribhuvan university

Bachelor In Computer Application

Course Title: Database Programming

Code No: CACS 484

Semester:VIII

2023

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 A
Group B
Attempt any SIX question.
[6x5=30]
2.

Explain the PL/SQL block structure with an example.

3.

What are records and nested records in PL/SQL? Explain benefits of using records.

4.

How functions can be called and parameterized in databases? Explain with examples.

5.

What is a cursor? Explain different types of cursors used in database.

6.

Why do we need to use triggers in the database? Explain the use of triggers with proper examples.

7.

How user define exceptions can be created in PL/SQL? Explain with proper example.

8.

Write short notes (any two):
a) INSTEAD OF trigger
b) Packages
c) Parameterized cursor

Group C

Attempt any TWO questions

[2x10=20]
9.

Explain PL/SQL architecture. Differentiate between SQL and PL/SQL Also explain the conditional constructs used in PL/SQL.

10.

Define stored procedure. Explain different parameter modes used in stored procedures. Also differentiate between functions and stored procedure with examples.

11.

Explain row trigger and statement trigger with examples. Explain any five SQL*PLUS commands.