Difference between primary key and unique key ?

Answer Posted / yogesh kumar

primary key is unique define in a table, it means if u
declare primary key value is not allows duplicate and null.

unique key allows repeats' a value and null.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

State some uses of redo log files?

746


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2303


How to insert a new row into a table in oracle?

808


What to do if the startbd.bat failed to start the xe instance?

817


Calculate difference between 2 date / times in oracle sql?

778


What is an oracle cursor variable?

790


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1726


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1861


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1856


Explain a private synonyms?

808


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2055


How to define a data field as not null?

835


What is BBED in Oracle?

892


What are the roles of dba?

780


How to omit columns with default values in insert statement in oracle?

789