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
- 17802 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 the common oracle dba tasks?
What is an index associated with a constraint?
How to run queries on external tables?
What is a package ? What are the advantages of package ?
Describe the types of sub query?
How to use subqueries with the in operator using oracle?
How to drop an existing table in oracle?
How can Oracle users be audited?
How to add another datafile to a tablespace?
candidate key is subset of super key but not vice-verse explain
What is ceil and floor in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Which environment variables are absolutely critical in order to run the OUI?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is an oracle cursor variable?
