DBMS internal viva questions

@manish-r2Hoep • Oct 22, 2024

Oct 22, 2024

1.6K

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?

Like 0 Replies 15

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

yadavundertaker mohit

@yadavundertaker-0p3HBs • Nov 20, 2009

Re: internal viva of dbms

i only know the answer of question 2.....and a little bit of 3rd answer...
0
Manish Goyal

@manish-r2Hoep • Nov 20, 2009

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

@yadavundertaker-0p3HBs • Nov 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.
0
Manish Goyal

@manish-r2Hoep • Nov 21, 2009

thanks ...i have also searched on it in my books..same as you described
0
yadavundertaker mohit

@yadavundertaker-0p3HBs • Nov 21, 2009

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

@manish-r2Hoep • Nov 21, 2009

ohhh
best of luck...
I hope your viva will be superb as of mine ...
0
yadavundertaker mohit

@yadavundertaker-0p3HBs • Nov 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...
0
sarveshgupta

@sarveshgupta-txtmu5 • Nov 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?
0
yadavundertaker mohit

@yadavundertaker-0p3HBs • Nov 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...
0
sarveshgupta

@sarveshgupta-txtmu5 • Nov 21, 2009

But they are the most popular choice for the subject.
0
yadavundertaker mohit

@yadavundertaker-0p3HBs • Nov 21, 2009

ya but they are not satisfactory according to me...
0
Manish Goyal

@manish-r2Hoep • Nov 21, 2009

i have parteek bhatia..you can also have cj DATE...it is quite good
0
yadavundertaker mohit

@yadavundertaker-0p3HBs • Nov 21, 2009

thanks for suggestion i will check these books in my college library....
0
yadavundertaker mohit

@yadavundertaker-0p3HBs • Nov 21, 2009

Can you post details of the book
0
Manish Goyal

@manish-r2Hoep • Nov 21, 2009

#-Link-Snipped-#

0