Difference between primary key and unique key ?

Answer Posted / rajkumar tiwari

Primary key contain non repetitive value and not null
value,and primary key is created on clustered index.In the
table their should be one primary key column.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use fetch statement in a loop?

764


What is oracle instant client?

750


What is a synonym? What are its various types?

854


When do I need to use a semicolon vs a slash in oracle sql?

792


what is dynamic SGA and static SGA

4051


What is connection pooling in oracle?

727


How to export data with a field delimiter?

772


Give the constructs of a package, function or a procedure.

778


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

789


How to get the Installed Oracle Version Information ?

842


How do you tell what your machine name is and what is its IP address?

1732


What is oracle database 10g express edition?

799


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1416


What is oracle data type?

729


What are the uses of synonyms?

833