Can u create a primary key with out unique index.

Answer Posted / prashant

Primary key = Unique Index + Not NUll Constraint .

So we can create primary key without Unique index ..But it
is created as combination of both (Unique Index + Not NUll
Constraint ) in oracle databases.

We need not have to create Unique index . :)

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is 'mysqlimport'? : Sql dba

570


What is a schema sql?

529


What is record type in pl sql?

542


how to present a past time in hours, minutes and seconds? : Sql dba

555


Explain mutating table error.

645






How do I start pl sql?

492


How to add, remove, modify users using sql?

556


Can we call dml statement in function?

540


How insert into statements in sql?

586


How many columns should be in an index?

518


Determine if oracle date is on a weekend?

554


How many sql databases can you have on one server?

590


Is nosql relational?

546


How do I trace sql profiler?

491


what are the t string functions available in tsql? : Transact sql

541