Veer Narmad South Gujarat University 2011-4th Sem B.C.A Computer Application SB-1467 RDBMS : 403 ( old ) Second Year ( ) - Question Paper
SB-1467
Second Year B. C. A. (Sem. IV) Examination
March / April - 2011
(Old Course)
Time : 3 Hours]
[Total Marks : 70
Instructions :
Seat No.:
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. 4)
Name of the Subject:
403 : RDBMS (Old)
|
-Subject Code No.: |
|
-Section No. (1,2,.....): Nil |
(2) Question 1 is compulsory.
Student's Signature
(3) Figures to the right indicate full marks.
(a) What is LOGIN-DENIED and VALUE-ERROR exception handlers is raised ?
14
(b) What are the independent objects of oracle ?
(c) What is Active Data Set ?
(d) What is DCL ? What is the function of DCL ?
(e) What is ON DELETE CASCADE ?
(f) How to drop primary key in a table ?
(g) How to modify a column size in a table which is created before ?
Answer following : (any two) 14
(a) Explain the concept of DBA and discuss the duties of DBA.
(b) What is Data constraints ? List out all types of constraints.
(c) What is range searching and pattern matching operators in Oracle ?
3 Answer following : (any two) 14
(a) What is PL/SQL ? Discuss the advantages of PL/SQL in compare to SQL.
(b) Describe the concept of cursors. Explain the types of cursors.
(c) What are the different types of tables ? Explain the process of creating nested table.
4 Answer following : (any two) 14
(a) Explain the concept of functions and procedures.
(b) Discuss the concept of exception. Explain the named exception in detail.
(c) Describe the concepts of package. Explain the object-oriented features of PL/SQL.
5 Answer following : (any two) 14
(a) Consider following table :
Employee (Eno, Ename, Date-of-birth, Salary)
Write a procedure to display names of employees who are earning less than 20,000 and born before 30 years.
(b) Create a trigger which log the transaction perform on above table and store detail in log-table.
log table (log-no, log-date, transaction-type)
(c) Create a function which return name of employee who is youngest among all from above table (Refer (b).
SB-1467] 2 [ 2800 ]
|
Attachment: |
| Earning: Approval pending. |
