Difference between primary key and unique key ?
Answer Posted / sunil upadhyay
the basic difference is that primary key can not have null
value whereas Unique key can have null values.two null
value are not same.One table may have more than one Unique
Key Constraint
columns, but should have only one Primary Key Constraint
column.
| Is This Answer Correct ? | 88 Yes | 51 No |
Post New Answer View All Answers
How to use "in" parameter properly?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is a Nested Loop join?
What happens if you use a wrong connect identifier?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What are group functions in oracle?
What is the difference between postgresql and oracle?
what is the scripts in data base?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What are the different windows events activated at runtime ?
What is oracle database client?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
In oracle there is column command, how will you explain that?
How to create a stored procedure in oracle?