BCA 8th Semester
Database Programming 2022 Board Question Paper

Views: ...
tribhuvan university logo

Tribhuvan university

Bachelor In Computer Application

Course Title: Database Programming

Code No: CACS 484

Semester:VII

2022

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.

What is subquery? Explain it with example.

3.

What is record in PLSQL? Explain different types of records used in PLSQL.

4.

Define the variables and constants in PLSQL. Explain how variables differ from constants.

5.

Explain the components of package with example.

6.

What is trigger in PLSQL? Explain the differences between statement and Row level trigger?

7.

What is function in PLSQL? Explain how it is differed from procedure.

8.

Write a stored procedure to display the number of records in a table.

Group C

Attempt any TWO questions

[2x10=20]
9.

What is cursor in PLSQL? Why is it required? Explain the different steps of explicit cursor in PLSQL.

10.

Explain different joins (Inner join, natural join, outer join (left outer, right outer, full outer), cross join) with example.

11.

What is repetitive control statement? Explain different looping statements with example.