uniqe key may contain null values but primary key can not take the null val

Difference between primary key and unique key ?

Question Posted / suman chatterjee.

77 Answers
210688 Views
Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
E-Mail Answers

Answer Posted / suman chatterjee.

uniqe key may contain null values but primary key can not take the null values.

Is This Answer Correct ?

3 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to rebuild an index in oracle?

1037

Why packages are used in oracle?

1078

Can a parameter be passed to a cursor?

1137

What is an oracle and why it is used?

1161

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2101

How to download oracle database 10g xe?

1026

What is the quickest way to fetch the data from a table?

1065

What is an Oracle index?

1663

Explain the characteristics of oracle dba?

1132

Is java required for oracle client?

1005

What is the difference between substr & instr functions?

1241

Explain the features of oracle?

1058

How to write date and time interval literals in oracle?

1042

What are group functions in oracle?

1051

What are the most common interview questions on ETL Testing for experience?

1152