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

MEIL Interview Questions
Questions Answers Views Company eMail

What is the rating of your capacitor bank at your company.

36 75455

I want formula to calculate cable size as per load given in kw & amp.I searched many sites but didn't right answer.Plz reply me asap.

41 411119

What is switching over voltage?

1 5475

What is the exact meaning for under & over reinforced beams & when they have to used..

11 60633

If any HVDC line is going with positive & negative(the negative usually have return path of current with earthing electrode). Now the question is if this HVDC earthed electrode which is using as return path and earthed any nearby 400kv or 220kv AC substation equipments. which will be the impact of this on AC substation & its equipment, how severe may be this and what should be the minimum distance require between HVDC earthed electrode and AC substation equipments? It's really an high engineering level question...Dare to answer and increase your knowledge.

1460

what is meant by fuzzy logic? what is fuzzification and defuzzification?

5 24074

how to find the ballast lost from the actual wattage? for example i am going to buy decorative type 2x36watts fluorescent light fitting for this lamp how to find the ballast lost? is there any formula?

2 4639

how rated the neutral voltage of transformer and reactor, e.g. 400/220, 200MVA transformer have neutral voltage of 33kv. and reactor voltage 145kv. how this rating decided?

1 3639

How neutral voltage for transformer decided? eg 33kv neutral voltage for 200MVA transformer?

1 3972

2. What are the grades of steel used in the concrete design?

6 16136

What is the Temperature Co-officient of Resistance of PT- 1000 and PT-2000 ?

2 8154

For a 500 MVA 400/220/33KV transformer following data given HV power = 500 MVA IV power = 500 MVA LV power = 5 MVA If input power is 500 MVA then how output power is (500+5)MVA. Can anyone help

1 5751

How to calculate cement, aggregates for any one grade of concrete for icum?

1 5561

how much steel in one sq m slab?

6 11641

how can change 10mm dia @275 c/c bar spacing to 12 mm

4 13686

Post New MEIL Interview Questions




Un-Answered Questions

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

1761


List dependencies of using backbonejs?

1


What is acid fast staining?

684


What is consistency token in db2?

626


Explain the difference between Append & Append To?

455






What is strongly typed view?

494


why should i hire you? what are your outside interest? what was your toughest decision you ever have to make?

1684


What is the difference between sorted and ordered collection in hibernate?

309


What is the common type system (cts)?

515


What is static variable in c#?

479


What do database buffers contain?

556


Which is more efficient for loop or while loop?

458


What is mean in r?

70


Explain what should be done when a SQL exception is raised?

542


What is iron ferite? Where is it used?

532