Tribhuvan University
Bachelor of Computer Application
Semester 8 · TU Board 2022
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
What is subquery? Explain it with example.
- 3.5
What is record in PLSQL? Explain different types of records used in PLSQL.
- 4.5
Define the variables and constants in PLSQL. Explain how variables differ from constants.
- 5.5
Explain the components of package with example.
- 6.5
What is trigger in PLSQL? Explain the differences between statement and Row level trigger?
- 7.5
What is function in PLSQL? Explain how it is differed from procedure.
- 8.5
Write a stored procedure to display the number of records in a table.
Group C
Attempt any TWO questions(2 × 10 = 20)
- 9.10
What is cursor in PLSQL? Why is it required? Explain the different steps of explicit cursor in PLSQL.
- 10.10
Explain different joins (Inner join, natural join, outer join (left outer, right outer, full outer), cross join) with example.
- 11.10
What is repetitive control statement? Explain different looping statements with example.
— The End —