what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 180268 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ck
Primary key is a key which will not allow any null values.
whereas unique key which will allows null value only once.
Foreign key is a key which values should match some values
in the primary key value.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is database and its types?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
What is database schema name?
how can we view column head in first page but not in remaining pages?
Explain the various types of normalization.
What is ase database?
What is a sequence? Explain it with one example?
How does non-cluster index functions?
can we delete autodiff back up that we have set through sql server agent.
how do you do sql tuning?
After normalization, what are the conditions which have to keep in mind to de-normalize it?
Should I store images in database?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What does specialization in DBMS mean?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
