Can u create a primary key with out unique index.

Answer Posted / ravin

Unique constraint and unique index are different things but
their goals might be similar.

Unique index is created implicitly with the creation of
Primary key and unique key both.
Hence no primary key can be created without a unique index.

Is This Answer Correct ?    19 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is pl sql still used?

507


What is %s in sql?

562


How does cross join work?

502


What are all the different types of indexes?

618


What is difference between joins and union?

529






What is bind variable in pl sql?

524


What are sql commands?

500


What is a database? Explain

593


What is the purpose of the primary key?

564


What is the difference between a subquery and a join?

527


What is procedure explain with program?

550


How would you pass hints to the sql processor?

524


How much does sql certification cost?

543


What are the types of optimization?

519


What is full join?

525