Download Model question papers & previous years question papers
|
Posted By: kishore Member Level: Gold Posted Date: 18 May 2008
|
2007 Jawaharlal Nehru Technological University M.B.A DATABASE MANAGEMENT SYSTEMS Question paper
|
|
|
1.a) Explain the various steps in designing a database.
b) Explain the terms entity, entity set, attribute and key.
2.a) What SQL construct enables the definition of a relation? What constructs allow modification of relation instances?
b) What are the SQL constructs to modify the structure of a table?
3. What are the range variables in SQL? How can you give names to output columns in a query that are defined by arithmetic or string expressions? What support does SQL offer for string pattern matching.
4.a) What is meant by functional dependency are more general dependencies in data base design?
b) What is meant by “anomaly”? Explain the insert, delete and update anomalies.
5.a) Define a transaction give one good example.
b) What are ACID properties? Explain.
6.a) What is the function of lock manager?
b) Describe the lock table and transaction table in detail.
7.a) What is a index on file of records?
b) What is search key for index? Explain why we need indexes.
8.a) How does a hash-based index handle an equality query?
b) Discuss use of hash function in identifying a bucket to search.
Return to question paper search
|
|
|
Submit Previous Years University Question Papers and
make money from adsense revenue sharing program
Are you preparing for a university examination? Download model question papers
and practise before you write the exam.