what is the difference between primary key & foreign key?
Answer Posted / vasavi
primary key does not allow duplicate and null values
primary is unquie.
foreign key allows null values it refers primary key.
foreign key allows duplicate values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to fetch the row which has the max value for a column?
How to enter a new row into a table interactively?
How to convert dates to characters in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to define and use table alias names in oracle?
What is a cursor in oracle?
What are the different editions of oracle?
How to resolve name conflicts between variables and columns?
What are privileges and grants?
What is the best way to do multi-row insert in oracle?
Is insert autocommit in oracle?
What is Redo Log Buffer in Oracle?
How can I get column names from a table in oracle?
How remove data files before opening a database?