Related InterviewSolutions

• How will you achieve record level locking in DB2 versions where record level locking is not allowed?
• What is DSNDB07? What does it do?
• Is there any specific reason why SELECT is not preferred in embedded SQL programs?
• What is the RUN STATS that was mentioned in the previous answer?
• Let us say that I have a program it uses dynamic SQL. It has been working fine till now, however, lately, I have found that the performance has been affected and deteriorated. Can you guess what can be the reason behind this?
• What are SPUFI and QMF? What is the difference between them?
• In a COBOL-DB2 program, where are all the SQL statements coded?
• What are ACQUIRE and RELEASE in BIND?
• Let us say that we have a Student Database in which we have the details of the students like their names, address, attendance percentage, etc. Now we run an SQL Query that says: SELECT AVG ATTENDANCE FROM STUDENTS.
• Is it possible for you to alter the table (adding a column to it) while some other person is accessing the table and even updating some values in it?