Can u create a primary key with out unique index.

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


Please Help Members By Posting Answers For Below Questions

What is row_number () in sql?

537


Do prepared statements prevent sql injection?

526


How to change the order of columns in Oracle SQL Plus ?

610


Which join is like inner join?

559


Can we use views in stored procedure?

511






What is a natural join sql?

511


Why we use triggers in mysql?

557


Can function return multiple values in sql?

524


What's the difference between inner join and left join?

511


How many sectors are in a partition?

557


What are synonyms in sql?

532


How do you write a subquery?

517


What does seeding a database mean?

525


How do you modify a trigger?

524


Why do we use %rowtype & %type in plsql?

601