B.C.A. DEGREE EXAMINATION, NOVEMBER 2017
Third Semester
Computer Application
DATABASE MANAGEMENT SYSTEMS
(CBCS 2011 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 X 2 20)
Answer all questions.
1. What is meant by Data Abstraction?
2. What is a Relationship set? Give an example.
3. What is meant by Temporal data?
4. What is the purpose of Normalization?
5. What do you mean by Client-Server computing?
6. Define Transaction.
7. What is meant by Data Integrity?
8. What are the advantages of View?
9. Write any Four DDL commands.
10. What is a package?
Sub. Code
1BCA3C1
AFC-10371
2
Wk ser
Part B 5 25)
Answer all questions choosing either or
11. Explain the Database Languages.
Or
Explain E R diagrams with an example.
12. Explain First Normal form with an example.
Or
Explain the Multivalued Dependencies with an
example.
13. Explain the Transaction-Server process structure.
Or
Explain the various Network types.
14. Explain with an example how will you create a
Table.
Or
How will you create and delete a User? Explain
with an example.
15. How will you create a function and execute a
function? Explain.
Or
Explain the various types of Triggers.
Part C 10 30)
Answer any three questions.
16. Explain
Purpose of Database Systems
E-R Design issues.
AFC-10371
3
Wk ser
17. Explain
3NF
BCNF.
18. Explain the Distributed Data storage.
19. What is Synonym? Explain the creating and Renaming a
Synonym with an example.
20. Write a procedure to print the multiplication Table.
————————