Answer / atikullah

No, I think unique constraint contain no duplicate value in
a column. There are only contains unique value

Answer / rammohan176

yes Unique constraint accept more than one null.... because null is always not equal to another null value.i.e null<>null.
if any body have doubt please check this
CREATE TABLE TEST1 ( ENO NUMBER CONSTRAINT EU UNIQUE,
NAME1 VARCHAR2(10))

INSERT INTO TEST1 (NAME1) VALUES('RAM')

INSERT INTO TEST1 (NAME1) VALUES('KARTHIK')
INSERT INTO TEST1 (NAME1) VALUES('SANTHOSH')
INSERT INTO TEST1 (NAME1) VALUES('SANDY')

How can you ensure that the database and sql server based application perform well?

0 Answers  

---

Can we create clustered index on non primary key column

20 Answers   ABC, CTS,

---

Tell me what is log shipping?

0 Answers  

---

Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,

---

Explain a differential backup?

0 Answers  

---

How to create logins using windows Authentication mode?

2 Answers  

---

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

0 Answers   Wipro,

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---

What is a filestream?

0 Answers  

---

What is meant by datasource?

0 Answers  

---

Distinguish between commit and rollback?

0 Answers  

---