Current Paper of CS403 Database Management Systems 7 August 2010

[viki]

I am not responsible for any of the mistake made in the assignment solutions, MCQ's Solutions, GDB Solutions or any other solution which i provide the students of VU. I just try to help the students while giving the idea's Simply the rest of the work they have to do on there own. They must make the changes and then submit the solution

Current Paper of CS403 Database Management Systems Please Download the attachment file

[ANI]

Thank u soo much 4 providing such meaningful help...may god bles you...

[ANI]

Thank u soo much 4 such a meaningful help...may allah bless you...t.c

[viki]

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?

LONG QUESTION

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.