Wednesday, 07 March 2007 What is GDG? Wednesday, 07 March 2007 What does the statements: typrun=scan and Wednesday, 07 March 2007 Why do you use a control card? Wednesday, 07 March 2007 What is a procedure? Wednesday, 07 March 2007 What is the meaning of the EXEC statement keyword, Wednesday, 07 March 2007 What is the use of DSNDB07? Wednesday, 07 March 2007 What is a Dummy Utility and what it does? Wednesday, 07 March 2007 What does a disposition of (NEW, CATLG, KEEP) mean? Wednesday, 07 March 2007 How do you restart a step in JCL? Wednesday, 07 March 2007 What is SE37? Wednesday, 07 March 2007 The maximum number of in-stream procedure you Wednesday, 07 March 2007 Describe the EXEC statement, its meaning, syntax Wednesday, 07 March 2007 What is meant by S0C7 system abend code? Wednesday, 07 March 2007 What does TIME=1440 mean? Wednesday, 07 March 2007 What is the difference between static call & Wednesday, 07 March 2007 What you mean by skeleton JCL? Wednesday, 07 March 2007 How is the keyword DUMMY used in JCL? Wednesday, 07 March 2007 How much space OS allocates when you create Wednesday, 07 March 2007 What is the max block size for a Tape file? Wednesday, 07 March 2007 How do you skip a particular step in a proc/JOB? Wednesday, 07 March 2007 How do you submit JCL via a COBOL program? Wednesday, 07 March 2007 What is COND=ONLY? Wednesday, 07 March 2007 How to get cursor position from system in CICS Wednesday, 07 March 2007 What is MOD and when would you use it? Wednesday, 07 March 2007 Which table PLAN is registered in? Wednesday, 07 March 2007 What are the differences between JES2 & JES3? Wednesday, 07 March 2007 What is the difference between specifying DISP=OLD Wednesday, 07 March 2007 How do you submit JCL via a COBOL program? Wednesday, 07 March 2007 What does a disposition of (NEW, CATLG, DELETE) mean? Wednesday, 07 March 2007 What is the difference between an in stream and Wednesday, 07 March 2007 What is the difference between BLKSIZE and LRECL? Wednesday, 07 March 2007 How much is memory space involved, when we Wednesday, 07 March 2007 What is order of searching of the libraries in a JCL? Wednesday, 07 March 2007 How do you submit a JCL under CICS environment? Wednesday, 07 March 2007 How is a GDG base created? Wednesday, 07 March 2007 What is the difference between primary and Wednesday, 07 March 2007 What are the kinds of job control statements? Wednesday, 07 March 2007 What is the improvement to COND= in the latest Wednesday, 07 March 2007 How do you submit a JCL under CICS environment? Wednesday, 07 March 2007 What is primary allocation for a dataset? Wednesday, 07 March 2007 What is the meaning of keyword in JCL? Wednesday, 07 March 2007 How do you designate a comment in JCL? Wednesday, 07 March 2007 What are three parameters you can specify on Wednesday, 07 March 2007 How do you override a specific DDNAME/SYSIN Wednesday, 07 March 2007 What is the difference between catalogue Wednesday, 07 March 2007 What does SYSIN * indicate? Wednesday, 07 March 2007 What does IEBGENER do? Wednesday, 07 March 2007 What is a GDG? Wednesday, 07 March 2007 How is a dataset passed from one step to another? Wednesday, 07 March 2007 How do you restart a PROC from a particular step? sday, 07 March 2007 What does the TIME parameter signify? Wednesday, 07 March 2007 What happens if both JOBLIB and STEPLIB Wednesday, 07 March 2007 What is a COND parameter in JCL? Wednesday, 07 March 2007 How are datasets concatenated? Wednesday, 07 March 2007 How do you create a temporary dataset? Where Wednesday, 07 March 2007 What is a PROC? Wednesday, 07 March 2007 How can you trap abends in the JCL? Wednesday, 07 March 2007 What is 'S0C7' abend? Wednesday, 07 March 2007 What is DATACOM db? Wednesday, 07 March 2007 How to change default PROCLIB? Wednesday, 07 March 2007 What is the DD statement for a output file? Wednesday, 07 March 2007 Explain concatenating datasets? Wednesday, 07 March 2007 What does S0C4 error mean? Wednesday, 07 March 2007 What is SD37? Wednesday, 07 March 2007 What is the error code SOC01 indicate? Wednesday, 07 March 2007 What is model dataset label (Model DSCB)? Wednesday, 07 March 2007 What do you do if you do not want to keep all Wednesday, 07 March 2007 What are the keywords associated with DCB? Wednesday, 07 March 2007 For how long a job can be executed continuously Wednesday, 07 March 2007 Which is the most widely used batch performance Wednesday, 07 March 2007 Can you code in stream data in a PROC? Wednesday, 07 March 2007 How is a new GDG coded? Wednesday, 07 March 2007 Describe the JOB statement, its meaning, syntax Wednesday, 07 March 2007 How many positional parameters are there in job Wednesday, 07 March 2007 What is NOTCAT? Wednesday, 07 March 2007 What is RESTART? How is it invoked? Wednesday, 07 March 2007 What is QSAM error usually when it is occurs? Wednesday, 07 March 2007 What is COND=EVEN? Wednesday, 07 March 2007 How many parameters are there to a DISP Wednesday, 07 March 2007 How do you send the output of a COBOL Wednesday, 07 March 2007 When should DISP=MOD is used? Wednesday, 07 March 2007 When should DISP=MOD is used? Wednesday, 07 March 2007 What is the difference between specifying DISP=OLD Wednesday, 07 March 2007 What is the purpose of include statement in a JCL? Wednesday, 07 March 2007 What is SB37? Wednesday, 07 March 2007 What are the maximum and minimum sizes of Wednesday, 07 March 2007 What are three major types of JCL statements? Wednesday, 07 March 2007 How are GDG s concatenated? Wednesday, 07 March 2007 What are the basic JCL Statements for a Job? Wednesday, 07 March 2007 How many types of libraries are there in JCL? Wednesday, 07 March 2007 What is the difference between the JOBLIB Wednesday, 07 March 2007 What is a GDG? How is it referenced? How Wednesday, 07 March 2007 How do you pass parameters to the program Wednesday, 07 March 2007 What is S322 abend? Wednesday, 07 March 2007 Write a jcl to execute a job by 7 a.m on Wednesday, 07 March 2007 What is a Generation Data Group (GDG)? Wednesday, 07 March 2007 What is DISP = (NEW, PASS, DELETE)? Wednesday, 07 March 2007 What is the difference between a symbolic and Wednesday, 07 March 2007 How to pass the temp dataset form one JOB Wednesday, 07 March 2007 What are the valid DSORG values? Wednesday, 07 March 2007 What is STEPLIB, JOBLIB? What is it used for? Wednesday, 07 March 2007 How many extents are possible for a sequential Wednesday, 07 March 2007 What is the OS precedence for obtaining that Wednesday, 07 March 2007 What do you mean by spooling? Expand SPOOL? Wednesday, 07 March 2007 What do you feel makes a good program? Wednesday, 07 March 2007 How do you check the syntax of a JCL without Wednesday, 07 March 2007 How do you access a file that had a disposition of KEEP? Wednesday, 07 March 2007 Describe the DD statement, its meaning, syntax Wednesday, 07 March 2007 What is the purpose of the PARM keyword in Wednesday, 07 March 2007 What is DSNDB06? Wednesday, 07 March 2007 Can we browse or edit the GDG dataset if it is Wednesday, 07 March 2007 How to execute a set of JCL statements from COBOL************************************************************************ Sunday, 04 March 2007 When would you use in-line perform? Sunday, 04 March 2007 How is sign stored in a comp-3 field? Sunday, 04 March 2007 What is a scope terminator? Sunday, 04 March 2007 What is an in line PERFORM? Sunday, 04 March 2007 What is the linkage section? Sunday, 04 March 2007 What is 88 level used for? Sunday, 04 March 2007 How many sections are there in data division? Sunday, 04 March 2007 What do you feel makes a good program? Sunday, 04 March 2007 What compiler option would you use for dynamic linking? Sunday, 04 March 2007 What are VS COBOL 11 special features? Sunday, 04 March 2007 What is file status 39? Sunday, 04 March 2007 How do you code COBOL to access a parameter Sunday, 04 March 2007 What is a subscript? Sunday, 04 March 2007 What is the point of the REPLACING option of Sunday, 04 March 2007 What is 77 level used for? Sunday, 04 March 2007 What is CALL statement in COBOL? Sunday, 04 March 2007 When is a scope terminator mandatory? Sunday, 04 March 2007 The maximum number of dimensions that an Sunday, 04 March 2007 What is file status 92? Sunday, 04 March 2007 How do you define the files referred to in a Sunday, 04 March 2007 How include time & date in the report generation Sunday, 04 March 2007 What is an explicit scope terminator? Sunday, 04 March 2007 How to execute a set of JCL statements from Sunday, 04 March 2007 How do you set a return code to the JCL from Sunday, 04 March 2007 Name some of the examples of COBOL 11? Sunday, 04 March 2007 What are the two search techniques? Sunday, 04 March 2007 How do you define a table/array in COBOL? Sunday, 04 March 2007 What is Static and Dynamic linking? Sunday, 04 March 2007 What is the maximum size of a 01 level item in COBOL II? Sunday, 04 March 2007 What is redefines clause? Sunday, 04 March 2007 Why occurs can not be used in 01 level? Sunday, 04 March 2007 What are options have been removed in COBOL 11? Sunday, 04 March 2007 How does IDMS communicate with CICS? Sunday, 04 March 2007 What is the pertinent COBOL? Sunday, 04 March 2007 What is the difference between external and global variables? Sunday, 04 March 2007 What is SET TO TRUE all about, anyway? Sunday, 04 March 2007 How can I tell if a module is being called Sunday, 04 March 2007 What is the difference between a subscript and Sunday, 04 March 2007 What is the reference modification? Sunday, 04 March 2007 What are the functions like c or c++ in COBOL? Sunday, 04 March 2007 What should be the sorting order for SEARCH ALL? Sunday, 04 March 2007 What is the difference between comp and comp-3 usage? Sunday, 04 March 2007 What is the Purpose of POINTER Phrase in STRING command? Sunday, 04 March 2007 How do you sort in a COBOL program? Sunday, 04 March 2007 What divisions, sections and paragraphs are Sunday, 04 March 2007 How do you do in-line PERFORM? Sunday, 04 March 2007 What is the difference between COMP & COMP-3? Sunday, 04 March 2007 What is SSRANGE, NOSSRANGE? Sunday, 04 March 2007 How is sign stored in a COMP field? Sunday, 04 March 2007 What is the use of EVALUATE statement? unday, 04 March 2007 What R 2 of the common forms of the EVALUATE STATEMENT? Sunday, 04 March 2007 What is COMP SYNC? Sunday, 04 March 2007 What are the differences between COBOL and COBOL II? Sunday, 04 March 2007 What is LENGTH in COBOL II? Sunday, 04 March 2007 What are the steps you go through while creating Sunday, 04 March 2007 What is the file organization clause? Sunday, 04 March 2007 What is the meaning of 'TALLING' verb in COBOL? Sunday, 04 March 2007 What is binary search? Sunday, 04 March 2007 What is the maximum length of a field you can Sunday, 04 March 2007 What are the differences between OS VS COBOL Sunday, 04 March 2007 What are the different forms of EVALUATE statement? Sunday, 04 March 2007 What is the mode in which you will OPEN a file for writing? Sunday, 04 March 2007 What does the initialize statement do? Sunday, 04 March 2007 Why we are giving more preference to COBOL? Sunday, 04 March 2007 What is difference between COBOL and VS COBOL II? Sunday, 04 March 2007 What are the different data types available in COBOL? Sunday, 04 March 2007 What COBOL construct is the COBOL II EVALUATE Sunday, 04 March 2007 How do you come out of an EVALUATE statement? Sunday, 04 March 2007 What is the purpose of Identification Division? Sunday, 04 March 2007 What is report-item? Sunday, 04 March 2007 What is Alternate Index? How is it different from Sunday, 04 March 2007 How can you pass values from COBOL program Sunday, 04 March 2007 What does EXIT do? Sunday, 04 March 2007 What is the difference between a DYNAMIC Sunday, 04 March 2007 What is the difference between Structured COBOL Sunday, 04 March 2007 How do we get current date from system with century? Sunday, 04 March 2007 What is the LINKAGE SECTION used for? Sunday, 04 March 2007 What is the difference between a binary search Sunday, 04 March 2007 What is an index for tables? Sunday, 04 March 2007 What is the difference between a binary search Sunday, 04 March 2007 How to resolve the soc4 and soc7 errors? Sunday, 04 March 2007 How do you submit JCL via a COBOL program? Sunday, 04 March 2007 How may divisions are there in JCL-COBOL? Sunday, 04 March 2007 Describe the difference between subscripting Sunday, 04 March 2007 What are some examples of command terminators? Sunday, 04 March 2007 What is the Importance of GLOBAL clause Sunday, 04 March 2007 What is difference between comp & comp-4? Sunday, 04 March 2007 What is the difference between index and subscript? Sunday, 04 March 2007 What is the difference between an internal and Sunday, 04 March 2007 What care has to be taken to force program to Sunday, 04 March 2007 What does the IS NUMERIC clause establish? Sunday, 04 March 2007 What is the difference between SEARCH and Sunday, 04 March 2007 What guidelines should be followed to write a Sunday, 04 March 2007 What is the difference between static call & Dynamic call? Sunday, 04 March 2007 How would the number 1234 be stored in EBCDIC? Sunday, 04 March 2007 What the difference is between write & move in COBOL? Sunday, 04 March 2007 What is the maximum size of a 01 level item in COBOL I? Sunday, 04 March 2007 What is level 66 used for? Sunday, 04 March 2007 What is the difference between SEARCH and SEARCH ALL? Sunday, 04 March 2007 When can the USING phrase be included in the call statement? Sunday, 04 March 2007 What are the pertinent COBOL commands? Sunday, 04 March 2007 How is sign stored in Packed Decimal fields Sunday, 04 March 2007 What is the difference between performing a Sunday, 04 March 2007 What does the INITIALIZE verb do? Sunday, 04 March 2007 Difference between next and continue clause Sunday, 04 March 2007 What is the significance of 'above the line' and 'below the line'? Sunday, 04 March 2007 What is an in-line perform? Sunday, 04 March 2007 How can we pass data from COBOL to JCL? Sunday, 04 March 2007 What are differences between COBOL and java? Sunday, 04 March 2007 What is the difference between PIC 9.99 and 9v99? Sunday, 04 March 2007 What are the advantages of REDEFINES clause? Sunday, 04 March 2007 What is the difference between NEXT SENTENCE Sunday, 04 March 2007 What the difference is between CONTINUE & Sunday, 04 March 2007 How can you submit a job from COBOL programs? Sunday, 04 March 2007 What do you do to resolve SOC-7 error? Sunday, 04 March 2007 What is the different between index and subscript? Sunday, 04 March 2007 What is the meaning of 'Eject' verb in COBOL? Sunday, 04 March 2007 How does IDMS insure data integrity? Sunday, 04 March 2007 What is COMP-1 and COMP-2? Sunday, 04 March 2007 What was removed from COBOL in the COBOL Sunday, 04 March 2007 What are different file OPEN modes available in COBOL? DB2********************************************************************************************** Tuesday, 06 March 2007 What is referential integrity? Tuesday, 06 March 2007 What are foreign keys? Tuesday, 06 March 2007 What is a cursor? Tuesday, 06 March 2007 What is the STOSPACE Utility used for? Tuesday, 06 March 2007 What is a collection? Tuesday, 06 March 2007 What is lock contention? Tuesday, 06 March 2007 What is a clustering index? Tuesday, 06 March 2007 How would you print the output of an SQL statement Tuesday, 06 March 2007 What is cursor stability? Tuesday, 06 March 2007 How is the connection established between TSO & DB2? Tuesday, 06 March 2007 When would you prefer to use VARCHAR? Tuesday, 06 March 2007 What is meant by AUTO COMMIT? Tuesday, 06 March 2007 What is the purpose of the WHENEVER statement? Tuesday, 06 March 2007 Which transaction uses a command thread? Tuesday, 06 March 2007 What are the disadvantages of using VARCHAR? Tuesday, 06 March 2007 What is an access path? Tuesday, 06 March 2007 What is the function of the Data Manager? Tuesday, 06 March 2007 What is a root page? Tuesday, 06 March 2007 What is meant by index cardinality? Tuesday, 06 March 2007 What are the functions of Bind? Tuesday, 06 March 2007 What is the difference between IN sub selects and Tuesday, 06 March 2007 What are the levels of isolation available with DB2V4? Tuesday, 06 March 2007 What is the root page in terms of DB2 indexing? Tuesday, 06 March 2007 Explain an outer join? Tuesday, 06 March 2007 What does the CLOSE parameter do on the create table space? Tuesday, 06 March 2007 What is sub query? Tuesday, 06 March 2007 What are simple, segmented and partitioned Tuesday, 06 March 2007 What do you mean by NOT NULL? Tuesday, 06 March 2007 Can DASD types assigned to storage groups be intermixed Tuesday, 06 March 2007 What is IMAGECOPY? Tuesday, 06 March 2007 What are the advantages of using a PACKAGE? Tuesday, 06 March 2007 What is a DB2 bind? Tuesday, 06 March 2007 What is the name of the default db2 catalog database? Tuesday, 06 March 2007 What is an alias? Tuesday, 06 March 2007 What’s the equivalent COBOL Data type for Decimal Tuesday, 06 March 2007 What is a DB2 access path? Tuesday, 06 March 2007 What can the Locate option of the Repair Utility accomplish? Tuesday, 06 March 2007 How many clustering indexes can be defined for a table? Tuesday, 06 March 2007 Where is the access path logic created by the DB2 Tuesday, 06 March 2007 What is the content of SQLCABC? Tuesday, 06 March 2007 What is a synonym? Tuesday, 06 March 2007 What is FREEPAGE and PCTFREE in TABLESPACE creation? Tuesday, 06 March 2007 What is a data page? Tuesday, 06 March 2007 What is the difference between static and dynamic SQL? Tuesday, 06 March 2007 What can the SET option of the Repair Utility accomplish? Tuesday, 06 March 2007 What is DCLGEN? Tuesday, 06 March 2007 What is a composite index? Tuesday, 06 March 2007 What utility is used to migrate DB2 from one release Tuesday, 06 March 2007 What is an alias and how does it differ from a synonym? Tuesday, 06 March 2007 What is SPUFI? uesday, 06 March 2007 What is the difference between primary key & unique index? Tuesday, 06 March 2007 What is the maximum number of tables that can be joined? Tuesday, 06 March 2007 What are the max. & min. no. of partitions allowed Tuesday, 06 March 2007 What is filter factor? Tuesday, 06 March 2007 How do you define a correlated name? Tuesday, 06 March 2007 What is an inner join, and an outer join ? Tuesday, 06 March 2007 What is the difference between Where and Having Clause Tuesday, 06 March 2007 What is JOIN? Tuesday, 06 March 2007 What is read-only cursor? Tuesday, 06 March 2007 What do you mean by NOT NULL WITH DEFAULT? Tuesday, 06 March 2007 What is CHECK PENDING? Tuesday, 06 March 2007 What is lock escalation? Tuesday, 06 March 2007 What is a Database Request Module (DBRM)? Tuesday, 06 March 2007 When do you use the IMAGECOPY? Tuesday, 06 March 2007 How does DB2 store NULL physically? Tuesday, 06 March 2007 What is a correlated sub query? Tuesday, 06 March 2007 What does the REORG Utility do? Tuesday, 06 March 2007 What is the difference between SYNONYM and ALIAS? Tuesday, 06 March 2007 What is the best lock size that you could use when Tuesday, 06 March 2007 How to see the structure of db2 table? Tuesday, 06 March 2007 When can an insert of a new primary key value threaten Tuesday, 06 March 2007 What is an asynchronous write? Tuesday, 06 March 2007 Which authority can be granted to group of users Tuesday, 06 March 2007 What is a host variable? Tuesday, 06 March 2007 What is the FREE command? Tuesday, 06 March 2007 What are the disadvantages of PAGE level lock? Tuesday, 06 March 2007 What are the isolation levels possible? Tuesday, 06 March 2007 What is ACQUIRE/RELEASE in BIND? Tuesday, 06 March 2007 What is the difference between TYPE 1 index & TYPE 2 index? Tuesday, 06 March 2007 What is COPY PENDING status? Tuesday, 06 March 2007 What is contained in the DB2 node lock file? Tuesday, 06 March 2007 What is a thread? Tuesday, 06 March 2007 What information is used as input to the bind process? Tuesday, 06 March 2007 What is the command used by TSO users to invoke DB2? Tuesday, 06 March 2007 What are data types? Tuesday, 06 March 2007 What is the error code for Unique Index Violation? Tuesday, 06 March 2007 What is correlated sub query? Tuesday, 06 March 2007 What information is contained in a SYSCOPY entry? Tuesday, 06 March 2007 What is page space? Monday, 05 March 2007 When will you chose to run RUNSTATS? Monday, 05 March 2007 What are the four lockable units for DB2? Monday, 05 March 2007 What will the FREE command do to a plan? Monday, 05 March 2007 What is Declaration Generator (DCLGEN)? Monday, 05 March 2007 What is the self-referencing constraint? Monday, 05 March 2007 What is index cardinality? Monday, 05 March 2007 What is isolation level? Monday, 05 March 2007 What do the initials DDL and DML stand for and what is their meaning? Monday, 05 March 2007 What is dynamic SQL? Monday, 05 March 2007 How is the SUBSTR keyword used in SQL? Monday, 05 March 2007 Which catalog table stores referential constraints? Monday, 05 March 2007 What does CURRENTDATA option in bind indicate? Monday, 05 March 2007 When is the access path determined for dynamic SQL? Monday, 05 March 2007 What is meant by the attachment facility? Monday, 05 March 2007 What does the current SQLID register contain? Monday, 05 March 2007 What information is held in SYSIBM.SYSCOPY? Monday, 05 March 2007 What types of copies can be made with the COPY Utility? Monday, 05 March 2007 What is a precompiler? Monday, 05 March 2007 Explain the use of the WHERE clause? Monday, 05 March 2007 What is the syntax of SELECT statement when embedded Monday, 05 March 2007 How does composite index differ from a multiple index? Monday, 05 March 2007 What is an intent lock? Monday, 05 March 2007 What is the significance of the CURSOR WITH HOLD Monday, 05 March 2007 How can you quickly find out the number of rows updated Monday, 05 March 2007 What does DSNDB07 database do? Monday, 05 March 2007 What is the maximum number of tables that can be stored Monday, 05 March 2007 How is a typical DB2 batch program executed? Monday, 05 March 2007 What are leaf pages? Monday, 05 March 2007 What are the three lock types? Monday, 05 March 2007 What is a Cartesian product? Monday, 05 March 2007 What is a NULL value? Monday, 05 March 2007 How many buffer pools are there in DB2? Monday, 05 March 2007 What is normalization and what are the five normal forms? Monday, 05 March 2007 What happens to the PLAN if index used by it is dropped? Monday, 05 March 2007 Where are plans stored? Monday, 05 March 2007 What is a predicate? Monday, 05 March 2007 What is a buffer pool? Monday, 05 March 2007 What is the picture clause of the null indicator variable? Monday, 05 March 2007 What is the difference between join and union? Monday, 05 March 2007 What is a clustered index? Monday, 05 March 2007 What else is there in the PLAN apart from the access path? Monday, 05 March 2007 What are the 4 environments which can access DB2? Monday, 05 March 2007 What is a SELECT statement? Monday, 05 March 2007 What is a DB2 catalog? Monday, 05 March 2007 How does DB2 determine what lock-size to use? Monday, 05 March 2007 What is a clustering index? Monday, 05 March 2007 What keyword does an SQL SELECT statement use for a string search? Monday, 05 March 2007 What is a Resource Control Table (RCT)? Describe its characteristics. Monday, 05 March 2007 When do you specify the isolation level? How? Monday, 05 March 2007 Why use RUNSTAT Utility? Monday, 05 March 2007 How does DB2 use multiple table indexes? Monday, 05 March 2007 What is cursor stability? Monday, 05 March 2007 What is ALTER? Monday, 05 March 2007 How to define the data items to receive the fetch items for the SQL? Monday, 05 March 2007 What are the various locks available? Monday, 05 March 2007 How do you filter out the rows retrieved from a Db2 table? Monday, 05 March 2007 What is a DB2 plan? Monday, 05 March 2007 What is deadlock? Monday, 05 March 2007 What is meant by isolation level? Monday, 05 March 2007 What is meant by repeatable read? Monday, 05 March 2007 What is the format (internal layout) of “TIMESTAMP”? Monday, 05 March 2007 What is the purpose of the QUIESE Utility? Monday, 05 March 2007 How are write I/Os from the buffer pool executed? Monday, 05 March 2007 What is a recovery log? Monday, 05 March 2007 How do you do the EXPLAIN of a dynamic SQL statement? Monday, 05 March 2007 What is the syntax required for the creation of a cursor? Sunday, 04 March 2007 What is the purpose of the DSNC transaction? Sunday, 04 March 2007 What is the database descriptor? Sunday, 04 March 2007 How to resolve the -305 error code in DB2? Sunday, 04 March 2007 What's the maximum number of characters that a table name can have? Sunday, 04 March 2007 What is meant by a unit of recovery? Sunday, 04 March 2007 How does one remove entries from the SCT02 table? Sunday, 04 March 2007 Which catalog tables contain authorization information? Sunday, 04 March 2007 What is the difference between CS and RR isolation levels? Sunday, 04 March 2007 What is a base table? Sunday, 04 March 2007 What is the function of buffer manager? Sunday, 04 March 2007 What is DB2? Sunday, 04 March 2007 What is a result table? Sunday, 04 March 2007 What is the meaning of -805 SQL return code? Sunday, 04 March 2007 What is the meaning of -805 SQL return code? Sunday, 04 March 2007 How will you delete duplicate records from a table? Sunday, 04 March 2007 What is a cursor and what is its function? Sunday, 04 March 2007 What are the contents of a DCLGEN? Sunday, 04 March 2007 What information can you find in SYSIBM.SYSLINKS table? Sunday, 04 March 2007 What are the various locking levels available? Sunday, 04 March 2007 What is the difference between a package and a plan? Sunday, 04 March 2007 What is the size of a data page? Sunday, 04 March 2007 What is the size of a data page? Sunday, 04 March 2007 What is a collection? Sunday, 04 March 2007 What is meant by concurrency? Sunday, 04 March 2007 How many sub queries can you combine together? Sunday, 04 March 2007 What is the cascade rule and how does it relate Sunday, 04 March 2007 When is the skeleton cursor table created? Sunday, 04 March 2007 What do you need to do before you do EXPLAIN? Sunday, 04 March 2007 What technique is used to retrieve data from more than Sunday, 04 March 2007 What is a sub select? Sunday, 04 March 2007 What is the process of precompiler? Sunday, 04 March 2007 What are PACKAGES? Sunday, 04 March 2007 How many buffer pools are available in db2? Sunday, 04 March 2007 What does the CHECK Utility do? Sunday, 04 March 2007 What will the DB2 optimizer do? Sunday, 04 March 2007 What is RUNSTATS? Sunday, 04 March 2007 What are the three types of page locks that can be held? Sunday, 04 March 2007 Where besides the DB2 catalog is database object information Sunday, 04 March 2007 What is QUIESCE? Sunday, 04 March 2007 What is auditing? Sunday, 04 March 2007 What is the difference between group by and order by? Sunday, 04 March 2007 What is the Maximum Length of SQLCA? Sunday, 04 March 2007 What does the RUNSTATS Utility do? Sunday, 04 March 2007 What is REORG? Sunday, 04 March 2007 How could one combine a set of incremental image copies into a single copy? Sunday, 04 March 2007 What will the COMMIT accomplish? Sunday, 04 March 2007 What are delete-connected tables? Sunday, 04 March 2007 What is Skeleton cursor table (SKCT)?