3130 University of Sargodha BS 7" Term Examination 2016 Subject: Computer Science Paper: Advanced Databases (CS-371)
Discussion
Ask a question about this paper, or help someone else with theirs. Answers are emailed to whoever asked.
No questions yet — be the first to ask.
Paper text
3130
University of Sargodha
BS 7" Term Examination 2016
Subject: Computer Science Paper: Advanced Databases (CS-371)
Time Allowed: 2:30 Hours
Maximum Marks: 80
Objective Part Compulsory
O: 1, Write short answers of the following questions? (2*16=32)
usta
Il
That are the chaniem used is lock address
ata from or write cata to the dis
How can hashing be used to construct an index?
*IV.
What are intention locks?
VI.
When are latches used?
ustadni.com
What are the differences among primary, secondary, and clustering
indexes?
AVII.
VIL.
UX.
X.
What type of lock is needed for insert and delete operations?
What risks are associated with sql injection attacks?
What preventive measures are possible against sql injection attacks?
What is a statistical database?
What is a symmetric key algorithm for key-based security?
XII.
XHI.
What is the public key infrastructure scheme?
What type of information does a digital certificate include?
Discuss the techniques for allocating file blocks on disk.
XV
What is the difference between a file organization and an access method?
YVI.
Discuss the UNDO and REDO operations and the recovery techniques that
use each.
Subjective Part
Attempt any four questions out of six questions: (4*12=48)
i
3. Describe the six clauses in the syntax of an SQL retrieval query. Show
what type of constructs can be specified in each of the six clauses. Which
of theolt clauses are required and which are optional?
I[9CHP3. piscuss the immediate update recovery echnique in both single-user and
usta multier ery ror-mens. What any tidi antagos and disadsunages o
immediate update?
*How does multilevel indosing improve the efficiency of searching GOT
45. What is peritioned hashing? How does it wok What atla timitations?
6. Why is accessing a disk block expensive? Discuss the time components
involved in accessing a disk block.
V. Discuss how each of the following constructs is used in SQL?
a. Nested queries. b. Joined tables and outer joins.
c. Triggers.
visit website: ustadni.com