what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / inderjeet yadav
Primary key:A key which is uniquely indetified a row in a
table and primary key can not be null.
Unique key: A key which is uniquely indetified a row in a
table and but unique key can be null.
Foreign:Primary key of the first table that refering in
second table is know as foreign of second table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the concurrency problems a database faces?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
What is global database name?
How to do Stored procedure testing? Who does this testing (Developer or tester)?
Explain entity type?
How do you pass parameter in stored procedure?
How default key is different from primary key?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
what is data access layer?
What is the difference between database and server?
Explain inner and outer joins with examples.
Write a query to get maximum and second maximum in oracle?
What is meant by distributed system?
What are the advantages of views in a database?
How concurrency problems effect the database?