CS403 Current Final term Paper Fall 2013 Shared by Star File 6

My CS_403 paper today

paper was average

most MCQs were from past paper & quizzes

Some subjective which I remember

Q1. Checkpoint makes the recovery procedure efficient. how RM will go back to start the

transaction.

Q2. Course (CourseNo, Ctitle, InstructNo)

Instructor (InstructNo, InstructName, InstructDept)

 denormalize the above relations to one form back? 

Q3. It is a good approach to create an index on non-key attribute. 

 Q4. Give four reasons that results in the failure of database transactions.

 Q5. Create a view named ‘STUDENT_DETAILS’ on ENROLMENT table which will show STD_ID and STD_NAME of those STUDENT, who belongs to KARACHI and MULTAN.

ENROLMENT (STD_id, COURSE_ID, STUDENT_NAME, CITY)

Q6. A candidate is applied for a study program in XYZ University. We have the relation to save his / her data in table Candidate-Info. 

Candidate can apply for more than one campus for a single degree program. choose control tools appropriate for each attribute of table. Controls / Tools list is as under;

list dia gia tha 

Your answer format is given below;

Attribute Name -> Tool Name

Fields of table are as under;

Candidate-Info (Candidate-name, Gender, Candidate-picture, Campus-selected, Program)

Q7. create a table on Employ along with 3 attributes and datatypes

Q8. create view syntax. 

Q9. Dif b/w RAID & tape 

Q10. analyze the statement
                 “it is a good approach to create an indexes on non_key attribute “.