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

  • Dena Bank interview questions (30)
  • Dena Bank technical test questions (1)



Dena Bank Accounting AllOther Interview Questions
Questions Answers Views Company eMail

what is repo rate?

147 145422

Post New Dena Bank Accounting AllOther Interview Questions




Un-Answered Questions

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

833


write test cases for cases

756


R/s syllabus required to crack Mahagenco interview for jr eng. post. I also want sample papper

1365


How to check vortex flow meter is in good condition while we do not having calibration setup?

4565


how to apply b license to c license in tneb

363






hi i have domin experience of 20 yrs working in Army for HR and payroll now i have done my Oracle HRMS training from Hyd. what is the future for me in MNCs. thanks my id is romeoalewis@gmail.com

1334


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

769


marketing procedure of iocl

907


what is Resolution?

669


What is the procedure for requition import?

840


what is the difference between np2 and np3 concrete mix

623


For 1 bag cement how i will calculate sand and metal aggregate;Here the mix proportion is 1:2.49:2.38

392


How to use the TUpdateSQLProvider.OnUpdateRecord method ?

939


wht is Manual Testing Frame work

741


What is the procedure to become charted accountant in India now. Please answer this is urgent

231






Dena Bank Accounting AllOther Interview Questions
  • C++ General (1)
  • Banking Finance (1)
  • Accounting AllOther (1)
  • POs (3)
  • BSRB Clerical (17)
  • BSRB AllOther (1)
  • General Knowledge_Current Affairs (2)
  • Government AllOther (2)
  • Everything Else AllOther (3)