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
- 187867 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sriniwaas41
dublicate values- means two same values not allowed
primary key:does not allow null values and does not allow
dublicate v
alues
-reapeated values and null values not allowed
-we can use primary key only once in a table
unique key:
-reapeated values not allowed as per primary key.
-but the difference is null values are allowed
-another difference is we can declare more thatn one
unique column in a table.primary is not allowed
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can you create a database in word?
Can we use redis as database?
What is a driver in database?
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.
Which database does facebook use?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What is the best database?
Differentiate between unique key and foreign key?
What are different types of clusters present?
What is a database lookup?
What are the advantages of using database?
What is the candidate key used for?
Explain the table term used in database.
How do you connect to a database?
What are the advantages of views in a database?
