1.) Define DB2. DB2 is a Database Management System for the MVS Operating System where, DB2 is a subsystem of MVS Operating System. A.6 I had DB2 V on Windows after which I uninstalled it and then. IBM DB2 UDB Interview Questions Answers. Mainframe DB2 UDB Admin Interview Questions, FAQs. What is online reorg/offline?.
|Published (Last):||20 October 2016|
|PDF File Size:||8.40 Mb|
|ePub File Size:||18.62 Mb|
|Price:||Free* [*Free Regsitration Required]|
Data page also contains information qusetions the catalog or user that are part of the database. Here is an outline of questions and topics I recently prepared for interviewing new candidates for my current client. 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. Thanks for interfiew, here are few basic DB2 interview questions and answers.
What is the Manimum number of characters that a tablename can have? What is a clustered index? What is the name of the default DB2 catalog database? How many clustering indexes can be defined ddba a table? Saturday, August 15, db2 udb dbA Interview Qustions. Where besides the DB2 catalog is database object information stored by DB2?
If you are given with a query, how you tune it? How do you achieve record level locking in DB2 versions when record quesyions locking is not allowed? What are the four lockable units for DB2? How to define the data items to receive the fetch items for the SQL?
What technique is used to retrieve data from more than one table in a single SQL statement? What is a composite index and how does it differ from a multiple index? When can you be sure that a quary will return onlyl one row? Will the lock be released after I am done with that page?
Can DASD types assigned to storage groups be intermixed? Are you a Database Administrator?
Interview Questions: db2 udb dbA Interview Qustions
OS kernel configuration; E. How can you quickly intdrview out the number of rows updated after an update statement? How is the status of a utility reset after it has been stopped by DB2?
How do you filter out the rows retrieved from a DB2 table? What is the size of a data page? Windows Which Windows utilities would you use to do your job?
DB2 UDB Interview Questions Answers
How many sub queries can you combine together? What is the difference between group by and order by?
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?
In which column of which DB2 catalog would you find the length of the rows for all tables? If only I could remember all of these questions during an interview… Reply. What are the three DB2 date and time data types and their associated functions? The reason for the same is that the pre-compiler never refers to the catalogue tables of DB2.
IBM DB2 FAQ – Frequently Asked Questions about DB2 for Linux, UNIX and Windows – United States
What are a precompiler? Have you been part of design? What is lock escalation? Why use it Explain an outer join? What is the purpose of the DSNC transaction? What are some SQL aggregates and other built-in functions?