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
- 11315 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 invoke the original export import utilities?
Can we store pictures in the database and if so, how it can be done?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Can the query output be sorted by multiple columns in oracle?
What is a directory object?
How to define a variable to match a table column data type?
How to build data dictionary view an new database?
What privilege is needed for a user to connect to oracle server?
What are the four Oracle system processes that must always be up and running for the database to be useable?
Does oracle partitioning improve performance?
Explain oracle 12c new features for developers?
What are the extensions used by oracle reports?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to assign query results to variables?
