Sunday, August 15, 2010

CS403 Final Paper 2010

Question#1             3 marks:

SELECT * FRO Persons
WHERE Firstname Like “% da %”;

What does the above statement returne?


Question#2             3 marks:

What is the difference between Primary key and a unique key with reference to clustered and non-clustered indenses?


Question#3             5 marks:

Create a simple index, named “Personal Index” on the LastName field of the person table?


Question#4             5 marks:

Writing the basic syntax of adding a record to a table.


Question#5             5 marks:

Give 4 simlarities between Materialzed views and indexes.?


Question#6             3 marks:

How do the stamping approach works to give priorities to the transactions?


Question#7             2 marks:

Name the primary key models for taking locks?



Question#8             2 marks:

State any two problems that can come up as a result of inconsistent data base?

No comments:

Post a Comment