Scribd
Upload
59 views2 pages

G - 3 7 3 2 S Eco N D Y Ear B. C. A. (Sem - I LL) E X A M in A Tio N Relational Database Management System

This document appears to be an exam question paper for the subject "Relational Database Management System" for the Second Year BCA program. It contains multiple choice and short answer questions testing knowledge of relational database concepts like self joins, nested tables, keys, SQL statements, aggregate functions, joins, and PL/SQL concepts like packages, control structures, and functions. It also includes questions requiring explanations of cursor handling, exception handling, and Codd's rules for relational databases. Students are required to write stored procedures and functions to manipulate sample tables for distributors, items, and item quantities.

Uploaded by

Pratiksha Parmar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
59 views2 pages

G - 3 7 3 2 S Eco N D Y Ear B. C. A. (Sem - I LL) E X A M in A Tio N Relational Database Management System

This document appears to be an exam question paper for the subject "Relational Database Management System" for the Second Year BCA program. It contains multiple choice and short answer questions testing knowledge of relational database concepts like self joins, nested tables, keys, SQL statements, aggregate functions, joins, and PL/SQL concepts like packages, control structures, and functions. It also includes questions requiring explanations of cursor handling, exception handling, and Codd's rules for relational databases. Students are required to write stored procedures and functions to manipulate sample tables for distributors, items, and item quantities.

Uploaded by

Pratiksha Parmar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

//VN SGU .AtoZm ath.

com - Result, Syllabus, Question Paper, Program s o f BCA, BBA

G -3 7 3 2
S econ d Y ear B. C. A. (Sem. I ll) E xam in ation
N ovem b er / D ecem b er - 2014
R elation al D atab ase M anagem ent S ystem
Time : 3 Hours] [Total M arks

In stru ction

•ft* wtRc-t Putinttu«fl §TRqtfl m* shu?** «w 4l


Fillup strictly the details of signs on your answer book
Name of the Examination :
Second Year B. C. A. (Sem. Ill)
Name of the Subject

Relational Database Management System (/


Student’s Signature
^-S u bject Code N o .: 3 7 3 2 ♦-S ection No (1.2 ..

(2) M arks are indicated to the r ig h t side of each question

Answer following in short : (any seven )


(i) W hat is self join ? _))
(ii) W hat is nested table ?
(iii) W hat is (Jifference between G rant and Revoke ?
(iv) E xplain m inus and union clause.
(v) W riite syntax of N ested If conditioinal statem ent
(vi) W hat is equi join ?
(vii) List out D.VIL statem ents.
(viii) Explain types of keys.

ver following in detail: (any tw o) 14


E xplain Cursor for loop. Discuss cursor handling steps.
Discuss cursor attributes.
E xplain exception handling providing appropriate example

Answer following : (any tw o)


(a) E xplain types of SQL statem ents w ith appropriate
example.
(b) E xplain different aggregate functions.
(c) Discuss types of joins. Provide their exam ples and
explain.

G-3732] 1 [Contd...
http://CM AT.A toZm ath.com - CM AT M CA, M B A Online Exam Preparation
//VN SGU .AtoZm ath.com - Result, Syllabus, Question Paper, Program s o f BCA, BBA

W rite note on following : (any three)


(a) Codd's law. E xplain any th ree of them .
(b) W hat is package ?
(c) Control stru ctu res in PL/SQL.
(d) Oracle Functions

Do as directed : (any tw o)
Consider following tables
D istributor (dno, dname, addr, phone)
Item (INo, nam e, color)
Dist-Item (dno, INo, Qty)
(a) Create a procedure which retu r Item which
is sold m axim um.
(b) Create a function which dis of Item (return
nam e of item ) for given
W rite PL/SQL block \to strib u to r nam e, Item
nam e and Qty. s<

G-3732] 2 [ 4200 ]
http://CM AT.A toZm ath.com - CM AT M CA, M B A Online Exam Preparation

You might also like