Interested to Buy Any Domain ? << Click Here >> for more details...
Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 17694 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / chandrika
if we define unique key column to not null
then first attempt it not allow to insert null value in
column but after inserting once we can edit its value to
null even if it is not null ( means its allow null)
if we assign primary key then its not allow (in every
situation it not allow null and duplication)
that is main difference between unique key and primery key
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Explain about integrity constraint?
What is a read write transaction in oracle?
What are a query and state the different types of queries and their uses?
What are the components of logical database structure in oracle database?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What is a snapshot log?
What is the difference between sharding and partitioning?
What is the use of oracle?
What is SQL access advisor in Oracle?
Explain temporal data types in oracle
Explain view?
What are the arithmetic operations?
What are the ansi data types supported in oracle?
How to drop an existing table in oracle?
