what is the difference between primary key & foreign key?
Answer Posted / simbu
primary key is a keyword .that refers to the unique value
in the particular record.it cant have null
foreign key is always keyword that refers primary key.it has
null value.its refers to another table
| Is This Answer Correct ? | 34 Yes | 8 No |
Post New Answer View All Answers
Explain mutating triggers.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain about the analyze command in oracle?
How to initialize variables with default values?
Query to retrieve record for a many to many relationship ?
Explain what are the type of synonyms?
Explain oracle’s system global area (sga).
What are the numeric comparison operations?
What do you mean by merge in oracle?
What happens to the data files if a tablespace is dropped?
What is the recommended interval at which to run statspack snapshots, and why?
How to divide query output into groups in oracle?
What are group functions in oracle?
 What are the oracle DML commands possible through an update strategy?
What is the difference between alert log file and tarce file ?