Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 15331 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 happens to the current transaction if a ddl statement is executed?
What is system tablespace?
What is oracle and what are its different editions?
What is PL/SQL ?
Can group functions be mixed with non-group selection fields?
Why do we use bulk collect in oracle?
What is Data Dictionary Cache in Oracle?
What are internal user account in oracle?
Is a rollback possible to any savepoint?
How to write a query with an inner join in oracle?
What are the different types of modules in oracle forms?
How do I limit the number of oracle database connections generated by weblogic server?
How to invoke the data pump export utility?
What is ordinary table in oracle?
What is a database schema in oracle?
