Interested to Buy Any Domain ? << Click Here >> for more details...
Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 18078 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / anamika niit
Primary key and unique are Entity integrity constraints
Primary key allows each row in a table to be uniquely
identified and ensures that no duplicate rows exist and no
null values are entered.
Unique key constraint is used to prevent the duplication of
key values within the rows of a table and allow null
values. (In oracle, one null is not equal to another null).
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
What is oracle latest version?
What is difference between truncate and delete?
What is backup in Oracle?
How to invoke the data pump import utility?
Explain an exception and its types?
What is the difference between substr and instr?
What are the differences between char and varchar2 in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is a tns service name?
Write a trigger example in oracle?
Explain what does a control file contain?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to load data from external tables to regular tables?
List out the types of joins.
