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
- 17766 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
Explain an index?
What is the recommended interval at which to run statspack snapshots, and why?
List the various oracle database objects?
Explain the different normalization forms?
How to create a table in a specific tablespace?
How to convert a string to a date in oracle database?
What is a sub query and what are the different types of subqueries?
What is query image?
How to apply filtering criteria at group level in oracle?
List out the components of logical database structure of oracle database.
Explain what are the characteristics of data files?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
why dont we assign not null constraint as table level constraint.
How many types of synonyms in Oracle?
What is meant by an index?
