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

  • Oracle aptitute test questions (18)
  • Oracle interview questions (479)
  • Oracle placement papers (2)
  • Oracle technical test questions (41)



Oracle Interview Questions
Questions Answers Views Company eMail

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 2673

trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 2628

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON

5 7147

I completed my B.tech (IT). Actually I want to develop virtual object that which will change software technology in the future. To develop virtual object what course I have to take. can I any professor to help me.

738

Your roles and responsibilities and daily tasks? (As automation tester)

1565

What can be done if requirements are changing continuously?

5 12133

Testing process in your company?

1 5554

Can any one provide dumps for Oracle Fusion CRM certification (1Z1-456)

3357

primary key is foreign key for the same table?

2 4131

You have only one container full of water. You didnt have any marker or measurement device. Find the half of the container.

3 7004

the bank revised the late payment penalty charges to $750 and to the borrowers A/C, pass the journal entry for the same

1 7659

In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?

1 4674

while loading data into database how can u skip header and footer records in sql*loader

1 3348

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

1 3671

While doing implementation,Client wants two use 2 Accounting methods for both Sandard Accrual method and Sandard Cash Method.So how we need to map or how need to provide solution.

1 4686

Post New Oracle Interview Questions




Un-Answered Questions

Dear Sir, My qus is my co. purchase a laptop from Abc.co. for rs-37200 on credit Emi basis from hdfc bank. i paid every month 6200rs as a installment. so i want to know how i make a entry in tally 9. and also want to know i creat laptop ledger under fixed assets or office expenses. plz tel me soon.or mail me .

372


From the following find out a. Profit Volume ratio b. Break even point c. Sales for 40% P/V Ratio d. Margin of safety from the sales Rs 3,00,000 e. Net profit from the sales of Rs 3,00,000 f. Required sales for the new profit of Rs 70,000 g. Required sales for the net profit of Rs 70,,000 after tax, the corporate income tax being 40% h. Additional sales required to convert an increase of Rs 3000 p.a. in the sales manager salary Sale 2,00,000 Variable Overheads 1,50,000 Profit 50000 Fixed overheads 15000 Net profit 35000 Sl No Heads of Account Debit Rs Credit Rs 1 Drawing and Capital 750 15,000 2 Stock as on 01.01.2009 69720 3 Bills Receivable and bills payable 1000 1180 4 Returns 300 320 5 Purchases and Sales 4500 8300 6 Wages 70 7 Discount 30 8 Salaries 200 9 Canara Bank Shares 3000 10 Insurance 120 11 Building 3000 12 Furniture 700 13 Debtors and Creditors 600 1300 14 Cash in Hand 470 15 Overdraft at bank 900

624


What will your outlook towards maintenance of liquid assets to ensure that the firm has adequate cash in hand to meet its obligations at all times

1009


"What do you do when in your duty, ME alarm oil mist detect high density?"

495


Why do you need to parameterize fields in your virtual user script?

534


What is overhauling and record kelping? What is the prosecute of dismantling and assembling?

1241


and gate circuit diagram,amplifier circuit diagram

545


How would you go about persuading a customer that our product was better than any other?

264


What is the use of SOCK_STREAM Socket Type?

170


How to Get a list of the available drives on a system?

440


Hi Friends, Just One Month Back I was Join in Small Company as a Testing Eng.I have Six Month Exp. In this Company all my team memb.r fresher & PM give responsibility on us to prepare all require QC doc. for our new project.So I need ur help in this matter .How Can I start my work and Which Doc.I start to collect & From Where I get Detail Information all abt these thing. Thanks to all friends who give reply to this. Suyog

430


Hello.. i have a question. which signature digital or signature logo we use in smartforms & scripts...? if we use digital sign what are those steps to use it...?

1117


what is the pulse and audio frequency transformer? what is different between induction regulators and tap changing transformer?

563


Automatic clearing Ib OB74 based on criteria I have defined document type and account no. and whether it cleared automatically or we have to go to F.13 do test run after that we will clear the document

3981


What is the advantage of Ring network ? Compare it with ethernet

1201




Oracle Interview Questions
  • C (21)
  • OOPS (2)
  • C++ General (2)
  • Programming Languages AllOther (4)
  • PHP (2)
  • CGI Perl (2)
  • JavaScript (1)
  • VB Script (1)
  • Networking Administration (1)
  • Oracle General (44)
  • Architecture (1)
  • Database Management (5)
  • Forms Reports (6)
  • Oracle AllOther (13)
  • SQL Server (11)
  • Sybase (1)
  • DB Administration (4)
  • SQL PLSQL (37)
  • Linux Commands (6)
  • Linux General (2)
  • Linux AllOther (4)
  • Unix Commands (2)
  • Unix AllOther (1)
  • Solaris General (2)
  • Operating Systems General Concepts (2)
  • Load Runner (1)
  • QTP (18)
  • Test Director (1)
  • Automation Testing AllOther (1)
  • Manual Testing (29)
  • QA Concepts (13)
  • Testing AllOther (5)
  • COBOL (2)
  • Core Java (16)
  • Advanced Java (2)
  • Struts (1)
  • J2EE (6)
  • Weblogic (5)
  • Middleware AllOther (1)
  • Business Objects (6)
  • Cognos (2)
  • Informatica (4)
  • Data Stage (1)
  • SAS (33)
  • Data Warehouse General (3)
  • HR Questions (2)
  • UML (1)
  • SAP Basis (1)
  • SAP FI CO (1)
  • SAP SRM (1)
  • PeopleSoft Administration (1)
  • Siebel (3)
  • ERP General (2)
  • Oracle Apps Technical (32)
  • Oracle Apps Financial (57)
  • Oracle Apps Manufacturing (3)
  • Oracle Apps HRMS (11)
  • Oracle Apps CRM (1)
  • Oracle Apps SCM (7)
  • Oracle Service Contracts (1)
  • Oracle Apps AllOther (1)
  • 3D Animation (1)
  • Image Processing General (1)
  • Civil Engineering (1)
  • Mechanical Engineering (1)
  • Electrical Engineering (2)
  • Electronics Communications (3)
  • Engineering AllOther (4)
  • Marketing Sales (5)
  • Finance (2)
  • Human Resources (2)
  • Non Technical (3)
  • Accounting General (1)
  • Accounting AllOther (4)
  • APPSC AllOther (3)
  • Everything Else AllOther (1)
  • General Aptitude (8)
  • Puzzles (9)
  • Placement Papers (2)
  • CISA Certification (2)
  • Oracle Certifications (12)
  • Australia Visa (1)
  • C Code (2)
  • J2SE Code (1)
  • Programming Code AllOther (1)
  • CAT (1)
  • Oracle Errors (15)