what is primary key,unique key, foreign key? can u teach me
in simple language?

Answer Posted / manoj velyalan

primary key is an unique key in a table and we cant assign
null value on that.

Unique key in table it accept null value.

foreign key is the key which make a relationship between two
table.

Is This Answer Correct ?    18 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of joins?

635


What is the purpose of TNS?

664


Under which circumstance should you create an index on a table?

698


Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

2034


What is ole db in ssis?

616






What is the use of default key?

633


how node connect with cpu?

1673


How concurrency problems effect the database?

639


What are the disadvantages of views in a database?

549


i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

1665


sparse lookup and where its options we find in OCI and db2?

1748


How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1489


What is difference between data and database?

561


What is a super key?

632


What is the use of graph database?

553