Difference between primary key and unique key ?

Answer Posted / guna

there is only one primary key for one table;
it can not acept null values;
any no uniquefor a table;
it can accept null values;
which the rows are unique value;

Is This Answer Correct ?    9 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

636


Why do you create or replace procedures rather that drop and recreate.

558


What is the oracle implicit cursor?

606


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1889


What is redo log?

641






How to use existing values in update statements using oracle?

556


How to use group functions in the select clause using oracle?

603


Please explain joins in oracle?

565


Why is oracle used?

563


How to define a procedure inside another procedure?

559


What would you do with an in-doubt distributed transaction?

1482


What is a nvl function? How can it be used?

575


How to pass a cursor variable to a procedure?

574


Explain the use of inctype option in exp command.

604


Explain an exception?

577