CS403 Current FinalTerm Paper 25 August 2016

MCQs 20% past sy thy, subjective mein Queries related question ziyada thy.

1) Doctor(D_ID,D_PHONE) (5marks)
MEDICINE(M_CODE,DESCRIPTION)
I. Create unique index on table Doctor on D_ID
II. Create unique index on table MEDICINE on (M_CODE,DESCRIPTION)

2) What are the two primary modes of the locks?differentiate between shared lock and update lock. (5marks)

3) relation 1st normal form mein dia tha usko 2NF mein convert krna tha (5)

4) CREATE FURNITURE TABLE, CREATE VUDTUDENTS TABLE...rewrite given create command. (3 marks)

5) what are two types of horizontal portioning? (2 marks)

6) Write two important features which must be ensured in input forms.(2)

7) Write sql query to find those employees whose age is between 25 and 40 (2 mrks)

8) In which situation check points needs in database.(2)