Difference between primary key and unique key ?
- 77 Answers
- 198192 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 / laxman k
1) Primary key can not accept null values, but unique can
accept null values.
2) only one primary key have in a table but max 249 unique
in a table
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Does oracle charge for java?
How to assign values to variables?
Can we connect to ORACLE db using Windows Authentication?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is the recommended interval at which to run statspack snapshots, and why?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
11. Display the client number and name and the client number and name of the person who referred that client.
Which is faster join or subquery in oracle?
Explain the difference between sap and oracle?
what are bitmap indexes? How does they work?
defination of bitmap index
What are privileges and grants?
Can we write insert statement in function in oracle?
What is the relation of a user account and a schema in oracle?
what is dynamic SGA and static SGA
