When we can declare a column as Unique and Not Null both at
the same time. What is the use pf Primary Key then?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is snowflake sql?

582


What is the largest value that can be stored in a byte data field?

521


what is self join and what is the requirement of self join? : Sql dba

686


What is the difference between delete and truncate commands?

517


What problem one might face while writing log information to a data-base table in pl/sql?

560






What program will open a mdb file?

505


What is the maximum number of triggers, you can apply on a single table?

547


What is a null value?

659


Can we join same table in sql?

535


Explain what is sql?

611


What is varchar sql?

620


What is output spooling in sql*plus?

557


What is gpt format?

509


what are the advantages and disadvantages of views in a database? : Sql dba

535


Can you selectively load only those records that you need? : aql loader

615