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

Cap Gemini Interview Questions

Find min value of fn: |-5-x| + |2-x|+|6-x|+10-x|; where x is an integer 0 17 23 19

39398

units digit in expansion os 2 raised to 51 is: 2 4 6 8

44610

A man engaged a servant on a condn that he’ll pay Rs 90 and also give him a bag at the end of the yr. He served for 9 months and was given a turban and Rs 65. So the price of turban is i. Rs : 10 19 0 55

29036

please inform cofigurations path ( back end) for date specifications IT 0041

3737

45 grinders brought @ 2215/-.transpot expense 2190/-.2760/- on octroi . Find SP/piece to make profit of 20% 2585 2225 2670 3325

31472

Boat goes downstream from P to Q in 2hrs, upstream in 6hrs and if speed of stream was ½ of boat in still water. Find dist PQ 6 4 10 none

23026

Asish was given Rs. 158 in denominations of Rs 1 each. He distributes these in diff bags, such that ne sum of money of denomination betn 1 and 158 can be given in bags. The min no. of such bags reqd :

13869

.There is a rectangular Garden whose length and width are 60m X 20m.There is a walkway of uniform width around garden. Area of walkway is 516m^2. Find width of walkway: 1 2 3 4

37692

What is alternate function for clrscr().

8250

2x-y=4 then 6x-3y=?

18793

Fresh Grapes contain 90% water by wt. Dried grapes contain 20% water by %age. What will b wt of dried grapes when we begin with 20 kg fresh grapes

20249

plz send me,capgemini placement paper

4235

The walls and roof of a room are 10 m long,8 m wide and 10 m in height is to be painted.How much will it cost at Rs.5 per sq.foot? A.1600 B.2000 C.2200 D.2400

8954

suspense account willbe transfer to

8359

Find the ratio of the areas of the regular hexagons inscribed in and circumscribed around a circle of radius 10cm.

2524

What is javabeans api?

40

Does wordpress cms allows the use of multiple language to cater regional people?

4

Explain the function of cooling water expansion tank.

962

Explain timestemp datatype in sybase.

66

The way to mix 2 stand out files with same fields however totally different knowledge (different years)?

20

How to identify the top or popular pages on my website in google analytics?

1

Name a few data dictionary objects?

108

Describe varray?

66

How to validate an atom 1.0 feed file?

54

Hi, I am new in oracle(SQL), could anyone help me in writing a correct SQL. Below is the table structure. Table: Subsc Fields: 1. Sub_no (this field will hold values of subscriber nos, for e.g. S111111, S222222, S333333, S444444, etc.) 2. s_status (this field will hold values for different status of subscriber, for e.g. 'A', 'S', 'C', etc.) 3. cus_id (this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) Table: Bill Fields: 1. Bill_no this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) 2. b_status = (this field will hold values for different status of bill for e.g. 'O', 'C', 'S', etc.) Note: 1. The Sub_no is a Primary key of Subsc table. 2. The cus_id is a foreign in Subsc table (referred from Bill_no field of Bill table) 3. The Bill_no field is the Primary key of Bill table. Query A --> I wrote a query to select cus_id/Bill_no which is in status open (b_status = 'O') and having more than two active subscriber (i.e. S_status = 'A') in it ( i.e. more the two subscribers in same bill). select s.cus_id from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id having count(sub_no) = 2 Problem : The above query will give the cus_id (or rather bill_no) which are in open status (b_status ='O) and which are having TWO ACTIVE Subscribers (s_status ='A') in it. However, this query will also lists the cus_id/bill_no which are having more than TWO subscribers in it (but only two subscriber will be in Active status (s_status = 'A') and the others will be in s_status = 'C' or s_status = 'S'. Help needed: I want to write a query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it. B--> If I include the sub_no in the above query then NO row are returned. select s.cus_id, s.sub_no from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id, s.sub_no having count(sub_no) = 2 Help needed: I want to modify the above query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it ALONG with the sub_no. Thanks a lot in advance. Regards, Nitin

1143

What is the difference between Web 2.0 and Web 3.0?

94

What is the procedure of submit bank guarantees and cancellation.

1515

Can we use jsx in typescript?

1

How do you manage outgoing partial payment for vendor in fi?

79

Tell me have you ever had to negotiate in order to get your way when working in a group? : insurance health

24