Difference between primary key and unique key ?
Answer Posted / jason james john
unique key is a key that uniquely defines the characteristics of each row whereas primary key consists of characteristics that cannot collectively be duplicated by any other row.primary key will not allow null values whereas unique key will allow nulls.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is oracle thin client?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What happens to the current transaction if a ddl statement is executed?
What are operators in oracle?
What is an oracle user account?
How to write a left outer join with the where clause in oracle?
How are extents allocated to a segment?
What are the tools for Oracle ?
What is merge in oracle?
How do we get field details of a table?
What happens to the current transaction if the session is ended?
How to get a list of all user accounts in the database?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
Can we create database in oracle using command line ?
How to list all tables in your schema?