|
Related Questions |
View Answer |
|
31) How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only )
|
View Answer
|
|
30) When you COMMIT, is the cursor closed? - drona db2 interview questions
|
View Answer
|
|
29) Can you have more than one cursor open at any one time in a program ? �
|
View Answer
|
|
28) Is DECLARE CURSOR executable?
|
View Answer
|
|
27) What happens when you say OPEN CURSOR?
|
View Answer
|
|
26) How do you specify and use a cursor in a COBOL program? �
|
View Answer
|
|
25) Where would you specify the DECLARE CURSOR statement? �
|
View Answer
|
|
24) How would you retrieve rows from a DB2 table in embedded SQL? �
|
View Answer
|
|
23) What is a cursor? why should it be used? �
|
View Answer
|
|
22) What are the issues related with correlated subqueries? �
???
|
View Answer
|
|
21) Why SELECT * is not preferred in embedded SQL programs?
|
View Answer
|
|
20) What is the result of this query if no rows are selected:
|
View Answer
|
|
19) Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?
|
View Answer
|
|
18) What do you accomplish by GROUP BY ... HAVING clause? �
|
View Answer
|
|
17) What is the meaning of underscore ( �_� ) in the LIKE statement? �
|
View Answer
|
|
16) When do you use a LIKE statement?
|
View Answer
|
|
15) What is 'LIKE' used for in WHERE clause? What are the wildcard characters? �
|
View Answer
|
|
13) In the WHERE clause what is BETWEEN and IN? �
|
View Answer
|
|
12) What is the restriction on using UNION in embedded SQL?
|
View Answer
|
|
11) What is UNION,UNION ALL? �
|
View Answer
|