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
- 18326 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
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is the use of aggregate functions in oracle?
What is max rowid in oracle?
Why use resource manager in Oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Is there a function to split a string in plsql?
Oracle
When do we use group by clause in a sql query?
Please explain oracle data types with examples?
How do you tell what your machine name is and what is its IP address?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is bulk collect in oracle?
What is varray?
How to assign a tablespace to a users in oracle?
How to run create database statement again?
