Interested to Buy Any Domain ? << Click Here >> for more details...
what is primary key and foreign key when and where have to use
- 5 Answers
- 7489 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prashant
primary key has a unique & it is only one in a
databasewhile fkey is not unique. it is based on primary key
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramprasad.s
HI
Primary key = (Not Null + Unique).
Foreign key = (For Referential table access).
Bye
sun_ramprasad@yahoo.com
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / chandrika
primary key has unique value, it dostnt contain null values
and duplicate values.
foregin key is primary key of another table
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / raveendran
Primary key is unique across entire table.In primary key
not null constraint is activated.Only one primary key in
one table.
foreign key points to primary key of another table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / csprusty
To establish a relationship between 2 tables.
pk=(unique+not null)
fk=unique
| Is This Answer Correct ? | 1 Yes | 2 No |
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What are the uses of Database Trigger ?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to initialize variables with default values?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
what is candidate key & super key
What are steps required to ENTER DATA INTO DWH?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
What would you do with an in-doubt distributed transaction?
Oracle General 
