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 a fill factor?

1140

---

Explain about system stored procedure?

1078

---

What are alternate keys?

1031

---

What happens if null values are involved in string operations?

1030

---

Tell me the phases a transaction has to undergo?

1019

---

How can I add Reporting Services reports to my application?

132

---

Explain few examples of stored procedure over triggers?

1115

---

why would you call update statistics? : Sql server database administration

1160

---

Write a query for primary key constraint with identity key word?

1082

---

How to get a list of columns in a view using the "sp_help" stored procedure?

1090

---

How to encrypt data between dialogs?

1169

---

Do you have any idea about the tcl commands?

1015

---

can we have a nested transaction? : Sql server database administration

1193

---

What is Federation and Federation Member?

94

---

What is format parameter in ssrs?

150

---