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 14179

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 7023

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

4040

What happens if we dont select data driven option?

2 7528

how we can add header and footer to flat files?

2 15096

What is sort key and how it controls?

3 12460

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

1 7201

define sql

3 6283

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

2 6919

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;

2185

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

4 7968

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 7959

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 4948

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

1 6278

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 11864

Post New Zensar Interview Questions

Zensar Interview Questions

Un-Answered Questions

Suppose a user gave us a negative feedback on our Facebook page, how would you handle that?

728

What is the Force.com Platform?

419

plants release O2 only during daytime but respire 24 hrs giving out CO2 but are said to purify air? How?

2037

What is a static property. Give an example?

889

What is server-to-server authentication?

What is an example of a foreign key?

930

How would you test your favorite app?

1456

Write a program using merge () function to combine the elements of array x[ ] and y[ ] into array z[ ].

1008

How can we force the database to use the user specified rollback segment?

1071

Does c# have its own class library?

918

Why are short circuit ratings always 16kA,25kA,36kA and 50kA.Who has fixed these?

4224

What are the challenges and limitations of selenium webdriver?

896

What are the reasons behind the development works in joomla?

Xmlserializer is throwing a generic "there was an error reflecting myclass" error. How do I find out what the problem is?

910

how to determine motor size for a fan application?

2231