Answer / swapna

1)unique key can be null but primariy key cant be null.
2)primariy key can be refrenced to other table as FK.
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).

Answer / satya_k21

Hi,

Primary Key: Not Null+ unique.but it wont allows null
values.

Unique: It allows null values , but it should be unique.

Regards,
Satya.k

Answer / nitin gupta

Uniques: Enforce unique data in the database
it allows row containing null value but only once
It implements non clustered index.

primary key: Enforce unique data in the database
it don't allow any record containing null value
it implements clustered index (data physically
sorted)

Answer / kk

PRIMARY KEY=UNIQUE KEY+ NOT NULL KEY so its a combo drive

What is a delimiter in sas?

0 Answers  

---

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

---

Is sql dba a good career? : SQL DBA

0 Answers  

---

How do I install sql?

0 Answers  

---

what is the difference between trigger and constraint?

3 Answers   HSBC,

---

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

---

How can triggers be used for the table auditing?

0 Answers  

---

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

---

Is stored procedure faster than query?

0 Answers  

---

What is indexes?

0 Answers  

---

Does sql between include endpoints?

0 Answers  

---

What do you know by pl/sql cursors?

0 Answers  

---