Answer Posted / bimaleswar patel

Constraints are used to limit the type of data that can go
into a table.
two basic types of constraints are there
1.column level
2.table level
the difference is that column level constraints are apply
only to one column where as table level constraints are
apply to whole table
Constraints are declare at the time of table creation using
CREATE TABLE command

there are 6 constraints used in oracle
1.NOT NULL
2.UNIQUE
3.PRIMARY KEY
4.CHECK
5.DEFAULT
6.REFERENCES

What are the differences between left join and inner join in sql server?

1050

---

What is a join in sql? What are the types of joins?

1021

---

Explain index in sql server?

970

---

How to set database to be single_user in ms sql server?

977

---

What is the difference between Normalization and De-normalization?

1035

---

How can you find out how many rows returned in a cursor?

977

---

Can we shrink data file in sql server?

1004

---

How do I schedule a sql server profiler trace?

925

---

What is the difference between drop table and truncate table?

882

---

What is the parse query button used for?

986

---

What are distributed partitioned views?

1014

---

Is sql server is free?

931

---

Do you know what is sql service broker?

1003

---

What is the contrast between sql and mysql?

1051

---

What are built in functions?

958

---