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
What are different types of joins used in?
can u combine pipeline parallelism and partition parallalism? how and whan?
What are different types of blocks used in stored procedure?
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
Can a database table exist without a primary key?
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.
How to do Data integrity testing? Who does this testing (Developer or tester)?
What is database collection?
What is difference between server and database?
Is hive a database?
What is a database lookup?
What is the importance of database partitioning?
What is the difference between database and server?
Difference between sql and mysql?
What is the role of tester in discovery(in Checklist)?