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
What is difference between sid and service name in oracle?
What is meant by joins? List out the types of joins.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are group functions in oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Respected sir, Please send me technical questions related to oracle apps..
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to display row numbers with the records?
Where do we use decode and case statements?
What is the data pump export utility?
What is java oracle used for?
How to list all tables in your schema?
What is a nested table and how is it different from a normal table?
What is merge statement used for?