Answer / prasanthi

Check Constraint:

The CHECK constraint is used to limit the value range that
can be placed in a column.

not null constraint:

if we give not null constraint to any column it will not
accept null values.

Unique Conatraint:

Unique key is similar to primary key but it accepts one
null value.
For o column Setting Unique key+Not NULL we can make
Primary Key.

Answer / chaitu

These are contraints

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

What is the sql case statement used for?

0 Answers  

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

What stored by the master? : sql server database administration

0 Answers  

---

What does executeupdate return?

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  

---

Tell me in brief how sql server enhances scalability of the database system?

0 Answers  

---

which database is best to use in oracle and sql server? explain reasons?

5 Answers   TCS,

---

How to how to convert numeric expression data types using the convert() function??

0 Answers  

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

What does indexation mean?

0 Answers  

---