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: Aracage Maucage
Country: Chad
Language: English (Spanish)
Genre: Politics
Published (Last): 19 December 2006
Pages: 22
PDF File Size: 10.22 Mb
ePub File Size: 9.96 Mb
ISBN: 648-9-62371-871-7
Downloads: 3549
Price: Free* [*Free Regsitration Required]
Uploader: Aratilar

If Solaris Cluster, ask relevant questions. If so, please give the SQL query for this? How might you use a Unix utility to streamline or automate your work?

When can you be sure that a quary will return onlyl one row? What is the FREE command? Which catalog tables contain authorization information? What are the four lockable units for DB2? More than one DB2 application process can access the same data at the same time, is known as concurrency.

Which catalog tables stores referential constraints? Describe the components of a table that are needed to establish referential integrity between two tables. What are the three tyes of page locks that can be held? How will you delete duplicate records from a table? Describe a correlated subquery.

What aswers db2 udb dba interview questions and answers maintenance needs to be done with logs? Node anewers IP address and port I. Whats the difference between logretain and userexit? What is referential integrity? Shubham Shahane Sep 12, What is the function of the Data Manager? How db2 udb dba interview questions and answers one determine the status of a tablespace?

What is a data type?

What is the difference between primary key and unique index? What does DML stand for and what are some examples of it? If you create an indexit will sort the corresponding column. What are the parms that needs to be set to take an online back of the DB? What is the difference between creating buffer pool with immediate option and default option??

How does DB2 determine what lock-size to use? Where could you look if you db2 udb dba interview questions and answers a question about whether a column has been defined as an index? How to see the structure of DB2 table? How is the status of a utility reset after qufstions has been ingerview by DB2?

Describe two ways to create a primary key. It invokes other system components to perform logging, locking etc. What are foreign keys?

What is dynamic SQL? What is the Manimum number of characters that a tablename can have? Data page can be considered as a unit that is capable of retrieving data from the database.

Diff between import and load? What is the difference between Where and Having Clause?

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

Thanks for answers, here are few basic DB2 interview questions and answers. What is a predicate? Having trouble reading this image? How can tablespace be moved to another DASD volume that is allocated for that tablespace?

Your email address will not be published. If not, why would you use it at all?

DB2 UDB Interview Questions Answers

What are the isolation levals possible? What is a result table? Usually, which is more important for DB2 system performance Qnswers there any advantage to denormalizing DB2 tables? What db2 udb dba interview questions and answers is used as input to the bind process?

When is the access path determined for dynamic SQL? It also permits data to be accessed by other applications who can reference the committed data. What are some characteristics of columns that benefit from indexes?