Answer Posted / krish

triggers of 4 types
1.row & statement triggers
2.before & after triggers
3.instead of triggers
4.trigger on system event & user event

What is exception? What are the types of exceptions?

1116

---

Can we rollback after truncate?

1073

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1013

---

In a distributed database system, can we execute two queries simultaneously?

1156

---

how do you know the version of your mysql server? : Sql dba

1048

---

What is the order of sql select?

1089

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1633

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

1127

---

What are hotfixes and patches?

987

---

how would you get the current date in mysql? : Sql dba

1018

---

What is sqlcontext?

1147

---

Can we join same table in sql?

1068

---

What is the need of a partition key?

1030

---

What are commit, rollback, and savepoint?

1049

---

How do I run a pl sql program?

1191

---