Veer Narmad South Gujarat University 2011-3rd Sem B.C.A Computer Application SB-1442 - 302 : Relational Database Management System ( new ) Second Year ( ) - Question Paper

SB-1442

Second Year B. C. A. (Sem. Ill) Examination March / April - 2011 Relational Database Management System : Paper - 302

(New Course)

Time : 3 Hours]

[Total Marks : 70

Instructions

(1)_

M    CnsLLnlcj.L{l [qoicu    u? snqw <h>h41.

Fillup strictly the details of signs on your answer book.

Name of the Examination :

S. Y. B. C. A. (Sem. 3)

Name of the Subject:

Relational Database Management System - 302 (New)

-Subject Code No.:

1 4 4 2

-Section No. (1,2,.....): Nil

3    Answer the followings : (any two)    14

(a)    How cursor for loop and cursor for update works ?

Provide appropriate example to explain this.

(b)    What is Cursor ? Explain difference between explicit and implicit cursors.

(c)    What is Package ? How a package is created ?

4    Answer the followings : (any four)    20

(a)    What is nested table ? How to create nested tables ?

(b)    What is cursor For Loop ? How cursor for UPDATE is used ?

(c)    What is exception ? How exceptions are handled ?

Explain the difference between user defined and system defined Exceptions.

(d)    Explain PL/SQL sub programs. Discuss the difference between functions and procedures.

(e)    What is trigger ? How trigger executes ? How to disable triggers ?

(f)    Explain the Sql * Import utility.

5    Answer the followings : (any four)    12

(a)    List out cursor Attributes and their usage.

(b)    Write syntax to create a sequence and explain the keywords.

(c)    What is view ? How to create views ?

(d)    How to create a table from already existing table ?

Give appropriate example.

(e)    What is difference between Grant and Revoke commands ?

SB-1442]    2    [ 2400 ]

Attachment: veer-narmad-south-gujarat-university-2011-b-c-a-computer-application-28232-1.pdf

Earning:   Approval pending.