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
- 18086 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / kirti
Yes.When a column is assigned primary key it means it
contains unique value(i.e. no duplicate value is allowed) &
it can't accept null values.
Whereas unique key means no duplicare value is allowed, but
null value is allowed. And not null means no null value is
accepted but duplicate value can be passed.
So when we assign primary key to a column, the column
becomes both unique & not null.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is meant by magic query
How do I limit the number of oracle database connections generated by weblogic server?
How to run queries on external tables?
Explain enable novalidate constraint.
What are the roles of dba?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What are transaction isolation levels supported by oracle?
How do I connect to oracle?
What is oracle database client?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What happens if the update subquery returns multiple rows?
Explain do view contain data?
How to define an anonymous procedure without variables?
What is a parameter file in oracle?
what are bitmap indexes? How does they work?
