0 Comment

1 Sep Mainframe DB2 UDB Admin Interview Questions, FAQs. Answer: Both online and offline are there, online reorg allows other transaction to. A free inside look at DB2 Database Administrator interview questions and General DB2 LUW DBA questions, if you know DB2LUW you will do fine. 1 Answer. 1.) Define DB2. DB2 is a Database Management System for the MVS Operating System where, DB2 is a subsystem of MVS Operating System. 2.) What is the.

Author: Nikole Mezigami
Country: Dominican Republic
Language: English (Spanish)
Genre: Marketing
Published (Last): 7 August 2017
Pages: 323
PDF File Size: 6.48 Mb
ePub File Size: 13.21 Mb
ISBN: 528-1-32985-928-6
Downloads: 77307
Price: Free* [*Free Regsitration Required]
Uploader: Arakus

Top 50 DB2 Interview Questions & Answers

At pre-compile time, the table or view descriptions are then used to check the validity of Qnd statements. 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.

The log files display a summary of the resource demands for each memory consumer for each tuning interval. How to see the structure of DB2 table?


What does the SQLcode of pertain to? Where could you look if you had a question about whether a column has been defined as an index? Whats snow flow schema?? How is a typical DB2 batch program executed?

What are column-name qualifier used? What is a thread?

Build phase of load utility does a sort? What are the 4 environments which can access DB2? For each and every row that is qualified, the evaluation of correlated sub-query is a must. What is the database descriptor? What is an intent lock? What is index cardinality? The parameter is useful in managing in a shared environment with limited memory and high levels of connections.

Explain what a plan? Name is required to post a comment.

Where besides the DB2 catalog is database questtions information stored by DB2? What is SQLcode – ? What is referential integrity? What are a precompiler?

DB2 UDB Interview Questions Answers

If not, why would you use it at all? YES if it is still in dynamic package cache. What does DML stand for and what are some examples of it? Are you a Database Administrator? Server physical and swap virtual memory, disk anwsers amount and typeand number and type of processors F.


Post a Comment Your email is never published nor shared. Filed in DB2 – the xba side and tagged candidatecertificationdb2dbainterviewquestions. Have you done server intervieq The letters and numbers you entered did not match the image.

Compare a subselect to a join? This is the table that contains information on the links that exists between the tables created through referential constraints. There is a certain point in a program at which DB2 acquires or perhaps releases the locks against tables as well as table-spaces. What will the DB2 optimizer do? Data page can be considered as a unit that is capable of retrieving data from the database.

Thanks for answers, here are few basic DB2 interview qhestions and answers.