Db2 udb interview questions and answers

For each and every row that is qualified, the evaluation of correlated sub-query is a must. What information is used as input to the bind process? Performance Describe operating system metrics you would check for performance problems, and what numbers might indicate a problem.

Uploader: Kajinos
Date Added: 17 May 2015
File Size: 50.56 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 54610
Price: Free* [*Free Regsitration Required]





Whats the difference between logretain and userexit? Besides these questions, I would also be looking for the following qualities in a strong candidate:. Have you been part of design? This is the table that contains information on the links that exists between the tables created through referential constraints. Vertical portioned tables Whats snow flow schema?? How to easily assign an incremented an unique value to a column?

What are the isolation levals possible? If a transaction takes an Update lock on some data, then other transactions can only get only Shared lock on it. How can transaction design affect performance? Following a DB2 update statement, what is the quickest way to compute the total number of updated rows? Which utilities do a sort? When first setting up and then later maintaining a database, what would be your main concerns with backup? How do we control or intedview the allocation of these memory sets?

Which catalog tables contain authorization information?

Can DASD types assigned to storage groups be intermixed? What is the FREE command?

Top 50 DB2 Interview Questions & Answers

What is a cursor and what is its function? What is the function of the Data Manager? In terms of DB2 indexing, what is the root page? Describe the components of a table that are needed to establish referential integrity between two tables.

Compare a subselect to a join? What should be specified along with a cursor in order to continue updating process after commit?

What are some characteristics of columns that benefit from indexes? Are you a Database Administrator? It also permits data to be accessed by other applications who can reference the committed data.

DB2 Interview Questions

What is a buffer pool? What is an inner join, and an outer join? Second it really doesn't matter much questlons you could not answer few questions but it matters that whatever you answered, you must have answered with confidence.

What is index cardinality? Interiew you are fresher then interviewer does not expect you will answer very complex questions, rather you have to make your basics concepts very an. DBRM is the input to the bind process which is produced in the pre-compile step. Data page also contains information regarding the catalog or user that are part of the database.

What are the three DB2 date and time data types and their associated functions? How will you delete duplicate records from a table?

We at tutorialspoint wish you best luck to have a good interviewer and all the very best for your future endeavor.

What is a collection?

2 thoughts on “Db2 udb interview questions and answers”

Leave a Reply

Your email address will not be published. Required fields are marked *