Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of primary key over unique+notnull
- 7 Answers
- 22199 Views
- Consultancy, LGS, Oracle, I also Faced
- E-Mail Answers
Answer Posted / kamal
we are able to create a primary key for combination of more
than 1 column. which is not possible in Unique,we should
create unique key for each and every column in the table
individually.
ex . we can create a primary key for (Name,DOB,address)- ie
combination of these three columns be unique.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
what is online transaction processing (oltp)? : Sql dba
what are the limitations of identity column? : Transact sql
How can we make an if statement within a select statement?
What is the maximum rows in csv?
What is the purpose of design view?
How does sql developer connect to oracle database?
Is a foreign key always unique?
What are all the different normalization?
What is auto increment in sql?
What is primary key secondary key alternate key candidate key?
what is a stored procedure? : Sql dba
What is a schema? How is it useful in sql servers?
What is scalar data type in pl sql?
How do I truncate a sql log file?
What is audit logout in sql profiler?
