Answer Posted / avi007

cursor-
1 cursor is small memory area to perform selection on the
one or more table.
2 cursor is a variable which is 2 dimentional array, it is
handling, storing and processin multiple rows.
3 storing data temporarily.
4 fetching rows from top to bottom.
5 fetching row one at a time.

procedure -
1 procedure is an object of database.
2 need to compile and execute.
3 dml operation performed in the block.

Can you rollback after commit?

973

---

what is the difference between a web-garden and a web-farm? : Sql dba

1072

---

What is dml and ddl?

946

---

how to fetch alternate records from a table? : Sql dba

1097

---

What is a constraint?

1005

---

Which is faster joins or subqueries?

984

---

What is the primary key?

943

---

What does where 1 1 mean in sql?

1024

---

Can you join views in sql?

947

---

What do you mean by dbms? What are its different types?

1009

---

What is #table in sql?

1077

---

what are the types of subquery? : Sql dba

1096

---

What is the purpose of a secondary key?

950

---

is mysql query is case sensitive? : Sql dba

1083

---

what are the security recommendations while using mysql? : Sql dba

1102

---