0
Database Management System : Question Paper Jun 2014 - Computer Engineering (Semester 3) | Gujarat Technological University (GTU)

Database Management System - Jun 2014

Computer Engineering (Semester 3)

TOTAL MARKS: 100
TOTAL TIME: 3 HOURS
(1) Question 1 is compulsory.
(2) Attempt any four from the remaining questions.
(3) Assume data wherever required.
(4) Figures to the right indicate full marks.
1 (a) Explain disadvantage of conventional file-based system compared to Database management system.(7 marks) 1 (b) Explain Entity Relationship model with example.(7 marks) 2 (a) Write a short note on Relational algebra.(7 marks) 2 (b) What are integrity constraints? Explain various type of integrity constraints with suitable example.(7 marks) 2 (c) Explain three level architecture of DBMS.(7 marks) 3 (a) What is normalization ? Why normalization process is needed? Explain 1 NF, 2NF and 3 NF with example.(7 marks) 3 (b) What is deadlock ? Explain deadlock detection and prevention policies.(7 marks) 3 (c) Explain conflict serializability and view serializability.(7 marks) 3 (d) What is decomposition? Why is it required? Explain the difference between lossy decomposition and non-loss decomposition with example.(7 marks) 4 (a) Write short note on query processing.(7 marks) 4 (b) Explain log-based recovery and shadow paging technique.(7 marks) 4 (c) Explain different types of outer join with example.(7 marks) 4 (d) Explain time stamp based protocols.(7 marks) 5 (a) Write A PL/SQL block to print the sum of Numbers from 1 to 20.(7 marks) 5 (b) Explain DDL, DML and DCL syntaxes with example.(7 marks) 5 (c) Write A PL/SQL block to print the given number is Odd or Even.(7 marks) 5 (d) Explain Aggregate, Date and String function with example.(7 marks)

0  upvotes

Next up

Read More Questions

If you are looking for answer to specific questions, you can search them here. We'll find the best answer for you.

Search

Study Full Subject

If you are looking for good study material, you can checkout our subjects. Hundreds of important topics are covered in them.

Know More