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
- 18099 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
What is an oracle user role?
How to start your 10g xe server?
Compare and contrast between sql and sql server and explain its various functions?
How to pass parameters to procedures in oracle?
What is meant by an index?
How to increment dates by 1 in oracle?
How to use "startup" command to start default instance?
What are the system predefined user roles?
Describe an oracle table?
How to assign values to data fields in record variables?
How to write a query with a right outer join in oracle?
Explain the difference between a procedure and a function?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to define a variable of a specific record type?
What are the uses of synonyms?
