What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
6 19845Following questions were asked in Capegemini on 8th sep,2012 mainframe test 1.)Condition code for dul recors in VSAM- 2.) Is NULL or =NULL in Select statement 3.)max size of CI 4.)What happens after CI is full 5.)Ques on COND parameter 6.)which among following can not be rolled back a)delete table b.)droptable c)Update d.)insert 7.)groupby and orderby sql querries 8.)Max extents in VSAM file 9.)quesn on DPRTY=(1,10) 10.)range of condition codes in COBOL 11.)occurs clase can not be used at which level? 12.)delimiter in jcl 13.)sort card for file in PGM=SORT 14.)PIC(6) value 120056 possible? 15)question on BLKSIZE Is (20,20) and (20,10) possible? 16.)number of bytes in RDF 17.)Can we use index in WS-section or LK-section 18.)Verify command in IDCAMS used for? 19.)question on Alternate Index 20.)Return code of file attribute mismatch 21.)In which format COBOL variables stored? 22.)what is Alternate of HANDLE? 23.)can SUM,AVG,MIN,ROUND used in numeric and char variable data types? 24.)What is the datatype of FILE STATUS codes in WS-section?
2 9087Write a C++ program without using any loop (if, for, while etc) to print prime numbers from 1 to 100 and 100 to 1 (Do not use 200 print statements!!!)
2 7487a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
2 8306The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
3 7797We have a text file which contains 1 to 100 numeric values sequentially like 1 2 . . 100 Now we have to count them and transfer to XML file by writing a code in qtp.
1 3072what is the debt recovery management.what is use in Sap. If you are Implementing debt recovery management so what is basic thing.Means how to run I humbly requested please provide the Answer & All the basic thing
2 6077Post New Cap Gemini Interview Questions
Explain what are the two main string operators?
Can we insert in view in sql?
How to use advanced data-bound controls.
What are the two parameters which can be useful to know the quality of test execution?
How to call a C++ function which is compiled with C++ compiler in C code?
What is ansi - american national standards institute?
How can i start buying a share. How can i find dealers. Can any one give me just an idea about this. When to buy ? How to buy? where to Buy ? How can i sell it ? How i came to know it is right time to sell . so that i can gain money ? Advance thanks
what happen if drive input fail momentry at 48.5 HZ frequency?
Does the wto determine the customs tariffs on import of agricultural products?
Tell me what are the hardware problem you face regularly in your organization?
what is event bubbling and event capturing in javascript?
what is mean by c32/40s concrete class
Difference between Response.redirect vs server.transfer?
Is c# an open source language?
can anybody tell me what is release process of company? release note?