Answer Posted / kannan g

Constraints are used to restrict or protect the data and
accessing from the table
There are 5 types of constraints available,
That,
1.Primary-which is not allowed duplication and Null values
2.Unique-Which is also Not allowed duplication But It is
allowed one single null values
3.Foreign - Which is allowed duplication and Null values.
But It refers Value from primary Key table to its own table
Value.
4.Check Constratints
5.Not null

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1891

---

Please explain what is “asynchronous” communication in sql server service broker?

880

---

on line cluster can we make if yes tell me the procedure

1979

---

What stored by the msdb? : sql server database administration

954

---

What is the use of nvl work?

949

---

Do you know how to send email from database?

930

---

How can we improve performance by using SQL Server profiler?

987

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1010

---

What are data resources?

854

---

Can you explain what is indexed view? How to create it?

854

---

Explain active/passive and active/active cluster configurations?

1017

---

What are the operating modes in which database mirroring runs?

1028

---

Do you know hot add cpu in sql server 2008?

901

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

937

---

How to create a simple stored procedure in ms sql server?

979

---