what is the different between unique+not null & primary key,

Answer Posted / sreekumar

In a relation, we can create only one primary key where as we can create multiple unique+not null constrains.

Primary key uses clustered index where are unique +Not null uses non clustered index.

Sreekumar

Is This Answer Correct ?    18 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to use case expression? : Sql dba

764


How many types of cursors are available in pl/sql?

805


What is a memo field?

712


What is dml and ddl?

733


How to look at the current sql*plus system settings?

782


What is duration in sql profiler trace?

799


what are the different type of normalization? : Sql dba

783


What is indexing in sql and its types?

768


Is pl sql useful?

742


Does truncate need commit?

714


What is oracle sql developer?

819


What is #table in sql?

725


what is the difference between a local and a global temporary table? : Sql dba

771


How can we link a sql database to an existing android app?

760


How to select 10 records from a table?

884