Difference between primary key and unique key ?
Answer Posted / hemendra singh chaudhary
In the Table a primary key constraint column cannot holding
the null values.whereas unique constraint colum can holding
the null values.
Ex.|--------------------|
| ID(P) | Name(U) | #ID(P) ->It's a Primary Key
|--------------------| * Its a Not Null
| 1 | Hemendra | * A table Contain 1 Primary
| 2 | Neeraj | Key.
| 3 | PremJe | #Name(U)->It's a Unique Key
|NotNull |canbe Null| * Its can contain Null Value
|--------------------| * A table Contain more
than 1 unique Key.
Please Check the Radio Button..........
******************Gud Luck********************
Is This Answer Correct ? | 45 Yes | 0 No |
Post New Answer View All Answers
How to create a new table by selecting rows from another table?
What is the oracle implicit cursor?
How to apply filtering criteria at group level in oracle?
What is the difference between $oracle_base and $oracle_home?
Differentiate between post-database commit and post-form commit?
how to clone 9i Database on to 10g Database.
How to use in conditions in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to import one table back from a dump file?
How to compare dates in oracle sql?
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.
Is oracle a programming language?
How to connect to oracle using service name instead of sid?
What is save point in oracle database?
What is Library Cache in Oracle?