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
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
