Jawaharlal Nehru Technological University Hyderabad 2007-2nd Sem M.C.A Computer Aplications Iester s ,- - Question Paper

Code No:R6-31/MCA
M.C.A III-Semester Examinations, December-2007.
DATABASE MANAGEMENT SYSTEMS
Time : three hours Max.Marks:60
ans any 5 ques.
All ques. carry equal marks

1. a) discuss the different steps in designing a database.
b) discuss 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) elaborate the SQL constructs to replace the structure of a table?

3. elaborate the range variables in SQL? How can you provide names to output columns in a query that
Are described by arithmetic of string expressions? What support does SQL offer for string trend
Matching.

4. a) What is meant by functional dependency are more general dependencies in data base design?
b) What is meant by “anomaly”? discuss the insert, delete and update anomalies.

5. a) describe a transaction provide 1 good example.
b) elaborate ACID properties? discuss.

6. a) What is the function of lock manager?
b) define 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? discuss why we need indexes.

8. a) How does a hash-based index handle an equality query?
b) explain 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.


#######

Earning:   Approval pending.