Answer Posted / gayathri

create table Emp1(EmployeeId int, Age int);
INSERT into Emp1 Values(1,20);
INSERT into Emp1 Values(2,20);
INSERT into Emp1 Values(3,25);
INSERT into Emp1 Values(4,25);
INSERT into Emp1 Values(5,30);
INSERT into Emp1 Values(6,30);
INSERT into Emp1 Values(7,30);

create table Emp_details(EmployeeId int, Region cahr(10));

INSERT into Emp_details Values(1,'del');
INSERT into Emp_details Values(2,'chn');
INSERT into Emp_details Values(3,'mum');
INSERT into Emp_details Values(4,'del');
INSERT into Emp_details Values(5,'cal');
INSERT into Emp_details Values(6,'mum');
INSERT into Emp_details Values(7,'chn');

select Region from Emp_details ed,Emp1 e1
where e1.EmployeeId = ed.EmployeeId
and e1.Age = (select max(Age) from emp1);

What is temporary table in sql server? Why we use temp table?

934

---

What guidelines should be followed to help minimize deadlocks?

928

---

When you should use a low fill factor?

980

---

tell me the disaster recovery plan

2500

---

What are the different types of indexes?

1090

---

How to send email from database?

992

---

What does <> symbol mean?

950

---

What is 3nf normalization?

975

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1058

---

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

190

---

Explain the cursor lock types?

1028

---

Tell me the phases a transaction has to undergo?

944

---

Explain cursor as data base object?

1018

---

What is the osql utility?

941

---

Explain why variables called the most powerful component of ssis?

1068

---