CLICK HERE FOR VARIOUS NEW JOBS 
CLICK HERE FOR VARIOUS EDUCATIONAL NEWS 
CLICK HERE FOR NEW SCHOLARSHIPS 
CLICK HERE FOR ADMISSION NOTICES 
Click And Follow On Google+ To Get Updates
Please Wait 10 Seconds... OR You CanSkip

ADMISSION NOTICES
Scholarships

Scholarship-300x291

BUDGET 2014-15
budget_2014-2015
New Date Sheets
VU SOLVED ASSIGNMENTS
Recent Posts

Posts Tagged ‘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

ALL NEW RESULTS
Educational News

Updated Educational News

Categories
POSTS BY DATE
December 2016
M T W T F S S
« Sep    
 1234
567891011
12131415161718
19202122232425
262728293031