To answer this question, you need to understand the concept of cursors in DB2.
A cursor is a database object that allows you to retrieve and manipulate rows from a result set one at a time. When you open a cursor in DB2, it does not automatically fetch all the rows that meet the selection criteria and create a result set. Instead, it establishes a connection to the database and sets up a context for retrieving rows.
Therefore, the correct answer is:
B. No - When you open a cursor in DB2, it does not automatically get all rows that meet the selection criteria and create a result set.