Answer Posted / smita
Hi,
No , we cant create pk eithout unique index it
implicitelygenerater by oracle.
I want to clear that pk can b on one or more col but only
one pk.
While unique constraint can b one or more col and can b one
or morn unique key in a table
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
what are the type of locks ? : Sql dba
What is the purpose of design view?
Can a key be both primary and foreign?
Explain the methods used to protect source code of pl/sql.
How can we solve sql error: ora-00904: invalid identifier?
What are the different types of sql commands?
Is sql harder than python?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How do I filter in sql profiler?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is sap sql?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What are the dml statements?
What is the difference between left join and right join?
How do you rank data in sql?