Answer Posted / g.rajesh(m.tech)

constrain kis a rule.
types of constriants are
1.domain constrain:
eg:chjeck,default,not null.
2.entity constraints:
eg:primary key.
unique key
3.referential constrain:
eg:foreign key

what is the system function to get current user's user id? : Sql server database administration

945

---

What does the update command do?

1050

---

What is the sql case statement used for?

1032

---

What is the new security features added in sql server 2014? : sql server security

940

---

What are the different types of Indexes available in SQL Server?

946

---

How can we check the sql server version?

979

---

How to truncate the log in sql server 2012? : sql server database administration

1199

---

How do clustered indexes store data?

1053

---

Mention the 3 ways to get a count of the number of records in a table.

916

---

How do I view a stored procedure in sql server query?

884

---

Explain SSRS Architecture?

179

---

Can binary strings be converted into numeric or float data types?

965

---

Explain the database you used in your final year project?

966

---

What are the different types of indexes?

1043

---

How will you find out if there are expensive SQL statements running or not?

965

---