Maharashi Dayanand University (MDU) 2006 M.C.A Computer Visual Basics & Oracle - Question Paper

Q:1 (a) elaborate Active X controls? How these are created, used and Useful? discuss through an example.
(b) Write a short note on Crystal Reports.
Q:2 Describe the subsequent with VB program segments:-
(i) Check boxes (ii) Timer control
(iii) Dialog boxes
(iv) Combo box
(v) Buttons

Q:3 What are SQL Menu ? How is it created, used and useful? discuss in detail with suitable examples.

Q:4 Explain the subsequent kinds of Reports in Oracle:-
(i) Test report
(ii) Dump report
(iii) Control-break report

Q:5 What are SQL forms ? How these are created and useful? discuss 2 kinds of forms in detail.

Q:6 Differentiate the following:-
(i) Table and view
(ii) Stored procedures and stored functions
(iii) SQL and PL/SQL

Q:7 Define Trigger. discuss different kinds of triggers in detail with suitable examples.

Q:8 Write short notes on the following:-
(i) Export/ Import utilities
(ii) SQL Loader
(iii) Data constraints in Oracle

Earning:   Approval pending.