Difference between primary key and unique key ?
Answer Posted / dinesh
Primary Key:
It wont accept NULL values.
It wont accept Duplication.
Unique Key:
It accepts NULL values.
Foreign Key:
It accepts NULL values.
It accepts Duplication.
Main point is, A Foreign key denotes a Primary key in the another table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use fetch statement in a loop?
What happens if recursive calls get out of control?
What are a collation and state the different types of collation sensitivity?
How to use "startup" command to start default instance?
How to unlock the sample user account in oracle?
How would you begin to troubleshoot an ORA-3113 error?
How to update values on multiple rows in oracle?
How to create a server parameter file?
What is an index associated with a constraint?
What do you understand by database schema and what does it hold?
What are ddl statements in oracle?
What is meant by recursive hints in oracle?
How to create additional tablespaces for an new database?
Hi Can any one tell me what are the API's used in requisition import.
Explain about your project and its relation to the current job position you are applying to?