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?

3. Define a super key.

4. What is a trigger?

5. Define Normalization.

6. What are functional dependencies?

7. Define deadlock.

8. What is meant by serializability?

9. Describe Tuning.

10. What are ordered indices?

PART B — (5 × 16 = 80 marks)

11. (a) (i) What are thefunctions of database administrator? (6)

(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

(b) (i) Explain the ACIDproperties of a transaction. (8)

(ii) Describe two phase locking protocolwith examples. (8)

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)

***********

CP7202 - Advanced Databases May/June 2014 Question Paper

CP 7202 Advanced Databases question paper – May/June 2014

CP 7202 Advanced Databases question paper – May/June 2014 / Anna University Previous Year Exam Questions / Anna University Previous Year M.E. M.Tech. Computer Science and Information Technology Question Papers / Previous Year Anna University Exam Questions with Answers

Question Paper Code : 63294 M.E./M.Tech. DEGREE EXAMINATION, MAY/JUNE 2014 Second Semester Computer Science and Engineering CP 7202 — ADVANCED DATABASES (Common to Computer Science and Engineering (with Specialization in Networks) and M.Tech. Information Technology) (Regulation 2013) Time: Three hours                                                       Maximum: 100 Marks Answer ALL Questions PART A — (10 × 2 = 20 Marks) 1. What is the advantage of parallelism? 2. What is the difference between parallel system and distributed system? 3. Give examples for object relational databases. 4. How is object database differentiated from relational database? 5. What is meant by spatial database? 6. Define Semantics 7. What is mobility? 8. How is mining different from searching? 9. What is structured data? 10. What is XML Schema? PART B — (5 × 16 = 80 Marks) 11. (a) Define Parallel databases. Explain the inter and intra query parallelism. (16) Or (b) How are the transactions are handled in distributed database? Explain. (16) 12. (a) What are the object relational features in SQL? Explain. (16) Or (b) (i) Write in details about ODMG model with ODL and OQL (ii) Distinguish object oriented and object relational databases 13. (a) What are spatial data structures? And explain any two (16) Or (b) Discuss the design principles for Active rules. (16) 14. (a) Write detailed notes on Concurrency control in mobile database. (16) Or (b) Explain any two retrieval models used in Information Retrieval. (16) 15. (a) Give details about approaches used to store XML documents in database. (16) Or (b) Describe Cloud storage architecture and Big-data storage analysis with suitable example. (16) _____________________________

 

Handling of Network Partition Failure

Handling of Network Partitions by 2PC / Two Phase Commit Protocol handling Network Partitions / How does 2PC handle Network Partition failure?

Figure - Network Partition - Single network broken into two

Handling Network Partitions

It refers to the failure of a network device that leads to the break of one network into two. For more information, visit Network Partition definitions in Wikipedia and Symantec sites.

During the execution of a transaction T, if any Network Partition happens, then there are two possibilities of execution of transaction T.

Possibility 1

The coordinator site and all the other participating sites may belong to one of the partitions. That is, no sites are disconnected from the other physically. For this case, we do not need to worry. The reason is, all the components executing transaction T are available in one partition. Hence, 2PC does not have anything to do with this failure.

Possibility 2

The coordinator site and all the other participating sites may belong to several partitions. In this case, the Network Partition affects the execution.

Now, the sites that are in a partition which is disconnected from coordinator execute 2PC for handling coordinator failure.

The sites that are in a partition along with the coordinator execute 2PC for handling site failure.