DB2 Interview Questions and Answers

DB2 is a Relational DataBase Management System (RDBMS) originally introduced by IBM in 1983 to run on its MVS (Multiple Virtual Storage) mainframe platform. The name refers to the shift from the then prevalent hierarchical database model to the new relational model.
#db2 #interview #questions #and #answers

[@Oops404hd]

Cursor is generally used to handle 1 row at a time (though there is mechanism to handle multiple row at a time,those are special type(rowset,scrollable etc) of cursor).

[@sarojanak5165]

Thank you for making such a useful video

[@sundrisworld]

Do you think a mainframe computer operator handle a IMS DB2z roll?

[@venkatasatya4144]

Thanku for making this video and very useful..bro

[@interviewinsights]

Comments like this motivates me a lot, Thank you soooo much. And I can't even explain you the level of my happiness, how your comment made me feel today. THANK YOU SO MUCH AGAIN DEAR. 😊

[@saumyashivputra3944]

Timestamp will take 26 bytes not 10 bytes and date will take 10 bytes

[@Oops404hd]

Data type length is not same in DB2 & cobol. Timestamp - 26 in cobol ,10 in DB2 Date - 10 in cobol, 4 in db2

[@rakeshkothurudkp6522]

Timestamp 26 bytes

[@dharanipalanisamy9762]

That is for cobol

[@sudheerkomanapalli4412]

Actually yes...but 26 bytes for cobol equalant data type

[@durgabhavani1175]

Timestamp 26 bytes