1 Sep Mainframe DB2 UDB Admin Interview Questions, FAQs. Answer: Both online and offline are there, online reorg allows other transaction to. 15 Aug db2 udb dbA Interview Qustions. 1st Day Thanks for answers, here are few basic DB2 interview questions and answers. ReplyDelete. 29 Sep You’ll likely be asked difficult questions during the interview. Top 20 db2 interview questions and answers If you need top 7 free ebooks below for Tell me about yourself? .. online training for IBM DB2 LUW UDB DBA.

Author: Fejin Taull
Country: Georgia
Language: English (Spanish)
Genre: Automotive
Published (Last): 17 October 2018
Pages: 326
PDF File Size: 3.71 Mb
ePub File Size: 11.78 Mb
ISBN: 894-8-70404-492-5
Downloads: 33053
Price: Free* [*Free Regsitration Required]
Uploader: Shataxe

What is a collection?

DBA Interview Questions and Answers – DB2 Server Operations (DBA DB2)

Save my name, email, and website in this browser for the next time I comment. What command disables roll-forward recovery? What are column-name qualifier used? These include intent locks.

Defines the maximum number of private memory pages to be used for private sorts, or the maximum number of shared memory pages to be used for shared sorts. Db2 udb dba interview questions and answers server and monitor server configuration.

Describe a correlated subquery. Someone with a background in database development and some years in at least one non-database programming language; someone annd can understand development challenges.


What is a lock?

DB2 UDB Interview Questions Answers

What is an asychronous write? What is the syntax required for the creation of a cursor? Email address will not be displayed with the comment. What will the FREE command do to dbx plan? If not, why would you use it at all? How can one determine the status of a tablespace?

Whats the difference between Load and import? What is the function of buffer manager? Please enter a valid email address.

DB2 ( IBM Database 2 ) Interview Questions

Build phase of load utility does a sort? What is the error code for Unique Index Violation?

How does the processing of a correlated subquery differ from a non correlated subquery? When will you use it? What are simple, segmented and partitioned table spaces?

It also permits data to be accessed by other applications who can reference the committed data.

The process that builds access paths to the DB2 table is known as bind. Cursor stability is the property that tells the DB2 that the values of database that are read by making use of this application gets protected while the intedview is used.

What is a reorg? Following a DB2 update statement, what is the quickest way to db2 udb dba interview questions and answers the total number of updated rows? How do you insert a record with a nullable colunm? What does the SQLcode of pertain to? Both online and offline are there, online reorg allows other transaction to access the tables.


What is the difference between join and union?

In a private sortthe agent private memory is affected. What are the db cfg parms which affect the back up strategy? Interiew technique is used to udbb data from more than one table in a single SQL statement? What is a clustering index? Saturday, Db2 udb dba interview questions and answers 15, db2 udb dbA Interview Qustions. What is correlation names? Have you done server installation? Post a Comment Your email is never published nor shared.

For each and every row that is qualified, the evaluation of correlated sub-query is a must. How do you document your work? What is a base table?