Answer Posted / durgaprasad

Create View emp_dept_vw with encryption as
select emp.empid,emp.ename,dept.deptid,dept.dname
from emp,dept where emp.deptid=dept.deptid
with check option

How many triggers you can have on a table?

1032

---

Can coalesce return null?

1062

---

what are different types of raid configurations? : Sql server database administration

1096

---

what is the difference between Delete and Truncate command in SQL

1194

---

what are the different ways to return the rowcount of a table?

1048

---

What is a unique key constraint?

1083

---

Can sql servers linked to other servers like oracle?

1006

---

Differentiate between truncate vs delete in mssql?

1160

---

What are “phantom rows”?

1702

---

What are the types of dml?

1025

---

Can we insert data into view sql server?

981

---

How to populate a table in sql server?

995

---

How to start sql server browser service?

1177

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

1038

---

What is sql stored procedure?

1145

---