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
- 17703 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 are steps for interface? where is exchange rate defined in which table?
Oracle
What is a read write transaction in oracle?
What are internal user account in oracle?
what is the use of system.effective.date variable in oracle?
What happens if you use a wrong connect identifier?
What is the relationship among database, tablespace and data file?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
definition of cluster and non-clustered index?
What are the varoius components of physical database structure of oracle database?
What do database buffers contain?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to add a new column to an existing table in oracle?
Explain what are the uses of rollback segment?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
