CS403 Current Final term Paper Fall 2013 Shared by Raheel File 7

Total 40 MCQs Mostly from MOAZZ file and mid
Total questions 52

Date : March 7,2014 Time : 11.00 am.
Subjective questions:
1) Write SQL command to delete a table(both table and data inside it) (2 marks)
2) Write steps in semi-join? (2 marks)
3) Write two benefits of views? (2 marks)
4) Write 3 operation/functions performed by CREATE Table command? (3 marks)
5) Rank the following as 'good' , 'average' , 'worse' in terms of space utilization
Linear probing
Chaining
Re-hashing (3 marks)
6) Table COMPANY and columns are COMPANY-NAME, ORDER-NUMBER
Write SQL command to display COMPANY-NAME in reverse alphabetical order? (3 marks)
7) Describe pessimistic and optimistic modes of locks? (3 marks)
8) Name two primary modes of locks? Differentiate between shared and update lock?
(5 marks)
9) A Table was given, to insert values in it? (5 marks)
10)What is file protection? Name its types? (5 marks)
11)Write reasons for using de-nornmalization? Give 3 real world scenarios of using it?
(5 marks)
12)What is common feature between RAID and Tape drive? (2 marks)