what is the difference between primary key & foreign key?
- 57 Answers
- 122271 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / suraj menon
primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.
Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to do paging with oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to find out what oracle odbc drivers are installed?
Explain overloading. Can functions be overloaded?
What is the usage of save points in oracle database?
List out the components of logical database structure of oracle database.
What are the benefits of ordbms?
What is oracle open database communication (odbc)?
master table and child table performances and comparisons in Oracle ?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Explain a data segment?
How to retrieve values from data fields in record variables?
How to create a stored program unit?
What is the fastest query method to fetch data from the table?
