Is Cursor exicutable ?

Question Posted / naveen87ginjupalli

3 Answers
7915 Views
TetraSoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Is Cursor exicutable ?..

Answer / narayana reddy

expect declare cursor remaining all are
executables(open,fetch,close)

Is This Answer Correct ?

15 Yes

0 No

Is Cursor exicutable ?..

Answer / raghu

yes,open cursor is executable

Is This Answer Correct ?

0 Yes

0 No

Is Cursor exicutable ?..

Answer / naveen87ginjupalli

No,

Is This Answer Correct ?

1 Yes

4 No

Post New Answer

More DB2 Interview Questions

What r the comman abends in db2, jcl and cobol???????

0 Answers Mphasis,

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers

What is Skeleton cursor table (SKCT)?

2 Answers

What if we fail to give values in columns declared as NOT NULL ?

3 Answers Cap Gemini,

What is a DBRM, PLAN ?

3 Answers

what is load and unload in db2

1 Answers IBM,

what is the input to PLAN? what is the input to DBRM?

4 Answers

What are the various isolation levels possible?

0 Answers

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers HeadStrong,

What is cascading rollback?

0 Answers

What is the use of db2 optimizer?

0 Answers

For more DB2 Interview Questions Click Here