what is the difference between primary key & foreign key?
Answer Posted / guest
primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity.
| Is This Answer Correct ? | 155 Yes | 19 No |
Post New Answer View All Answers
Give syntax for SQL and ORACLE joins.
How to get a list of all user accounts in the database?
What is null value in oracle?
How to write a query with a right outer join in oracle?
How to view the tablespaces in the current database?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is varray?
What privilege is needed for a user to create views in oracle?
What are joins, explain all types of joins?
Query to retrieve record for a many to many relationship ?
Explain compound trigger in oracle?
What is a proxy class?
List the types of joins used in writing subqueries?
Difference between oracle's plus (+) notation and ansi join notation?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.