what is the difference between primary key & foreign key?
Answer Posted / aarti
Primary Key : It is a unique key of the table.Unique for
each record in the table(e.g ID).
Foreign Key : When a primary key is used as a reference key
in another table then it is called as a foreign key.It is
used to link two tables.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What happens if the update subquery returns multiple rows?
Who developed oracle & when?
Why do we need integrity constraints in a database?
Explain the difference between replace() and translate() functions in oracle?
How to do a full database export?
Explain constraining triggers.
What is execute immediate in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is a cursor in oracle?
What is define in oracle?
How to get a list of all background sessions in the database?
What is clustered table in Oracle?
How to sort output in descending order in oracle?
How to fetch the row which has the max value for a column?
How do you bind variables in oracle?