Cursors Interview Questions

Cursors interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Life cycle of typical cursor involves ______ steps in SQL Server.

A. 2

B. 3

C. 4

D. 5

Correct Answer is : 5

2. Point out the correct statement :

A. A Cursor is opened and populated by executing the SQL statement defined by the cursor

B. After data manipulation, we should close the cursor explicitly

C. A cursor is declared by defining the SQL statement that returns a result set

D. All of the mentioned

Correct Answer is : All of the mentioned

3. How many type of cursor is present in SQL Server ?

A. 3

B. 4

C. 5

D. 6

Correct Answer is : 4

4. Various alternatives to cursor in SQL Server are :

A. FOR

B. IF..ELSE

C. WHILE

D. All of the mentioned

Correct Answer is : WHILE

5. Point out the wrong statement :

A. We should use cursor in all cases

B. A static cursor can move forward and backward direction

C. A forward only cursor is the fastest cursor

D. All of the mentioned

Correct Answer is : We should use cursor in all cases

Cursors interview questions