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

Answer Posted / fopal kanjolia

A Primary key is one or more columns in a table used to
uniquely identify each roe in the table primary key value
must not be null and must be unique across the columns

Is This Answer Correct ?    24 Yes 24 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between data source and database?

543


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)?

1480


List some advantages of dbms.

698


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

686


what is the role of auditor in auditing data oriented applications?

1923






query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

1633


Should I store images in database?

572


how can you perform lookup range in lookup stage expalin in detail?

1518


What are the concurrency problems a database faces?

558


How does database replication work?

558


Give the syntax of exception handling used in DBMS?

647


What is the difference between primary key, foreign key and candidate key?

644


How many types of locks are present in a database?

605


Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

919


What is ase database?

553