Answer Posted / rohit

I hv a question..
in my textbooks, triggers types are described as
1) table trigger
2) system event trigger
3) user event trigger

is this also right??

How can get second highest salary in sql?

991

---

How do you write a complex sql query?

1088

---

What are the string functions in sql?

980

---

What does over partition by mean in sql?

983

---

What are the types of index in sql?

1071

---

Can we rollback after truncate?

1033

---

What are the advantages of sql?

1055

---

Which join is like an inner join?

1029

---

Explain how can you save or place your msg in a table?

1029

---

How to use boolean type in select statement?

1083

---

What is sharding in sql?

990

---

what is a constraint? : Sql dba

1175

---

Can a table have no primary key?

1065

---

Explain two easy sql optimizations.

1016

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2226

---