what is the difference between primary key & foreign key?
- 57 Answers
- 122435 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
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
6. Display the client name and order date for all orders using the traditional method.
How to change user password in oracle?
How to drop a stored procedure in oracle?
Describe the types of sub query?
Explain the use of analyse option in exp command.
What is a user account in oracle?
How can we delete duplicate rows in a table?
How to drop a tablespace?
What are ddl statements in oracle?
How to store only time; not date and time?
What is a cursor in oracle?
What is oracle instant client?
Explain the difference between a procedure and a function? What do you understand by those terms?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How will you differentiate between varchar & varchar2?
