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

Answer Posted / heena verma

Primary Key:- it is a contraint(checks) provided by DBMS.
if we want to make a coumn unique and not null then the
column is defined as primary key. it is used to create
relations among the tables.

Is This Answer Correct ?    55 Yes 43 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the relationship that exists inside in E-R diagram?

619


Explain the table term used in database.

553


What is database and its types?

542


Is redis in memory database?

521


Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2044






What will happen non-clustered index will be created on clustered index?

592


how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

1562


i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?

1621


Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1399


Explain partial key?

630


Explain various types of locks in a transaction? Which is better and why?

584


What is ole db ado?

533


What do you mean by cluster and non cluster index?

555


Is hive a database?

539


Which database is best to store images?

511