what is the difference between primary key & foreign key?
- 57 Answers
- 122285 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / deepa
Primary key is a keyword.
It should not have null value and duplicate value.
We can have only one primary key in a table and the value
should be unique.
Foreign key is a keyword.
It can have null value and duplicate value.
We can have more than one foreign key for a table and this
froeign key table references the primary key table.
| Is This Answer Correct ? | 22 Yes | 7 No |
Post New Answer View All Answers
What are the oracle differences between nvl and coalesce
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Is java required for oracle client?
How to create a server parameter file?
List the parts of a database trigger.
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What are dml statements in oracle?
Can you have more than one content canvas view attached with a window ?
How to synchronize 2 schema's objects?
Explain an integrity constrains?
Explain the use of grant option in imp command.
How to login to the server without an instance?
What is truncate oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
