We have taken full care to give the best answers to all the questions. Do comment your thoughts! Read More 3. How to find the number of rows in a DB2 table? Subscribe to our youtube Channel.

Author:Milrajas Moogugore
Country:Dominican Republic
Language:English (Spanish)
Published (Last):17 November 2004
PDF File Size:5.23 Mb
ePub File Size:14.80 Mb
Price:Free* [*Free Regsitration Required]

Next Page Dear readers, these DB2 Interview Questions have been designed specially to get you acquainted with the nature of questions you may encounter during your interview for the subject of DB2. S9 4 COMP is the picture clause of a null indicator. Which component checks DB2 deadlocks? Which component is responsible for execution of SQL statements? Database services component is responsible for execution of SQL statements and it manages buffer pool also.

Which component handles DB2 startup and shutdown? System services component handles DB2 startup and shutdown. On which level we can apply the locks? In which step we specify the isolation level? In Bind step we specify the isolation level. State whether true or false? Cursors are used to handle single row selections at a time.

They are data structure which hold all the results of a query. This statement is incorrect as cursors are used to handle multiple row selections at a time. Host variables cannot be group items but they may be grouped together in host structure. They can be Renamed or Redefined. When a table is dropped all the alias get dropped automatically. This statement is incorrect. Synonyms get dropped automatically when we drop the table but alias of the table remains there.

We need to manually drop the alias. What action DB2 takes when a program abends? When a program abends in middle of some transaction then DB2 performs a auto rollback. If a transaction takes a Update lock on some data, then other transactions can get what type of lock?

If a transaction takes an Update lock on some data, then other transactions can only get only Shared lock on it. If a transaction takes a Shared lock on some data, then other transactions can get what type of lock?

If a transaction takes a Shared lock on some data, then other transactions can get either a Shared or Update lock on it. How the locks can be classified? Locks can be classified based on size, duration and mode.

Which utility is used to load data into a table from a sequential file? Load utility is used to load data into tables. Which utility reclaims space from pages when some rows were deleted? Reorg utility is used for reorganization of data on physical storage. Which utility provides statistical information such as the number of pages and rows and stores them in Catalog tables? Runstats utility updated the catalog tables with the statistical information. Which command is used to commit a transaction in CICS program?

Which isolation level provides maximum concurrency? Uncommitted read provides maximum concurrency. Which isolation level ensures highest data integrity? If a transaction has an exclusive lock on some data, then what are the other types of lock which can be applied on it? A transaction gets an Exclusive lock when it is about to write at that time no other lock can be applied on it.

What is the input to the bind process? DBRM is the input to the bind process which is produced in the pre-compile step. How you will count the number of rows from a table TAB? What does application plan contains? Then for normal functionality of application what should we do? We will bind only that package which contains the modified DBRM. No need to bind all the packages. What does a positive SQL code indicates?

A negative SQL code indicates a failure while a positive one indicates an exception. Which statement is used to revoke the access from a database? Which statement is used to authorize access on database tables? In which statement you can define primary key? How many primary keys can be declared on a table? A table can have only one primary key.

Write a query to delete a table from database. Write the query to delete all the rows from a table. Char data type maximum size is of bytes. Varchar data type maximum size is of bytes. In which format index in stored? An indexed is stored in B-tree format.

Which index must be present for partitioned table space? A partitioned table space must have a clustered index. Suppose a table A has an Alias named AL1. Which of the query is correct to drop the AL1 alias?

How many clustering index we can have for a single table? We can have only one clustering index for a table. What is Next? Further you can go through your past assignments you have done with the subject and make sure you are able to speak confidently on them. If you are fresher then interviewer does not expect you will answer very complex questions, rather you have to make your basics concepts very strong.

So just feel confident during your interview. We at tutorialspoint wish you best luck to have a good interviewer and all the very best for your future endeavor.


DB2 Questions and Answers

Both online and offline are there, online reorg allows other transaction to access the tables. If you create an index , it will sort the corresponding column If you are given with a query, how you tune it? Does runstats do a sort? Nope ;-0 first level IBM Team only does it!! Disaster Recovery? What are the db cfg parms which affect the back up strategy?


Top DB2 Interview Questions and Answers

BP32 Define clustering index. Clustering index is a type of index, which locates the table rows and determines how to group the rows together in the tablespace. What is concurrency? More than one DB2 application process can access the same data at the same time, is known as concurrency. However, problems can happen such as, lost updates access to unrepeatable reads and uncommitted data. Explain the Function done by data manager?


DB2 Interview Questions

A geek with outside technical interests is ideal. Someone with a background in database development and some years in at least one non-database programming language; someone who can understand development challenges. How can you see physical memory core utilization by a Unix DB2 server? Tell us something about DB2 memory structure root is Instance shared memory, below that is Database shared memory; within each Database there is Application Group shared memory, then each Agent has private memory. How do we control or influence the allocation of these memory sets? Try to get as many as possible. Could include: A.

Related Articles