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
- 11069 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to retrieve data from an cursor to a record?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
List out the types of joins.
How to delete multiple rows from a table in oracle?
How to define a procedure inside another procedure?
what is port in oracle? how is it related to database application.
How to create a new tablespace in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is difference between cartesian join and cross join?
What is a nvl function? How can it be used?
What privilege is needed for a user to create views in oracle?
What are the uses of synonyms?
What are the limitations oracle database 10g xe?
Explain the difference between sql and oracle?
How to use group functions in the select clause using oracle?
