BSC IV SEM COMPUTER SCIENCE 2013.PDF

Viewer
Transcript

SAC/Printed Pages- 06

// 4 // (xiv)

‘9(pcii crrivti co6citcil t — creiNi (31) M
(xv)

7trk .1"-41F \ ►1 fief c6).-1 (4) 3IT43F (31) .ti +1 (() -Qi1
crqi t? P.-0f. 1z4q{ What is Referential Integrity? 312/4T / OR .3qi6vr -ffft-d trit4TrfOu 9)crqmef ft) Define functional dependency with example. DML '4TIT ? What is DML. 312141- / OR trq- .ER trutff ftvreft fgtrtr Write short note on save point.

v.4.

Z7[1- 01R-Ir Tiftqf ftccult fA!qt Write short note on type casting.

aiamt / OR Erftlii-Rm mfir Define nesting of methods.

-4Fki-Tr 3ttr5..42z-

—

(4 x 5 =20) ei ■ ix-14)i4 31'47

Section — B Short Answer Type Questions V.2.

413 —12 — 41 B.SC. FOURTH SEMESTER EXAMINATION APRIL — MAY 2013 SUBJECT: COMPUTER SCIENCE DATA BASE MANAGEMENT SYSTEM (SQL PROGRAMMING) & JAVA Max. Marks: 85 Time: 3hrs. Min. Marks: 28 3T TI7ff ef cF)•1 I 3iFiqrd f t 7-C-tT Urri T qvii7 Trtr ft All questions are compulsory. Marks are indicated against each section. WiS — 3T TfgrAlEd 31V9*

Section — A Objective Type Questions 'CT. 1 .

gl fir

l:—

(1 x 15 = 15)

Choose the correct option:

itr .4r -5rf --zrr Tr

WOa

(3T)

(r)

uici

6d1-II

gi * — (4) 51e1 LN) ctrl

.*1 -Eer

Which of the following is not an advantage of the data base approach(b) Data independence (a) Increased security (d) None of the above (c) Elimination of data (ii) fti9 T&'7

trftlefff 6101 * f f),31100 star sier

(1)6I 30 ,W

7*ff —

What defines how and where data are organized in physical data storage? (b) External schema (a) Internal schema (d) None of these (c) Conceptual schema P.T.O.

// 3 // Ti.-414a •t— (4) , R*41

// 2 // 3TTETTi (iii) 4 NF 1*--1 (4) Tr''r (31) 147411-tqf fa 44 (T) (() \3 L-N)(tvi 4 t (P)i 9-et 4 NF is based on (a) Functional dependency (b) Multivalued dependency (d) None of the above (c) Join dependency -$`t f=r -rf'44t * — (iv) tFro ftRzli 'er-t)1R-N-14 (31) 6ICI P5441 4 Tft-a-r (() 51dI 7-4tR:f 51t1 3ITrit4VM (4) zat4Tr Tit Disadvantages of file system to store data is : (a) Data redundancy & inconsistency (b) Difficulty in access data (c) Data isolation (d) All of the above t— RH (v) (4) 1i 1/ t14111 4z1,l i (31) (4) ‘34Nlctrt ctU -161 (Ti.) t3ft 7F WHILE Loop is a feature of (b) PL/SQL (a) SQL (d) None of these (c) DCL (vi)

t cA-f 3ttr --F TT tiic tred7 ) 31TFZ7 (4) (31 3114((i) Following is not a oracle Grant privilege (b) Insert (a) Alter (d) Update (c) Sort

I4 *— (vii)vncil r Tr— tuftrr rc (31) (&) *-1 Java's multithreading is platform (b) independent (a) Dependent

w-a-d

*

(viii) 149. # (3T) (44 •RtE (TT) Following is not a state of thread (b) Running state (a) Dead state (d) New born state (c) Package state *— 1-f 41). tI t vtil*-1 <)-I) #2-ff (31) *I cq 3R1?.4 Both methods sleep and join throws interrupted exception (b) False (a) True (x)

rct) Re)m-iqi 3isfuitz7 t— Following is not a relational operator (31) > > (4) <

<>

cl) re (tt xi) 'ct) `t-I civi 1 ch-i (re TR crel zr 370T *-cilct) cp,44 f (Ti") 3TER (.) (31) ftc1 keyword to invoke The subclass constructor uses the the constructor method of the super class (a) Sleep (b) Super (c) Upper (d) None

.qTrer ;rwR (17 37T-o4 (31) *I cu Overloaded methods must have the same return type (b) False (a) True (xiii)Rftft4 siei

r 3t14---4z zr4-E1 4c

4

crom

zcrtrr

ct,

t *'i `-K (() 'Tr& (T) 4)1-1(1 (31) Primitive data types may be converted into object types by classes using (d) Wrapper (a) Super (b) Sub (c) Final

(c) none P.T.O.

// 5 // ci,1/49d.•=a5+1

crzii

What is extending interface. 3TQTlT / OR 4.41

What is Visibility Control? (t4 cr)40 c-r-) 0-4 .er Tztzfrr T4 Explain stopping and blocking a thread? 3TeNT / OR antsql triv 7 Explain five APPLET tag. W35 — 4iti‘itAq (5 x 10 =50) Section — C Long Answer Type Questions cf.7.

3 ci ‘3416.01 Vritff E-R 415ci

tr4- 1 I

Explain E-R Model with suitable application. 3ieT'dT / OR 3NF 1 4NF 3itj Tff'0 quid '211 -tr I Explain 3NF and 4NF with example. A.B.

5Idl

f:710AZc U fttauft f -trz) I

Write details note on database triggers. 3T2r4T / OR PL/SQL AlOW th-OTff T cluk I Describe procedure and functions in PL/SQL. <47-51ei Tt-d-4--d TR ftTp- tccroft iftr.4 I Write detail note on control statement of JAVA. 3f2T4T /OR PL/SQL 311-4q -afft-TT 3'1-4ftIT WreW 7-4 cosi-51te c'tf'•-4 I Compare and contrast overloading and overriding methods? P.T.O.

// 6 //

Trro qu

q.10.

"''EN?Y?

Describe Different forms of inheritance with example. di al / OR

f41:9*

Th°1'

(3T) v-K qc.im

-1`1.1" -?)- —

N) zp-r f3r-&--9- 1-*7

Explain Following (a) Wrapper class (b) Using system package L11.

*11*D7c1 "Wr auk .erN4? Describe life cycle of a Thread? :Wei 41 / OR 71:1•U d Th`tr 71" TO7 tr (11,1 wi-311c W ccr') .irt4 t Trot Gi4 ticq41 ctrmi t1 HTML t)vi AzfR .31-N) 'efft I Develop an applet that receives three numeric values as input from the user and then displays the largest of the three on the screen. Write a HTML page and test the applet.

// 6 //