B.Sc. DEGREE EXAMINATION, APRIL 2018
Fourth Semester
Computer Science
DATABASE MANAGEMENT SYSTEM
(2016 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 X 2 20)
Answer all questions.
1. What are the different views of data?
2. What do you mean by weak entity set?
3. Define the term Normalization.
4. What is called Multi-valued dependency?
5. Define Interquery-parallelism.
6. What is called Heterogeneous database?
7. Write down the syntax to create a table,
8. Specify the types of user privileges.
9. What is the use of function in PL/SQL?
10. How do you create CURSOR in PL/SQL?
Sub. Code
42
CP-8764
2
Wk 11
Part B X 5 25)
Answer all questions.
11. Explain the features of Data Base Management
Systems.
Or
Explain E-R model with neat diagram.
12. Write short notes on functional Dependency theory
with suitable example.
Or
Describe the Database design process.
13. Compare and contrast: Centralized and Client-
Server architecture.
Or
Discuss on Distributed transactions with example.
14. How will you modify, rename and drop a table?
Explain with syntax and example.
Or
Explain with example, how sequences are created
and deleted.
15. Explain PL/SQL triggers with a sample code.
Or
Give a detailed account on packages in PL/SQL with
suitable example.
CP-8764
3
Wk 11
Part C X 10 30)
Answer all questions.
16. Detail on Object based and semi structured
databases.
Or
Explain in detail about the Database users and
architecture.
17. Explain Normalization technique using different
Normal forms.
Or
Describe I/O Parallelism with neat sketch.
18. Explain the various DML commands with syntax
and example.
Or
Write a program to create a stored procedure to find
the sum of values in a column of a given table.
————————