Download Model question papers & previous years question papers
|
Posted By: madhavi Member Level: Silver Posted Date: 21 Jun 2008
|
2007 Jawaharlal Nehru Technological University M.C.A Computer Aplications III semester Examinations , December -2007 Question paper
|
|
|
Code No:R6-31/MCA
M.C.A III-Semester Examinations, December-2007.
DATABASE MANAGEMENT SYSTEMS
Time : 3 hours Max.Marks:60
Answer any FIVE questions
All questions carry equal marks
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 of 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.
a) Digital signatures
b) World Wide Web
c) Web Security
8. Write short notes on the following:
a) Multimedia
b) Goals of computer Network
c) Physical layer.
#######
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.