Advanced Database Management System - Tutorials and Notes: CS2255 Database Management Systems question paper - May/June 2014

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Thursday, 24 July 2014

CS2255 Database Management Systems question paper - May/June 2014

CS2255 Database Management Systems question paper - Nov/Dec 2013 / Anna University Previous Year 2013 Exam Questions / Anna University Previous Year 2013 Computer Science and Information Technology Question Papers / CS 2255/CS 46/CS 1254/080250009/10144 CS 406 — Database Management Systems Question with Answers

Click on the links for answers;



Question Paper Code : 51345
B.E./B.Tech. DEGREE EXAMINATION, MAY/JUNE 2014.
Fourth Semester
Computer Science and Engineering
CS 2255/CS 46/CS 1254/080250009/10144 CS 406 — DATABASE MANAGEMENT SYSTEMS
(Common to Information Technology)
(Regulation 2008/2010)

(Common to PTCS 2255 – Database Management Systems for B.E. (Part-Time) Third Semester – Computer Science and Engineering – Regulation 2009)

Time : Three hours                                                             Maximum : 100 marks

Answer ALL questions.
PART A — (10 × 2 = 20 marks)

1. What are the three levels of data abstraction?
2. What is an entity?
4. What is a trigger?
8. What is meant by serializability?
9. Describe Tuning.
10. What are ordered indices?

PART B — (5 × 16 = 80 marks)

(ii) Explain the architecture of a database system. (10)
Or
(b) (i) Write a note on database languages. (8)
(ii) Draw an ER diagram corresponding to customers and loans. (8)
12. (a) Explain the various operations in relational algebra with examples. (16)
Or
(b) Write a note on:
(i) Embedded SQL. (8)
          (ii) Distributed databases. (8)
13. (a) Explain Boyce Codd NormalForm and Fourth Normal Forms with suitable example. (16)
Or
(b) Explain first, second, and third normal forms with suitable example. (16)
14. (a) (i) Write a note on SQL facilities. (8)
(ii) With a neat sketch explain the states of a transaction. (8)
Or
15. (a) (i) Explain magnetic disk and tertiary storage. (8)
(ii) Write a note on Hashing. (8)
Or
(b) Explain the steps involved in query processing. Give examples. (16)

***********




Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents