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
- 11076 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 the maximum number of triggers that can be applied to a single table?
Whether any commands are used for months calculation? If so, what are they?
Can we store images in oracle database?
candidate key is subset of super key but not vice-verse explain
what is difference between cartesian join & cross join even they give same result?
How can we find the size of a database?
What is an Index ? How it is implemented in Oracle Database ?
Explain the difference between a procedure and a function?
what are the database links ?
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
what is the difference between dbms and rdbms?
how to find the n'th highest salary from emp ?
Oracle General 
