Answer Posted / adarsh pandey

select distinct mark from student_mark s
where (select count(distinct s1.mark) from student_mark s1
where s1.mark>=s.mark )=4;

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1198

---

Explain what is public role in sql server?

1135

---

How to count duplicated values in a column in ms sql server?

1095

---

What is normalization? What number of normalization shapes are there?

1109

---

Explain the flow of creating a cube? : sql server analysis services, ssas

1051

---

What is database replication? What are the different types of replication you can set up in sql server?

959

---

What is a hint?

994

---

How do you delete a data source?

1011

---

Comment,Datatypes are unlimited

2059

---

What is table constraint?

995

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

952

---

what is memory-optimized nonclustered indexes

1016

---

Explain the steps needed to create a scheduled job?

935

---

Explain an incremental backup?

1003

---

Write an sql query for deleting duplicate rows?

996

---