Answer Posted / ashish jain

create table emp

empid empname
----- --------
101 a
102 b
103 a
104 c
105 a

select empname from emp where count(empname)>1

What is proper subset of candidate key?

957

---

What is primary key, unique key, and foreign key?

937

---

What is function of ROLLUP ?

1053

---

How does normalization work?

886

---

How to select all columns of all rows from a table with a select statement in ms sql server?

1064

---

What are the difference between primary key and unique key? : sql server database administration

917

---

How you can find out if an index is useful to the optimizer?

888

---

what is an index? : Sql server database administration

948

---

How can sql server instances be hidden?

909

---

What are pessimistic lock and optimistic lock?

1015

---

What are the instances when triggers are appropriate?

944

---

How to make a column nullable?

1059

---

What is an identity?

953

---

Explain query editor regions

1016

---

How many databases can we create in a single server?

205

---