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: Megami Dumuro
Country: Ghana
Language: English (Spanish)
Genre: Finance
Published (Last): 2 April 2006
Pages: 363
PDF File Size: 7.44 Mb
ePub File Size: 4.32 Mb
ISBN: 765-9-75852-489-4
Downloads: 39284
Price: Free* [*Free Regsitration Required]
Uploader: Meztijar

Db2 Udb Interview Questions And Answers Pdf

Gregoriev please call Crime Stoppers at The primary use of DCLGEN comes during the pre-compilation phase where it helps in detecting the misspelt column names. If you have any information on the whereabouts of Ms. Call for more information.

Windows Which Windows utilities would you use to do your job? Here is an outline of questions and topics I recently prepared for interviewing new candidates for my current client. Use our job search engine to find and What do you want to know? If you create an indexit will sort the corresponding column If you are given with a query, how you tune it? For standard maintenance how would you use runstats and reorgs? DB2 database administration answes services: Performance Describe operating system metrics you would check for performance problems, and what numbers might indicate a problem.

What are the parms that needs to be set to take an online back of the DB? Based on a work at www.


Top 50 DB2 Interview Questions & Answers

Vertical portioned tables Whats snow flow schema?? Cursor stability is the property that tells the DB2 that the values of database that are read by making use of this application gets da while the data is used.

How might you use a Unix utility to streamline or automate your work? DB2 product is extended with the support of. Does runstats do a sort? Since DCLGEN is just a tool, it will only generate variable definitions for the host and reduces the chances of errors.

How to enhance the performance of the application for sorting? Can I import a file of extension WSF?

If Solaris Cluster, ask relevant questions. Have you installed DB2 udb on a linux server?? Following a DB2 update statement, what is the quickest way to compute the total number of updated rows?

Db2 Udb Interview Questions And Answers Pdf

Use staging tables If application team is contacting you telling the application is running very slowwhat all things you will check out? What are the advantages and disadvantages of each? Server physical and swap virtual memory, disk storage amount and typeand number and type of processors. Filed in DB2 – the human side and tagged candidatecertificationdb2dbainterview ufb, questions.

United Nations Jobs Vacancies. This is the table that contains information on the links that exists between the asnwers created through referential constraints. What is a reorg? More than one DB2 application process can access the same data at the same time, is known as concurrency.

How can I view the SQL that is still in dynamic package cache? Have you worked in portioned db?


DB2 UDB Interview Questions Answers

Try to get as many as possible. If only I could remember all of these questions during an interview… Reply.

Buffer manager can be considered as the component inside DB2 that helps in transferring data between virtual as well as external medium. Diff between import and load?

For each and every row that is qualified, the evaluation of correlated sub-query is a must. DBRMs form inputs that are helpful in the binding process. With three space station fliers heading home Sunday after. What are the differences between offline and online backup? The buffer pool is a reserved main storage, which is to satisfy the buffering requirements for one or more table spaces or indexes.

How do you document your work? Thanks for answers, here are few basic DB2 interview questions and answers. DB2 Health Monitor Problems. No Have you worked in portioned db? Build phase of load utility does a sort? How can you make sure you only return 10 rows? A geek with outside technical interests is ideal. 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.