Interested to Buy Any Domain ? << Click Here >> for more details...
Define the terms primary key foreign key and also the
difference between primary and the unique key
- 2 Answers
- 11319 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pugal
Primary Key : The primary key of a relational table
uniquely identifies each record in the table
Foreign Key : These keys are used to create relationships
between tables.
Unique Key : In relational database design, a unique key is
a candidate key to uniquely identify each row in a table. A
unique key comprises a single column or set of columns
Difference between primary and unique key :
primary key not allows null values
unique key allows null values
| Is This Answer Correct ? | 33 Yes | 12 No |
Answer / nithya
one more difference is:
a table can have only one primary key but many unique keys.
| Is This Answer Correct ? | 22 Yes | 3 No |
what r tyhe major differences between oracle 9i & 10g?
What is transaction control statement and how many types of transaction control statement in Oracle?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
DBMS vs. RDBMS
Explain oracle’s system global area (sga).
How to invoke the data pump export utility?
What privilege is needed for a user to create views in oracle?
What is a Tablespace?
Can a formula column referred to columns in higher group ?
How do we get field detail of a table?
What is the difference between count (*), count (expression), count (distinct expression)?
Can sub procedure/function be called recursively?
Oracle General 
