Answer Posted / k.vanitha

CREATE TABLE Employee (NAME VARCHAR(20), SALARY int);

INSERT INTO employee VALUES (
'RAMESH',
9000);
INSERT INTO employee VALUES (
'RAJESH',
10000);

SELECT Left(upper(NAME),1) +
lower(substring(NAME,2,len(NAME))) FROM employee

What are the different acid properties?

1012

---

Can I delete event logs?

870

---

How do you create a clustered index?

997

---

Define normalisation?

1060

---

What is full outer join in sql server joins?

981

---

Do you know what is difference between index seek vs. Index scan?

896

---

Why use stored procedures in sql server?

951

---

Can you pass expressions to function parameters?

1030

---

Tell me what do we need queues in sql service broker?

925

---

What is sql server profiler?

950

---

Tell me what is the significance of null value and why should we avoid permitting null values?

928

---

What is partition index in sql server?

1046

---

What is difference between count (*) and count column?

838

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1985

---

What is the difference between ‘having’ clause and a ‘where’ clause?

990

---