Difference between primary key and unique key ?
Answer Posted / boomiraj.p
Primary key: Do not allow the
duplicates and null values.
Unique key : Do not accept the
duplicates,but allow null value
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between alert log file and tarce file ?
How to create additional tablespaces for an new database?
master table and child table performances and comparisons in Oracle ?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is a relational database management system?
Can we convert a date to char in oracle and if so, what would be the syntax?
Why do we use coalesce function in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is archive log in Oracle?
Explain temporal data types in oracle
what is the dual table in oracle?
How to write text literals in oracle?
State all possible different index configurations a table can possibly have?
How to execute the package in oracle?
What is the difference between primary key and unique key and foreign key in oracle?