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 equi join with example?

1111

---

what's sql server? : Sql server database administration

984

---

What is normalization? Explain different forms of normalization?

1139

---

what are the different stages of Report Processing?

135

---

How much does sql server 2016 cost?

1048

---

What is the difference between upgrade and migration in sql server?

1081

---

What is the difference between function and stored procedure in sql server?

1055

---

how many layers of tcp/ip protocol combined of? : Sql server database administration

989

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

944

---

Define cursor locking

993

---

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

1008

---

What is indexed view?

972

---

Do you know what are the steps to process a single select statement?

960

---

How to execute stored procedure in select statement sql server?

1047

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1017

---