Devi Ahilya University 2010 B.Sc Computer Science DBMS fundamentals - Question Paper
DBMS fundamentals paper 1
|
Roll No. |
B. Sc. IV SEMESTER [MAIN] EXAMINATION, JUNE - 2010
10413
Paper - II [DBMS Fundamentals]
Time : 3:00 Hr s.] [Max. Marks : 35
Note : AH THREE Sections are compulsory. Student should not write any thing on question paper.
: fr cffr arftcTRf 11 teTSff XTFT-T5f feRlf I
[Section - A]
This Section contains Objective type questions. Each question carries 1 Marks.
3 T 11 1 3T <?> WJ 11
Q. 01 Field is also known as -a) Entity c) Relationship fae WT TTcTT t -a) cTlcTl
b) Attribute
d) Record
b) <3? d)
C) ftetSFTCffa
Q. 02 Roll back and commit statements comes under which of the following category
a) Data Definition Language b) Data Control Language
c) Data Manipulation Language d) Transaction Control language
afft cf>te PlHfefRsf'cT cpf $ f$ 3TT t -
a) 'SId-l eHvri
c) 'Slcil
b) 'SICI e}Jc)ui
d) crl-'cjvr!
Q. 03 Tuple is used for -a) Row c) Domain
b) Coloum
d) Table
b) cteFf d) <H
dMe! cfT x3TRTl1T RbI vfRIT a)
c) >slH
Q. 04 Which of the following are operation of Relational Algebra -
a) Selection b) Cautesian product
c) Projection d) All of above
Pinfeed' 3 cf t 3TF&FFT t -
a) R-ldlH b) W&ff wWci
c) ikpf d) TPft
P.T.O.
Q. 05 Which is not an Aggregate function -
|
a) SUM |
b) |
MINUS |
|
c) MAX |
d) |
COUNT |
|
fFT 3 cf>fa THI 4kTCH t - | ||
|
a) T |
b) |
TTl-T |
|
c) |
d) |
. cf)|vdci |
This section contains Short Answer type questions. Each question carries 2 Marks. 3 cv3vTfta 11 2 3It' cfTT f!
Q. 1 Explain different types of file organization.
T#ef SIFThIM I
OR
Define Data, Database and D.B.M.S.
cr i
Q. 2 Explain DCL with example.
DCL cffr rftcr i
Define Database Application.
er-r >hhi4 i
Q. 3 Explain Entity and its types.
wrt i
OR
Explain Degree of Relationship. fM\ 3TN) RcmRw cfft I
Q. 4 What are the characteristics of RDBMS.
rdbms cf?r i
OR
Explain different types of Keys.
WfrK cF>t Keys I
Q. 5 Write the characteristics of SQL.
SQL cfft frwsff I
OR
Explain Boolean Operators of SQL.
SQL $ sffq i
Cont.
[Section - C]
This section contains Essay Type Questions. Each question carries 4 marks.
11 4 arVf cf>r 11
Q. 1 Explain database System Architecture.
*ilcil 3TTfprR cf#T TFT?n I
Explain advantages of DBMS over File Management System (FMS). wfcT Cf5t ePfT 3 DBMS wfrfrcTT I
Q. 2 Explain database development process.
I'ciercpfe riftter cfr
Explain various components of DBMS.
DBMS ii 3TcRfcff cfj|- I
Q. 3 What are different notation used in E-R model.
Design E-R database schema for a Banking system taking three entities customer, loan and account.
tfT E-R fviTTT fuRi'cfr sfcPfcT ZfTR, efPT c[ SfW:
VHfftWcl FT I
Q. 4 Explain Codd's 12 Rule.
Explain Normalization and its various forms.
felTFT 3?ft fRT Wff I
Q. 5 Explain join with its types.
fTT cfTt WRf rf%TT WITI
Write SQL statement to perform the following -Table : Student (rollno, name, city, fees, age, class)
i) Create table student. ii) List all the students who live in Indore.
iii) Find how much fees is collected, iv) List all B.Sc. student whose fees is more
than 4000
ftHfeited c fair SQL cfTt -
: Student (rollno, name, city, fees, age, class) i) # tifoT I ii) vH eft frfTZ 11
iii) ffefr tfter urt t, w tfr iv) fcrc fvSr
4000 3rfto 11
o
|
Attachment: |
| Earning: Approval pending. |
