Education In Pakistan

Papers, Notes, Books & Help For Students

UPDATED EDUCATIONAL NEWS INTERVIEW HELP FOR ALL JOBS ONLINE BOOKS SCHOLARSHIPS AVAILABLE INTERNSHIP JOBS

Tag: VU CS403- DATABASE MANAGEMENT SYSTEMS FINALTERM solved unsolved past papers

VU CS403- DATABASE MANAGEMENT SYSTEMS FINALTERM solved unsolved past papers

VU CS403- DATABASE MANAGEMENT SYSTEMS FINALTERM Solved Unsolved Past Papers

CS403 Final term Ppr

 

 

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?

VU CS403- DATABASE MANAGEMENT SYSTEMS FINALTERM Solved Unsolved Past Papers

Education In Pakistan © 2016