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

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

960

---

explain different types of constraints? : Sql server database administration

914

---

Name 3 ways to get an accurate count of the number of records in a table?

965

---

What are the drawbacks of reporting in ssrs?

141

---

What is snapshot report?

153

---

what are acid properties? : Sql server database administration

928

---

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

879

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

837

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

963

---

What stored by the master? : sql server database administration

1028

---

How to create new table with "create table" statements?

995

---

What is sql server programming?

978

---

What is truncate table?

889

---

Indexes are updated automatically is the full-text index also updated automatically?

977

---

How will you optimize a stored procedure optimization?

954

---