Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 187830 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / raviraj bhardwaj
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 priya 35000
2 preeti 34000
3 niharika 40000
it will not the values as follows:
1 priya 35000
1 preeti 34000
niharika 35000
unique key~ unique key creates non clustered index by
default.it allows "one null value".
forigen key~
when the primary key of one table injected in other table to
make a relationship then the other key of the other table is
called foreign key.
for ex-
Dept table employs
deptno deptmame deptloc eid ename eadd deptno
in it deptno inter relate bothe the tables so that deptno
works here as a forigen kye..
| Is This Answer Correct ? | 15 Yes | 4 No |
Post New Answer View All Answers
What is the database url?
Differentiate between delete and truncate table?
Explain the various types of normalization.
Can you tell any two advantages of stored procedures?
What advantages does DBMS have over traditional file systems?
What are database connection details?
How to do Data size testing? Who does this testing (Developer or tester)?
What is a database lookup?
What are indexes in oracle?
What is a database connection string?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
What are the advantages of views in a database?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
What is the role of driver manager?
What is a Transformation?
