Maharashi Dayanand University (MDU) 2007 M.C.A Computer Visual Basics & Oracle - exam paper

Q1. (a) elaborate various data kinds available in ORACLE? discuss those using suitable examples.
Q2. discuss the subsequent integrity constraints. How are these implemented in ORACLE
(a) Referential integrity constraint
(b) Primary key integrity constraint
(c) Not null integrity constraint..
Q3. (a)What are the various control statements available in PL/SQL? provide an overview of those.
(b) What do you understand by the cursor variables? elaborate the uses of them? discuss
(c) What do you understand by MDI? How is it various from SDI? How does MDI component help in Visual C++
programming environment? Illustrate.
Q4. What is a trigger? elaborate the various kinds of trigger? elaborate various applications of
triggers? How can you enforce the referential integrity using triggers?
Q5. (a) Write short notes on following:-
1. Master-Detail report
2. SQL * loaders.
Q6. (a) What is the purpose of keyboard access keys in VB? How can you describe them in your
project? How do they operate at run time? discuss.
(b) How does the behavior of choice button differ from the behavior of check boxes? discuss using suitable
examples.
Q7. (a) Name and provide the purposes of 5 kinds of data available in VB.
(b) discuss the difference ranging from ByRef and ByVal .When would every be used?
Q8. (a) What properties must be set to bind a combo box to a field in a database? discuss using
example.
(b) How the SQL is used in VB? discuss.

Earning:   Approval pending.