what is the difference between primary key & foreign key?
Answer Posted / zacharia ismail
primary key: primary creates a clustered index on the
column and it doesn't allow null values.
foreign key: A foreign key (FK) is a column or combination
of columns used to establish and enforce a link between the
data in two tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to drop a stored function?
What are the advantages of oracle?
What is a oracle database?
How to define a variable of a specific record type?
What is the difference between truncate & delete command?
What is a user account in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
How to write date and time interval literals in oracle?
What do you mean by merge in oracle and how can you merge two tables?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What do you mean by group by clause?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is difference between sid and service name in oracle?
How many types of database triggers exist?