What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
6 17840Following 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 7932Write 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 6369a 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 7344The 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 6690We 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 2415what 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 5073Post New Cap Gemini Interview Questions
How does iron and steel exhibit allotropy?
How to store decimal data in .net?
What will happen if an infinite while loop is run in Javascript?
How to avoid memory leak in java?
What is character functions?
Can you access a variable within a worker thread from the main thread?
Eplain the terms of any recent merger which had taken place in India.(*****)Please any one know about this explain.
What is the bias in machine learning?
What is starvation os?
what are common risks at sherwin williams? And how to face?
What do you mean by deferred update in sybase?
Why do we use sendredirect() method?
What is the new three features of COM+ services, which are not there in COM (MTS)
How do I crack vms passwords?
What are the tools used by runtime to monitor?