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

Is the primary key column of a table an index in ms sql server?

946

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1043

---

What are the various editions of sql server 2017 that are available in the market?

881

---

can an automatic recovery be initiated by a user? : Sql server administration

935

---

What are triggers? How do you invoke a trigger on demand?

1297

---

How can you check the version of sql server?

1079

---

How can you set the threshold at which sql server will generate keysets asynchronously?

972

---

what is database replicaion? : Sql server database administration

1164

---

Define Wed Edition in SQL Azure?

100

---

What will be the maximum number of indexes per table?

942

---

What is the purpose of floor function?

1021

---

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

982

---

What is the main purpose of having conversation group?

887

---

Can you always create a cache of a report?

172

---

How to include date and time values in sql statements?

1073

---