Is primary key = unique key,not null?
If yes,please explain
IF No,please explain

Answer Posted / chanchal

a primary key can be a unique key but a unique key
may be or may not be a primary key bcoz primary key cant be
NULL but Unique Key may.
in a table more than one unique key but only one primary key

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle data type?

565


How to run queries on external tables?

579


IS it possible to built the oracle database without setting the kernal parameters?

1767


What is the difference between translate and replace?

567


How can we force the database to use the user specified rollback segment?

562






Explain about integrity constraint?

615


Can the query output be sorted by multiple columns in oracle?

577


if you ctreate table identity

1856


What is a dynamic performance view in oracle?

615


How do I find the database name in oracle?

605


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

671


How to retrieve values from data fields in record variables?

579


What is the difference between post-database commit and post-form commit?

521


Can we use bind variables in oracle stored procedure?

499


What are the differences between interval year to month and interval day to second?

558