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

Answer Posted / vinodkumar

Primary key:it is a key in which uniquely identify the
answer which is stored in the DBMS.A table contains a
primary key.

Foreign key:A key used in the table to represent the primary
key i.e when the primary key is used in a table of one topic
then the same name can be used as foreign key in another topic

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sharded database?

511


How to do Stored procedure testing? Who does this testing (Developer or tester)?

1390


What is a driver in database?

559


what is rcp,if rcp disabled what happen?

1716


Should I store images in database?

584






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.

1390


define primary key index, bitmap index, hash index,virtual indwx

2850


What is the purpose of firebase?

550


What is lagging in DBMS ?

822


Explain database partitioning.

646


What advantages does DBMS have over traditional file systems?

597


what is the full procedure for using store procedure in informatica7.1?

1816


List some advantages of dbms.

712


Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

1696


Explain about ur projets on teradata???

1366