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

What is the synonym of join?

0 Answers  

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

What is dynamic cursor in SQL SERVER?

0 Answers  

---

Which Model uses the SET concept

0 Answers   Infosys,

---

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---

What is the difference between dropping a database and taking a database offline?

0 Answers  

---

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

---

How to create view in stored procedure sql server?

0 Answers  

---

Explain the ways to controlling cursor behavior?

0 Answers  

---

Which is faster statement or preparedstatement?

0 Answers  

---