What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

---

What are data files?

0 Answers  

---

A trigger can reference objects outside the current database? State true or false.

0 Answers  

---

How can sql server instances be hidden?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

IN Vs OR operator which is best to use sql server.

4 Answers  

---

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

---

If the job running very slow what is the action you do

0 Answers  

---

What are the purposes of floor and sign functions?

0 Answers  

---