08-09-2010, 10:37 PM
Short Questions
- What are the two ways to create a new view in your database?
- Briefly describe any two properties of transaction?
- What You Know about partial dependency?
- What is the major purpose of an INPUT FORM?
- Name any three of the important view types
- Write rules of inserting data into a table with the INSERT, VALUES statement?
- Briefly explain the mechanism of optimistic locking mode?
- Write SQL SELECT query that returns the first name, last name of the instructor, salary and gives each of them a number?
- Name the four basic file operations. Also write the similar SQL command against each of file operations?
- Write two situations of deadlock occurrence in context with transaction execution.