what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / firoz basha
Primary key - Primary key means main key
def:- A primary key is one which uniquely identifies a row
of a table. this key does not allow null values and also
does not allow duplicate values. for ex,
empno empname salary
1 firoz 35000
2 basha 34000
3 chintoo 40000
it will not the values as follows:
1 firoz 35000
1 basha 34000
chintoo 35000
Unique key - single and main key
A unique is one which uniquely identifies a row
of a table, but there is a difference like it will not
allow duplicate values and it will any number of allow
null values(In oracle).
it allows only a single null value(In sql server 2000)
Both will function in a similar way but a slight difference
will be there. So, decalaring it as a primary key is the
best one.
foreign key - a foreign key is one which will refer to a
primary key of another table
for ex,
emp_table dept_table
empno empname salary deptno deptno deptname
In the above relation, deptno is there in emp_table which
is a primary key of dept_table. that means, deptno is
refering the dept_table.
Is This Answer Correct ? | 1165 Yes | 93 No |
Post New Answer View All Answers
How to produce such kind of file?
What is a Transformation?
issues involved in modeling and building data werahouses
If the master device is full, how do I make the master database bigger?
how do you do sql tuning?
Explain various types of locks in a transaction? Which is better and why?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
can u combine pipeline parallelism and partition parallalism? how and whan?
What is the difference between primary key, foreign key and candidate key?
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
How does non-cluster index functions?
Give the syntax of exception handling used in DBMS?
What are the advantages of views in a database?
What are the advantages of normalizing a database.