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 12951

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 6181

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

3479

What happens if we dont select data driven option?

2 6350

how we can add header and footer to flat files?

2 13921

What is sort key and how it controls?

3 11396

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

1 6441

define sql

3 5032

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

2 5709

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;

1856

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

4 6709

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 6681

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 4158

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

1 5489

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 9938

Post New Zensar Interview Questions


Zensar Interview Questions


Un-Answered Questions

What do you mean by vouching?

668


Explain the architecture of magento.

3


Why we use int main and void main?

522


How to change an ISAPI DLL project to a CGI project, or vice-versa?

1194


What are the 3 levels of orm?

166






What is edm in entity framework?

505


What are the special cables required for explosion proof wiring?

2962


How long should a chkdsk take?

488


Can I install exe files on android?

470


Basic principle of ESI?

1618


The way to rectify sql performance for developed dashboards?

180


What is bias-variance decomposition of classification error in ensemble method?

52


How to access the LINQ in Sharepoint 2010?

457


Is microsoft coming out with a new operating system?

506


Explain meta tags?

451