what is the difference between primary key & foreign key?
- 57 Answers
- 122242 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
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
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
Explain the use of control file?
Is a rollback possible to any savepoint?
Difference between cartesian join and cross join?
What are the predefined tablespaces in a database?
How to view the tablespaces in the current database?
What is connection pool in oracle?
How to write date and time literals in oracle?
Explain the use of owner option in exp command.
Explain coalesce function?
What is a read only transaction in oracle?
Where is the export dump file located?
How to end the current transaction in oracle?
What is control file used for?
