DB2 Interview Questions and Answers
DB2 is the database management system that delivers a flexible and cost-effective database platform to build robust on demand business applications. DB2 further leverages your resources with broad support for open standards and popular development platforms like J2EE and Microsoft .NET. The DB2 family also includes solutions tailored for specific needs like business intelligence and advanced tooling. Whether your business is large or small, DB2 has a solution built and priced to meet your unique needs.
DB2 Interviews are getting tough these days as the technology grows faster. To get through the DB2 interview one needs to update him/herself in a regular manner. Having said that, just before the interview, it is very important to have a quick glance of the reputed DB2 questions and answers to make yourself comfortable during the interview process. This is where DoAnswers.com helps you in renewing yourself on DB2 and various other technologies interview preparation.
41. How does DB2 store NULL physically?
As an extra-byte prefix to the column value. physically, the null prefix is Hex '00' if the value is present and Hex 'FF' if it is not.
42. How does Db2 use multiple table indexes?
DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.
43. How is a typical DB2 batch pgm executed ?
1. Use DSN utility to run a DB2 batch program from native TSO. An example is shown: DSN SYSTEM(DSP3) RUN PROGRAM(EDD470BD) PLAN(EDD470BD) LIB('ED 01T.OBJ.LOADLIB') END
2. Use IKJEFT01 utility program to run the above DSN command in a JCL.
44. How many clustering indexes are pasing for a table?
As many no of column's that table is having that many no. of indexs we can pass. i think only one clustering index ll be created for any table in DB2. This clustering index is created on the primary key of the table. for all other index(es) created on the table they ll be nonclustering index(es) .
45. How many clustering indexes can be defined for a table?
Only one.
46. how many columns maximum can be created in a table of a inner table of the subquerry
no of tables that can be joined in a single query are 15 Maximum number of columns in a table --> 256 Maximum lenght of a row in a table -- > 64KB Sorry guys but those are not DB2 metrics. In DB2 Version 8 the max length of a row is 32K not 64K. The max number of tables in a join is 225 (for many releases 15 tables was the max but not any more, version 8 is a beast of a release, the biggest ever in db2 history) and the max number of columns in a table is 750 (it's been 750 since Version 3 in 1991 prior to that it was 300). I'm afraid you have DB2 mixed up with something else.
47. How many times should I specify UNION to eliminate the duplicate rows?
Once.
48. How to enter in xpediter?
1. In ISPF menu command give the XP then the screen will enter into xpeditor For Xpediting a program first a cmnddio load should be created.Then give xp where u can give the load lib and xped ur program The command TSO XPED should take you to Xpediter main screen.
2. In SPUFI result of the query will be in PS or in PDS member will store but 3.you know the sqlcode after executing the query.
49. how to execute more queries at a time.
1. You cannot execute more than one query.
2. In QMF result of the query u can't store.
3. You can't know the sqlcode of the query.
The biggest difference between QMF and SPUFI is that QMF is a query/reporting environment with the ability to format reports. SPUFI is just a quick and dirty SQL execution engine. If you need to produce nice looking reports, enable user input to a query, or store your queries and reports for future usage, QMF is a much better technology for doing so.
50. How to know other person job status?
Use notify statement Go to spool and in the command prompt give owner '@XXXX' and pre * then you will able to see all the job status for the user XXXX. where XXXX is the mainframe id of other person.
-
Databases Questions and Answers
- DB2 Interview Questions and Answers
- IMS Interview Questions and Answers
- MYSQL Interview Questions and Answers
- Oracle Interview Questions and Answers
- PL/SQL Interview Questions And Answers
- Quel Interview Questions and Answers
- SQL Interview Questions and Answers
-
.NET Interview Questions and Answers
- ASP Interview Questions and Answers
- C# Interview Questions and Answers
- Visual Basic Interview Questions and Answers
-
J2EE Interview Questions and Answers
- Enterprise Java Beans (EJB) Interview Questions And Answers
- Hibernate Interview Questions And Answers
- Jave Messaging Service (JMS) Interview Questions And Answers
- Jave Server Faces (JSF) Interview Questions And Answers
- Java Server Pages (JSP) Interview Questions And Answers
- Servlets Interview Questions And Answers
- Spring Framework Interview Questions And Answers
- Struts Framework Interview Questions And Answers
-
JAVA Interview Questions and Answers
- Core Java Interview Questions and Answers
- Java Platform, Micro Edition (Java ME) Interview Questions And Answers
- JAVA GUI Interview Questions and Answers
- Java Performance Tuning Interview Questions And Answers
- JUnit Interview Questions And Answers
- Remote Method Invocation (RMI) Interview Questions And Answers
- Unified Modeling Language (UML) Interview Questions And Answers
-
Java Application Server Interview Questions And Answers
- Tomcat Application Server Interview Questions And Answers
- WebLogic Application Server Interview Questions And Answers
-
Mainframe Interview Questions and Answers
- CICS Interview Questions and Answers
- COBOL Interview Questions and Answers
- IMS Interview Questions and Answers
- JCL Interview Questions and Answers
- REXX Interview Questions and Answers
- TELON Interview Questions and Answers
- VSAM Interview Questions and Answers
-
Object Oriented Language Questions and Answers
- C Interview Questions and Answers
- C++ Interview Questions and Answers
- Eiffel Interview Questions and Answers
- J2EE Interview Questions and Answers
- JAVA Interview Questions and Answers
- Sather Interview Questions and Answers
- Small talk Interview Questions and Answers
-
Operation Systems Interview Questions and Answers
- MS DOS Interview Questions and Answers
- Unix OS Interview Questions and Answers
- Windows Interview Questions and Answers
-
Scripting languages Interview Questions and Answers
- Java Script Interview Questions and Answers
- Practical Extraction and Reporting Language Interview Questions and Answers
- PHP Interview Questions and Answers
- VBScript Interview Questions and Answers
-
UserInterfaces Questions and Answers
- Foxit Interview Questions and Answers
- Glade Interview Questions and Answers
- Tweak Interview Questions and Answers
-
WEB Technologies Questions and Answers
- AJAX Interview Questions and Answers
- HTML Interview Questions and Answers
- WML Interview Questions and Answers
- XML Interview Questions and Answers
-
Interview Tips And Some Common Questions
- Behavioral Interview Questions And Answers