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
how to use case expression? : Sql dba
How many types of cursors are available in pl/sql?
What is a memo field?
What is dml and ddl?
How to look at the current sql*plus system settings?
What is duration in sql profiler trace?
what are the different type of normalization? : Sql dba
What is indexing in sql and its types?
Is pl sql useful?
Does truncate need commit?
What is oracle sql developer?
What is #table in sql?
what is the difference between a local and a global temporary table? : Sql dba
How can we link a sql database to an existing android app?
How to select 10 records from a table?