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
- 18333 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
How can we view last record added to a table?
What is recycle bin in Oracle?
What is a package ? What are the advantages of package ?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Can we convert a date to char in oracle and if so, what would be the syntax?
Explain what does a control file contain?
Explain a data segment?
How can I see all tables in oracle?
How to create a new user account in oracle?
What are the restrictions in a oracle read only transaction?
What are the execution control statements in oracle?
How to drop a stored procedure in oracle?
How to create an initialization parameter file?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
what is Single Byte Overhead...?
