1
LOYOLA COLLEGE (AUTONOMOUS), CHENNAI 600 034
M.C.A.DEGREE EXAMINATION COMPUTER APPLICATIONS FIRSTSEMESTER APRIL 2017
16PCA1MC05- DATABASE MANAGEMENT SYSTEMS
Date: 05-05-2017 Dept. No. Max. 100 Marks
Time: 09:00-12:00 PART A Answer ALL questions 10 X 2 20
1. What is the need to develop database system?
2. List the parts of SQL.
3. Define entity set.
4. What is normal form of table?
5. Define Digital signature.
6. What are stored across data dictionary?
7. Give the types of ordered indices.
8. Write the steps of query processing.
9. What are the basic operations of transaction access?
10. What is lock table?
PART B Answer ALL questions 5 X 8 40
11. Write note on view of data.
Or Describe various integrity constrains of relational schemas.
12. Elucidate on the representation of constraints on ER enterprise schema.
Or Write short note on 3NF with example.
13. Describe the fundamentals of web.
Or Illustrate about fixed and variable record organization of files
14. Write note on tree indexing of files with example.
Or Describe the evaluation of expressions.
15. Write note on the following transaction properties:
Serializability
Recoverability.
Or What is data buffering? Explain the methods of managing the same.
2
PART C Answer any TWO questions 10X2=20
16. Explain the mathematical representation of a table and its operations.
Discuss the following with example: Dynamic SQL ODBC
17. Write note on decomposition using multivalued dependency.
Explicate on application data security.
18. Elaborate all the algorithms of selection operations.
Explain lock-based protocol of concurrent execution.