The MySQL keyword to create a cursor is:
A)DECLARE CURSOR {CursorName}.
B)OPEN {CursorName}.
C)FETCH.
D)CLOSE {CursorName}.
E)None of the above.

Question

Quizplus · Accepted Answer

The keyword to create a cursor in MySQL is "DECLARE CURSOR {CursorName}". This is used to define a cursor and give it a name, which can then be used to open and execute commands on the cursor.

B, C, and D are all keywords used with cursors, but they do not create the cursor itself. "OPEN {CursorName}" opens an existing cursor, "FETCH" retrieves the next row from a cursor, and "CLOSE {CursorName}" closes an open cursor.

E is not a valid answer as there is a keyword in MySQL specifically for creating cursors.

The MySQL Keyword to Create a Cursor Is