what is the difference between primary key & foreign key?
Answer Posted / afzaal
primary key is a constraint key that can not contain a null
or duplicate values.
foriegn key is a reference key ,before referencing the
foriegn key parent table field or fields must have primary
key.If u can try to insert a value in referencing field,new
record that must contain parent field.
| Is This Answer Correct ? | 22 Yes | 11 No |
Post New Answer View All Answers
How to save query output to a local file?
What are the uses of a database trigger?
How to use values from other tables in update statements using oracle?
Explain the use of record option in exp command.
Give syntax for SQL and ORACLE joins.
What are the limitations oracle database 10g xe?
Explain the features of oracle?
What to do if the startbd.bat failed to start the xe instance?
How do you store pictures in a database?
What is the difference between a primary key & a unique key?
How a database is related to tablespaces?
Explain temporal data types in oracle
interview questions with answer for cts
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What suggestions do you have to reduce the network traffic?