What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
6 19621Following 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 8968Write 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 7350a 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 8186The 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 7656We 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 2989what 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 5941Post New Cap Gemini Interview Questions
What are the differences between jbehave and cucumber?
Why do we use codeigniter?
Is visual c++ still used?
How to create extension table to an interface table in siebel?
What is the ZooKeeper ensemble?
How to create custom sql query in django ?
on 21st march and 23rd september 1.the direct rays of the sunfall on the equator. 2.the slanting rays fall on the equator. 3.only the northpole is tilted towards the sun. 4.only the south pole is tilted towards the sun.
What is the python keyword "with" used for?
How can I reset my outlook email?
what is an ETL or ETT? And what are the different types?
Name and explain the types of ways which are used to pass arguments in any function in java.
What are the design goals of zookeeper?
Explain the advantages of data integration suite in sybase.
What is wait stage in bp?
How can we get Servlet API Request, Response, HttpSession etc Objects in action classes?