Difference between primary key and unique key ?
Answer Posted / vitthal parkar
Unique key Primary key
1. Can have null value 1. Can not have null value
2.Table can have multiple 2. Table Can have multiple unique
Unique keys keys
3Single column at a time 3. May be combination of one or
or more columns
| Is This Answer Correct ? | 35 Yes | 58 No |
Post New Answer View All Answers
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are the set operators union, union all, minus & intersect meant to do?
What are the differences between char and nchar in oracle?
What is a relational database management system?
How can we view last record added to a table?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is a tns file?
How do I know if oracle is installed on windows?
ABOUT IDENTITY?
How to do paging with oracle?
How to use an explicit cursor without open statements?
what's query optimization and without use of IN AND Exist can we get another way data from query
How to add a new column to an existing table with a default value?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What are the ansi data types supported in oracle?