Touch base the given DB2 key sections before going for any interview. I am confidently saying you will get sure success.
Category: DB2
Fetch first 1 Row only real usage in DB2
In DB2 database there are many ways to achieve performance. I explained one way here. Read more.
Three top DB2 Index questions you need to know
Index is popular object in DB2 SQL. Popular questions to your instant knowledge given for quick reference.
Cursor hold on COMMIT you need to know these points
All you need to know about Cursor the real use and how it works on commit or Rollback scenarios. Really useful information for SQL professionals.
DBA is your role read now these top questions
Database administrator’s function is not cakewalk. It is involved many functions starting from creating a database to maintain its objects. DBA has to monitor all of its objects such as Tables, Views, Indexes, Triggers, Stored procedures etc. Any database these are comman.
Top DB2 authority questions DBA to know
DBA primary role is access- control. DB2 has many in-built security features and authority controls. These questions really good to know by DBA.
REORGCHK utility top role in DB2 maintenance
REORG is a useful utility in DB2. While Loading or Unloading, you get different errors. Run this utility to resolve your errors.
DB2 Load Utility top parameters example JCL
DB2 Load utility with example and explained the key phrases. These are really good to have knowledge before you start working on it.
