Define the terms primary key foreign key and also the
difference between primary and the unique key
- 2 Answers
- 10219 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
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Are truncate and delete commands same? If so why?
Point the difference between translate and replace?
What is bulk load in oracle?
What are the various types of snapshots ?
What is a subquery in oracle?
Explain integrity constraints?
what is Single Byte Overhead...?
Explain the different normalization forms?
How to list all tables in your schema?
What is redo log?
What is logical backup in oracle?
Differentiate between pre-select and pre-query?
Can we connect to ORACLE db using Windows Authentication?
How does oracle handle read consistency?
