Saurastra University 2006 B.C.A Computer Application S/WEngg& Oracle Server - Question Paper

SP-1888] one [Contd..
*SP-1888*
SP-1888 Seat No.__________
B. C. A. (Sem. IV) exam
April / May – 2006
S/W. Engg. & Oracle Server
Time : three Hours] [Total Marks : 100
1 Attempt any 4 : 20
(a) discuss different field kinds in oracle.
(b) What is privilege? discuss GRANT and REVOKE in
detail.
(c) What is constraint? discuss different constraints in
detail.
(d) Justify ORACLE as an RDBMS.
(e) define various kinds of SQL statements. discuss
DDL statements in detail.
2 Attempt any 4 : 20
(a) What is cursor ? discuss the use of explicit cursor with
suitable example.
(b) discuss Varray with example.
(c) discuss Group By... Having with example.
(d) What is join? discuss different kinds of joins with
example.
(e) What is transaction ? discuss the use of Rollback,
Commit and Savepoint.
3 (a) Differentiate subsequent terms : (any two) 6
(i) Procedure V/s function
(ii) Nested Tables V/s Varray
(iii) SQL V/s PL-SQL.
(b) discuss subsequent functions : 4
(i) To_DATE ( )
(ii) DATE_DIFF ( )
(iii) DECODE ( )
(iv) ROUND ( ).
(c) Solve the subsequent queries based on subsequent tables :
(i) Faculty_Master : Fac_Code N (3)
Fac_Name C (20)
(ii) Subject_Master : Sub_Code N (3)
Sub_Name C (20)
(iii) Time-Table : Class_name C (15)
Sub_Code N (3)
Fac-Code N (3)
(1) List the names of subject for class “BCA Sem-4”.
(2) List the names of subjects taught by “Prof. Sharma”.
(3) List the name of Faculties taking lectures in “BCA
Sem-2”.
(4) List the name of subject with lowest lecture.
(5) List the name of faculties and subjects taught by
them.
(6) List name of faculties who takes more than three
subjects.
4 Attempt any 2 : 20
(i) discuss subsequent operators with example :
(a) ranging from
(b) Like
(c) Exists
(d) In
(e) Any.
(ii) List database processes in Oracle and discuss any five.
(iii) discuss the memory structure of oracle in detail.
5 Attempt any 4 : 20
(a) discuss different software myths and the reality in S/w
engineering.
(b) What is software engineering? discuss the waterfallmodel
(c) explain the OOD in S/W Engineering
(d) define the cocomo model
(e) Write a note on Software Realibility and Quality
Assurance.
______________
SP-1888] two [ 700 / 15-25 ]

Earning:   Approval pending.