| Snaprecruit.com
| Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
Interview question based on skill :
Back
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
Correct Answer is :
We should use cursor in all cases