what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 174566 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
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
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
What is the use of graph database?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
Explain entity set?
Explain database partitioning. What is its importance?
What is Object Oriented model?
What are the disadvantages of views in a database?
How do you connect to a database?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
What is the database url?
How many types of locks are present in a database?
List various types of log-based recovery in DBMS.
What is a sequence? Explain it with one example?
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
