CrazyEngineers
  • DBMS internal viva questions

    Manish Goyal

    Member

    Updated: Oct 22, 2024
    Views: 1.3K
    Today there was my internal viva of dbms in which i was asked 3 questions that i would like to share with you
    1 what is partial key?
    2 what is difference between inner and outer join?
    3 what is foreign key constraint?
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies
  • yadavundertaker mohit

    MemberNov 20, 2009

    Re: internal viva of dbms

    i only know the answer of question 2.....and a little bit of 3rd answer...
    Are you sure? This action cannot be undone.
    Cancel
  • Manish Goyal

    MemberNov 20, 2009

    Even i also don't know answer of 1st question..can anyone explain me with example??
    Are you sure? This action cannot be undone.
    Cancel
  • yadavundertaker mohit

    MemberNov 20, 2009

    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.
    Are you sure? This action cannot be undone.
    Cancel
  • Manish Goyal

    MemberNov 21, 2009

    thanks ...i have also searched on it in my books..same as you described
    Are you sure? This action cannot be undone.
    Cancel
  • yadavundertaker mohit

    MemberNov 21, 2009

    no thanks instead i have to thanks to you because i will also have my DBMS viva on next week...
    Are you sure? This action cannot be undone.
    Cancel
  • Manish Goyal

    MemberNov 21, 2009

    ohhh
    best of luck...
    I hope your viva will be superb as of mine ...
    Are you sure? This action cannot be undone.
    Cancel
  • yadavundertaker mohit

    MemberNov 21, 2009

    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...
    Are you sure? This action cannot be undone.
    Cancel
  • sarveshgupta

    MemberNov 21, 2009

    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?
    Are you sure? This action cannot be undone.
    Cancel
  • yadavundertaker mohit

    MemberNov 21, 2009

    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...
    Are you sure? This action cannot be undone.
    Cancel
  • sarveshgupta

    MemberNov 21, 2009

    But they are the most popular choice for the subject.
    Are you sure? This action cannot be undone.
    Cancel
  • yadavundertaker mohit

    MemberNov 21, 2009

    ya but they are not satisfactory according to me...
    Are you sure? This action cannot be undone.
    Cancel
  • Manish Goyal

    MemberNov 21, 2009

    i have parteek bhatia..you can also have cj DATE...it is quite good
    Are you sure? This action cannot be undone.
    Cancel
  • yadavundertaker mohit

    MemberNov 21, 2009

    thanks for suggestion i will check these books in my college library....
    Are you sure? This action cannot be undone.
    Cancel
  • yadavundertaker mohit

    MemberNov 21, 2009

    Can you post details of the book
    Are you sure? This action cannot be undone.
    Cancel
  • Manish Goyal

    MemberNov 21, 2009

    #-Link-Snipped-#
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register