Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 186598 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / teju
PRIMARY KEY :
IN THE TABLE we can find only one record as
uniqely & also it is not null.
unique key:
uk is to search any record as uniquely& when it
is declared it should be only one null values.
Fk:
fk is to maintain the relations bet two tables
as an duplicate values.means to not null.
e.g
1> stud(stud_id,stud_name);
2> stud_det(stud_id,addr);
In this table stud_id is an pk & In the stud_det as
stud_id is used as an duplicate.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How many types of locks are present in a database?
WHAT IS CARDINALITIES OF JOIN?
How to do Data integrity testing? Who does this testing (Developer or tester)?
List various types of log-based recovery in DBMS.
What is Data Modelling?
Differentiate between extension & intension?
What is the role of tester in discovery(in Checklist)?
What is the difference between database and server?
Explain the table term used in database.
What is sharded database?
can we delete autodiff back up that we have set through sql server agent.
When should you not use firebase?
What is ole db source in ssis?
What is the DIF format and when we will use in teradata
What is the database url?
