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

Why is there a need for sqlcode and sqlerrm variables?

591


How do you break a loop in pl sql?

533


How would you convert date into julian date format?

602


How do you modify a column in sql?

544


Why do we use procedures in pl sql?

527






Does varchar need length?

529


What is scope of pl sql developer in future?

600


Explain lock escalation? : Transact sql

712


Who is the owner of mysql database?

562


What are the set operators in sql?

566


What are different functions in sql?

525


How do I access sql anywhere database?

508


What is sql analyzer?

552


Are null values same as that of zero or a blank space?

539


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

573