Here are top 34 objective type sample DB2 Interview questions and their answers are given just below to them. These sample questions are framed by experts. db2 udb dbA Interview Qustions. 1st Day . Thanks for answers, here are few basic DB2 interview questions and answers. ReplyDelete. Mainframe DB2 UDB Admin Interview Questions, FAQs. Answer: Both online and offline are there, online reorg allows other transaction to.

Author: Sazuru Mejora
Country: Serbia
Language: English (Spanish)
Genre: Video
Published (Last): 1 May 2005
Pages: 478
PDF File Size: 3.17 Mb
ePub File Size: 19.87 Mb
ISBN: 177-7-68254-863-6
Downloads: 21001
Price: Free* [*Free Regsitration Required]
Uploader: Akijora

Someone with a background in database development and some years in at least one non-database programming language; someone who can understand development challenges. If only I could remember all of these questions during an interview… Reply. What kind of maintenance needs to be done with logs?

Call for more information. Based on a work at www. Server physical and swap virtual memory, disk storage amount and typeand number and type of processors.

What database configuration parameter establishes the minimum number of logs? DB2 is a database product from IBM. DBRMs form inputs that are helpful in the ansders process.

What do you want to know? Besides these questions, I would also be looking for the following qualities in a strong candidate:. Load is faster than import, import is like bulk insert, every thing goes to the transaction log.

DB2 UDB Interview Questions Answers

Performance Describe operating system metrics you would iterview for performance problems, and what numbers might indicate a problem. How can transaction design affect performance?


Describe two ways to create a primary key. Whats snow flow schema??

IBM DB2 FAQ – Frequently Asked Questions about DB2 for Linux, UNIX and Windows – United States

Clustering index is a type of index, which locates the table rows and determines how to group the rows together in the tablespace.

The buffer manager reduces the quantity of physical input as well as output operations that are actually performed by making use of buffering techniques that are highly sophisticated. How to enhance the performance of the application for sorting? There is a certain point in a program at which DB2 acquires or perhaps releases the locks against tables as well as table-spaces.

For each and every row that is qualified, the evaluation of correlated sub-query is a must. Until a COMMIT is taken table locks are retained, which can prevent other concurrent processes from answerrs the dh2 resulting in lock wait.

Diff between import and load? Have you been part of design? When first setting up and then later maintaining a database, what would be your main concerns with backup? Following a DB2 update statement, what is the quickest way to compute the total number of updated rows?

How can tablespace be moved to another DASD volume that is allocated for that tablespace? This should also be matched with plan ID. Thanks for answers, here are few basic DB2 interview questions and answers.

The class will address the questuons of child sexual abuse prevention, recognition and response.

Interview Questions: db2 udb dbA Interview Qustions

It is specified as a condition or criteria to ensure data integrity. In case if there are large questionns to be done, then the resource utilization is high accordingly. Sign-in to My Verizon today!


How might you use a Unix utility to streamline or automate your work?

Load utility, if I want to load data with out any chance of taking the tablespace to back up pending state? Table DB snap shop, Application snapshot,sql snap shoptcpu utilization using top, check is there any stale connection connections that very old.

Db2 Udb Interview Questions And Answers Pdf

Can I load a intervieew of extension WSF? Windows Which Windows utilities would you use to do your job? When an application use private sort? Which utilities do a sort? Data page can be considered as a unit that is capable of retrieving data from the database.

DB2 Health Monitor Problems.

What are the parms that needs to be set to take an online back of the DB? Here is an outline of questions and topics I recently prepared for anr new candidates for my current client.

The physical database is managed by the DB2 component called Data manager. Describe the components of a table that are needed to establish referential integrity between two tables.