Answer Posted / srilakshmi paleti

1)Implicit cursor
2)Explicit Cursor

EXPLANATION OF
1)IMPLICIT CURSOR : When ever user performs any DML
operation automatically implicit cursors will raise. User
noneed to create,open,fetch,close the cursor.In PLSQL
select statement also it will work.

2)EXPLICIT CURSOR: User has to create,open,fetch and close
the cursor.

How do we represent comments in oracle?

1048

---

Give the different types of rollback segments.

1031

---

Design database draw er diagram for a certain scenario ?

4579

---

what is the scripts in data base?

2155

---

How to resolve the ORA-39133 error in Oracle?

1122

---

What is null value in oracle?

1097

---

How to define a variable to match a table column data type?

988

---

What is a sub query? What are its various types?

1179

---

How to open and close an explicit cursor in oracle?

1058

---

What is ASM (Automatic Storage Management) in Oracle?

1197

---

What is the exact use of Collections?

2143

---

Explain the use of constraints option in exp command.

1048

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2555

---

What happens if the update subquery returns multiple rows?

1116

---

How to create additional tablespaces for an new database?

1029

---