DBMS internal viva questions

Replies

• 

  yadavundertaker mohit

  Re: internal viva of dbms
  
  i only know the answer of question 2.....and a little bit of 3rd answer...
• 

  Manish Goyal

  Even i also don't know answer of 1st question..can anyone explain me with example??
• 

  yadavundertaker mohit

  i search it on net..what i get is
  
  Partial Key:
  It is a set of attributes that can uniquely identify weak entities and that are related to same owner entity. It is sometime called as Discriminator.
• 

  Manish Goyal

  thanks ...i have also searched on it in my books..same as you described
• 

  yadavundertaker mohit

  no thanks instead i have to thanks to you because i will also have my DBMS viva on next week...
• 

  Manish Goyal

  ohhh
  best of luck...
  I hope your viva will be superb as of mine ...
• 

  yadavundertaker mohit

  oh that will not happen ever...in viva when the teacher asked questions to others i know the answer of each and every question but when my turn came the teacher starts asking the most typical questions ...each time this happen to me ...that's why i always scored really poor in vivas...
• 

  sarveshgupta

  Hey some questions for your help:
  
  1) What is a view? Can a view be used to update the base table?
  2) What are the codd's rules?
  
  3) Why do we do normalisation?
  4) What are the types of Databases?
  5) Which type of Database is Oracle?
• 

  yadavundertaker mohit

  nice questions sarvesh ..but can anyone tell me a good book for the subject...i have korth and navate but they are not so good...
• 

  sarveshgupta

  But they are the most popular choice for the subject.
• 

  yadavundertaker mohit

  ya but they are not satisfactory according to me...
• 

  Manish Goyal

  i have parteek bhatia..you can also have cj DATE...it is quite good
• 

  yadavundertaker mohit

  thanks for suggestion i will check these books in my college library....
• 

  sarveshgupta

  Can you post details of the book
• 

  Manish Goyal

  #-Link-Snipped-#