CS403 Current Final term Paper Fall 2013 Shared by Maria Ch. File 8

CS 403 MY today paper

DATA BASE MANGEMeNT SYSTEM

Describe Dense key index? (2)

Disuss DML satatemrnt which is used to add new rows ina table? (2)

Write SQL Comand to create a database named EMPLOY  2

 The given satament is true or false.A transcation is seen by the DBA as a series, or list, of actions.Justify your answer (2)

Write sql command to delete rows from a table CUSTOMER where the last name is HUMZA  (3)

The given satament is true or false A locking protocol is a set of rules whics are followed by by each

DATABASE index (3)

The given satament is true or false  It is a good apporch to create index on non key attributre.Justify your ansewer?  (3)

Write sql statement  that will insert 1 row to the table course that has  the following attribute

Course-id course-name  credit-hours (3)

Wt is a view? Write its general syntax and different syntax (5)

Data type of course -id course –name  is varcahr and credit hours data type int  study carefully the given realtion  and perfom a vertical partitioning on a STUDENT(stdid,sName,sphcgpa prname school

 mt marks mt sbs, clgName)        (int marks intsub, idclg, bmarks,bsubs) (5)

Give a populate relation name STUDENT  (5)

stdid	St Name	St Adress	Pr name	Std cgpa
St1020	Ali	Lahore	MCS	2.80
St1038	Anam	Karchi	BCS	2.78
St1015	Sohail	Sialkot	MCs	3.20
St1034	Tahir	peshwar	MIT	4.0
St1018	Maria	Islamabad	BIT	3.0

Write down output of the sql command above on the table.

SELECT PRNAME MIN(Std cgpa MinummumCGPA, Max(Stdcgpa) as

“Maximum CGPA”

FROM STUDENT

GROUP BY PRNAME

Page no 258 pur RAID waly topics ka table aya tha column mtch kerny k liy

A_RAID 0 To  F_ RAID 5 and dtament k  7 in ko matc kerna tha

GOD BLESS U

REMEMBER Me IN YOURS PRAYERS