Answer Posted / azuan

example

explain analyze select br_loc,count(insp_id) from insp where
date_create between '2010-07-01 00:00:00' and '2010-07-31
23:59:59' group by br_loc

What is self-join and what is the requirement of self-join?

1191

---

What is a recursive stored procedure?

1253

---

How many types of index are there?

1100

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2610

---

How many triggers can be applied to a table?

1124

---

Explain the the delete statements in sql?

1115

---

Can we use two order by clause in query?

1015

---

What is pragma in pl sql?

1183

---

What is sql select statement?

1085

---

What is query optimization in sql?

1041

---

What is sql basics?

1081

---

what is text? : Sql dba

1118

---

Can we insert data in view?

1008

---

What is cursor and why it is required?

1256

---

When sql appeared?

1148

---