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
- 11217 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
Explain the use of file option in exp command.
How many types of tables are there in oracle?
How to use windows user to connect to the server?
Explain the use of analyse option in exp command.
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to use an explicit cursor without open statements?
What is tns name?
When do we use group by clause in a sql query?
What is flashback in Oracle?
How to use null as conditions in oracle?
How to define and use table alias names in oracle?
How does one get the view definition of fixed views/tables?
What is varray?
What is a server parameter file in oracle?
What is SQL Tuning Advisor in Oracle?
