Answer Posted / anusha

Cursor is a private work area .there are
three types if cursors
1.implicit cursor: implicit cursors is create,open and
closed by system automatically.
2.explicit cursor: explicitly user can create,open and close
cursors.
3. ref cursor: Reference cursor is a cursor dynamically (at
Run time) we can pass the column names or table names.

Can delete statement be rollbacked?

992

---

Does sql full backup truncate logs?

1029

---

What is query execution plan in sql?

1194

---

What is #table in sql?

1111

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1049

---

How do you drop a trigger?

997

---

How to check if a column is nullable before setting to nullable?

1133

---

What are the types of variable use in pl sql?

1092

---

How can we find duplicate records in a table?

952

---

how to get a list of all tables in a database? : Sql dba

981

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1048

---

what is the command line end user interface - mysql? : Sql dba

987

---

What are joins in sql?

1050

---

How many sql statements are used? Define them.

1046

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1025

---