Difference between primary key and unique key ?

Answer Posted / pandiyan

Primary key doesnot allow null value but unique key allows
null value.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between pre-select and pre-query?

860


What is an oracle database?

819


How to list all indexes in your schema?

817


How to run create database statement again?

844


How do I know if oracle is installed on windows?

689


What is the usage of merge statement?

911


How to create a new user account in oracle?

807


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1508


what are bitmap indexes? How does they work?

2010


How to create lov dynamically at runtime & attach to text field?

917


Explain implicit cursor.

798


Explain temporal data types in oracle

840


What are the set operators union, union all, minus & intersect meant to do?

783


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1793


How to assign data of the deleted row to variables?

838