When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?
Answers were Sorted based on User's Feedback
Answer / thanga prabu.n
Unique Key creates Non-Cluster index in default,
But in Primary Key creates Cluster index in default
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / swapna
The concept of adding an unique key and not null constraint
to a column as well as adding as unique index to it , you
will assume to get the benefits of adding an primary key
to that column.
But use it for the purpose of referential integrity will
not allow to do so.
That's what PK is so useful. You will use it for
normalization purpose.
Is This Answer Correct ? | 12 Yes | 6 No |
How to use distinct and count in sql query? Explain
what are sequences
if a string is there like s1,s2,s3,s4.How to find count of commas in this.
What is sql in java?
select 10 from dual; y its showing all the rows with 10?
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
Which one is the Best approach to put code, among Triggers and Procedures? Explain?
what is bcp? When is it used?
Is pl sql a scripting language?
Does truncate release storage space?
What is rownum?
What is the need of a partition key?