what is the difference between primary key & foreign key?
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
Please explain joins in oracle?
Is postgres faster than oracle?
What is literal?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to call a sub procedure?
Can we store images in oracle database?
What is the data type of dual table?
Why packages are used in oracle?
What is max rowid in oracle?
What is oracle and what are its different editions?
What is tns name?
Explain the difference between a procedure and a function?
what is the scenario where you take the database to NoArchivelog mode?
Can we connect to ORACLE db using Windows Authentication?
can anyody please send me the dump for Oracle 10g certifications for DBA path?