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

How does the on-delete-cascade statement work?

604


How to retrieve the count of updated rows?

570


Difference between varchar and varchar2 data types?

658


How to create an oracle database?

578


What is the difference between a user and a schema in oracle?

556






why dont we assign not null constraint as table level constraint.

2252


Explain the use of online redo log files in oracle.

578


How to assign a table row to a record variable?

577


How do I manually uninstall oracle client?

514


Difference between cartesian join and cross join?

540


Respected sir, Please send me technical questions related to oracle apps..

1375


How to add a new column to an existing table in oracle?

584


Explain the use of show option in imp command.

638


What is the difference between sharding and replication?

475


What is an oracle table?

554