Zensar Interview Questions Answers, Zensar Placement Papers, Zensar Technical, HR Interview Questions, Zensar Aptitude Test Questions, Zensar Campus Placements Exam Questions

Company Name Starts with ...

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Zensar Interview Questions

Questions Answers Views Company eMail

How you count the number of records available at your source?

3 14481

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

2 7251

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4150

What happens if we dont select data driven option?

2 7797

how we can add header and footer to flat files?

2 15409

What is sort key and how it controls?

3 12775

Why we need new operator in java at the time of object declaration and why not in c++?

1 7375

define sql

3 6594

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 7177

i want run following code on button click of view. i am trying to retrieve data from isc_order_details table and isc_product table. but after retriaval of data i m getting error like FIELD MUST BE ENTERED!! DECLARE m number; n number; CURSOR order_details IS SELECT PRODUCT_ORDER_QUAN,PRODUCT_ID FROM isc_order_details WHERE order_id=:isc_order_master.order_id; amount NUMBER (8,2):=0.0; alert number; BEGIN go_block('isc_order_details'); first_record; m:=:system.cursor_record; last_record; n:=:system.cursor_record; OPEN order_details; --for i in m..n loop FETCH order_details INTO :ISC_ORDER_DETAILS.PRODUCT_ORDER_QUAN,:ISC_ORDER_DETAIL S.PRODUCT_ID; IF order_details%FOUND THEN SELECT order_value,order_date INTO :ISC_ORDER_MASTER.ORDER_VALUE,:ISC_ORDER_MASTER.ORDER_D ATE FROM isc_order_master WHERE order_id=:ISC_ORDER_MASTER.ORDER_ID; SELECT product_desc,product_price INTO :ISC_ORDER_DETAILS.PRODUCT_DESC,:ISC_ORDER_DETAILS.PROD UCT_PRICE FROM isc_product WHERE product_id=:ISC_ORDER_DETAILS.PRODUCT_ID; next_record; END IF; EXIT WHEN order_details%NOTFOUND; END LOOP; last_record; CLOSE order_details; EXCEPTION when NO_DATA_FOUND then alert:=SHOW_ALERT('ENTER_DATA'); Go_Item('isc_order_master.order_id'); END;

2334

Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

4 8306

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 8261

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 5127

how can stop the sequence with mention the max value and with out mention the max value

1 6494

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 12433

Post New Zensar Interview Questions

Zensar Interview Questions

Un-Answered Questions

What is difference between hibernate and spring data jpa?

478

How do I run a ksh script in unix?

1014

what is scupper?

2471

HELLO SIR, IAM PREPARING HPCL EXAMS. SO PLS SEND MATERIAL OF HPCL ELECTRICAL ENG..TO VIJAY_8888@YMAIL.COM

1922

What is the life expectancy of ssd drives?

944

What are the new features of asp.net ajax 4.0?

998

u have 8 yrs exp y u r applyed this job y ur not appled high possition job ?

2490

What is the criteria to change the equipment category?

869

What is pdo mysql?

982

Is a parabola a function?

962

What are the default values for the packaging element?

183

Do you know about latest update in seo ?

925

why are u join ntpc

2207

Explain about obj-open, obj-save?

612

Explain about glucose uptake test in hepatocytes ?

1846