Define the terms primary key foreign key and also the
difference between primary and the unique key
- 2 Answers
- 10239 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 is catalog in Oracle?
How do I uninstall oracle client from windows?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
In what script is snap$ created? In what script is the scott/tiger schema created?
what is the syntax of ALTER command?
What privilege is needed for a user to query tables in another schema?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
how to get the no employee in each department including the dept which has 0 employee
Why is oracle so popular?
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
Why cursor variables are easier to use than cursors?
What is ADDM Advisor in Oracle?
Oracle General 
