what are the advantages of primary key over unique+notnull
- 7 Answers
- 20885 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 oracle and pl sql?
Is drop table faster than truncate?
Explain spool.
How do I copy a table in sql?
What is the maximum database size for sql express?
Can you rollback after commit?
what is the difference between union and union all? : Sql dba
can sql servers linked to other servers like oracle? : Sql dba
which tcp/ip port does sql server run on? : Sql dba
i have some prob lem to tell me about my self in interview first round ...
What is sqlite used for?
Is sql microsoft?
How does postgresql compare to oracle/db2/ms sql server/informix?
What are types of exception?
Does varchar need length?
