CS403 - Data Base Managment System Final Term

Here is my CS403 Paper....
MCQS were from past papers 70%
These are questions which i remember


write 2 similarities between materialized views and indexes?
What is the purpose of testing DB syatem?
Why fixed length files are advantageous over variable length files?
Give and explain the LIKE clause?
How attributes are related to eentities?
What is the purpose of processing of database usage authority?
Write 5 features of views?
When the GROUP BY clause is used?
When is the LOST UPDATE is used?

Here is my CS403 Paper....
MCQS were from past papers 70%
These are questions which i remember
[You must be registered and logged in to see this link.]

write 2 similarities between materialized views and indexes?
What is the purpose of testing DB syatem?
Why fixed length files are advantageous over variable length files?
Give and explain the LIKE clause?
How attributes are related to eentities?
What is the purpose of processing of database usage authority?
Write 5 features of views?
When the GROUP BY clause is used?
When is the LOST UPDATE is used?

Briefly describe any two properties of Transactions? 2 Marks

State the two conditions which are imposed on candidate key? 2 Marks

How many places to the right of the decimal can be stored in a CURRENCY data field? 2 Marks

Name the two types of caching that are commonly used in personal computers? 2 Marks

What is “Data Definition"? 3 Marks

What is the general purpose of using DML commands? 3 Marks

Write the salient features of Indexed sequential files? 3 Marks

What effect can be occurred if a transaction lacks durability? 3 Marks

Briefly explain super key in relation with primary key. 5 Marks

Write a statement to create a table named "Person", with four columns. The column names will be "LastName", "FirstName", "Address", and "Age". 5 Marks

What is a transaction and what are ACID properties? 5 Marks

Explain the technique of RE-HASHING? 5 Marks
[You must be registered and logged in to see this image.]