National Institute of Technology 2009 Post Graduate Diploma Computer Application Database - Question Paper

NATIONAL INSTITUTE OF ENGINEERING
DATABASE

All the ques. are compulsory. The 1st 5 ques. shall be of 16 marks every and the last ques. shall be of 20 marks.

Q1. define the differences in meaning ranging from the terms Relation and relation schema

Q2. Compare the use of embedded SQL with the use in SQL of functions described in a general-purpose of Programming language. Under what circumstances would you use every of these features?

Q3. discuss what is meant by repetition of info and inability to represent info. discuss why every of these properties may indicate a bad relational database design.

Q4. discuss the distinction ranging from closed an open hashing? explain the relative merits of every technique in database application.

Q5. discuss how a TP Monitor manages memory and processor resources more effectively than a typical operating system.

Q6. Stable storage cannot be implemented.
(A) discuss why it cannot be.

(B) discuss how database system deal with database applications

Earning:   Approval pending.