SQL (Structured Query Language) Question:

Download Job Interview Questions and Answers PDF

Which of the following statements is true about implicit cursors?

SQL Interview Question
SQL Interview Question

Answer:

1. Implicit cursors are used for SQL statements that are not named.
2. Developers should use implicit cursors with great care.
3. Implicit cursors are used in cursor for loops to handle data processing.
4. Implicit cursors are no longer a feature in Oracle.

Download SQL Interview Questions And Answers PDF

Previous QuestionNext Question
Can a view be updated/inserted/deleted? If Yes - under what conditions?How would the developer define this variable using referential datatypes?