Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210338 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
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
Explain an index?
what's query optimization and without use of IN AND Exist can we get another way data from query
what are steps for interface? where is exchange rate defined in which table?
What is query image?
Can we convert a date to char in oracle and if so, what would be the syntax?
6. Display the client name and order date for all orders using the traditional method.
How can we view last record added to a table?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Explain what are the uses of rollback segment?
How to handle a single quote in oracle sql?
What is a static data dictionary in oracle?
What are the tools for Oracle ?
what is IDE,DMV in sql server?
What is the maximum number of triggers that can be applied to a single table?
How to write date and time literals in oracle?
