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 stored by the master? : sql server database administration

1115

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5925

---

How can we check the sql server version?

1073

---

Which sql server table is used to hold the stored procedure scripts?

1066

---

What is transaction server distributed transaction?

1060

---

Write down the syntax and an example for create, rename and delete index?

987

---

Explain the commands in sql server?

1043

---

How to use transact-sql statements to access the database engine?

1069

---

Explain various data region available in ssrs with their use?

936

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1065

---

How to use wildcard characters in like operations in ms sql server?

1139

---

How to execute a sql statement using mssql_query()?

1054

---

What is subreport?

144

---

Do you know what are acid properties?

1081

---

How to create a view using data from another view?

954

---