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

  • iGate aptitute test questions (6)
  • iGate interview questions (361)
  • iGate placement papers (3)
  • iGate technical test questions (14)



iGate SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is cursor procedure

1 5103

how to get second highest salary in SQL(as/4000

29 15953

Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 10234

What is meant by Materialized view?

2 4805

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 4575





i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 11910

Post New iGate SQL PLSQL Interview Questions



Un-Answered Questions

banking domain description for software tester for interview

2801


What is the base for issuing of C-form date of sale or date of purchase since goods sent by one quarter ended may reach in next quarter.

1304


pass the journal as wellas ledger entries off the foll 1st jan :> started businress with cash rs 1,20,000 & goods worth rs 60,000. 2nd jan > cash purchases rs 50,000. 4th jan >cash sales rs 40,000. 6th jan > purchase good's from sonali on credit worth rs 30,000 at 10 % trade discount. 8th jan> sold sood's to komal on credit rs 20,000 at 10% trade discount. 10th jan > paid rent by a cheque rs 50,000. 12th jan > good's worth rs 4,000 lossed by fire. 14th jan > good's worth rs 3,000 withdrawn from business for personal use. 16th jan > good's worth rs 2,000 distributed as free samples. 18th jan > good's worth rs 1,000 exchange for furniture.

907


What is mean by Sensitive Earth fault & what are the effects

2611


what is the required force to bend 2.5 MS sheet in 90 degrees and what is the formula to calculate the same?

1514






Can i make restrictions for sales order? Like, book the sales order only for 100 or above quantities?

721


What is the recommended way to use three-way file merging?

1057


how to join query for one source type is oracle another source type is sql server ?

1272


whenever install patch cluster, system will be restart what is the problem?

698


what is ms configure?

1174


how much winding resistance of 0.75kw to 12.5kw 3ph sqwiralcage induction motor?

1625


What is the function module for INDIAN PAYROLL to read table cluster for given cluster table and sequence number?

1192


What is Independant Testing? When and where this type of testing will be performed?

941


consider a program module that inputs two (2) values, n and max, and computes the sum of the first n integers as long as this sum is less than max; otherwise an error should be reported. if n is negative, then it takes the absolute value. a) list the equivalence partitions, and b) list the boundary values.

1038


1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

8726






iGate SQL PLSQL Interview Questions
  • C (4)
  • C++ General (1)
  • Programming Languages AllOther (2)
  • JavaScript (2)
  • VB Script (4)
  • Networking Security (1)
  • Networking AllOther (1)
  • Visual Basic (1)
  • C Sharp (2)
  • ASP.NET (5)
  • Dot Net AllOther (7)
  • Microsoft Related AllOther (2)
  • Oracle General (3)
  • Oracle AllOther (1)
  • SQL Server (3)
  • DB Administration (4)
  • SQL PLSQL (6)
  • Databases AllOther (1)
  • Data Structures (1)
  • WinRunner (3)
  • Load Runner (3)
  • QTP (10)
  • Automation Testing AllOther (1)
  • Manual Testing (24)
  • QA Concepts (1)
  • Mobile Testing (1)
  • Test Cases (2)
  • Testing AllOther (1)
  • Servers AllOther (1)
  • COBOL (11)
  • JCL (8)
  • CICS (2)
  • DB2 (4)
  • VSAM (2)
  • IBM MainFrame AllOther (1)
  • RPG400 (9)
  • IBM AS400 AllOther (4)
  • Core Java (10)
  • Advanced Java (3)
  • EJB (1)
  • Servlets (5)
  • Struts (6)
  • Java J2EE AllOther (1)
  • Teradata (1)
  • Business Objects (7)
  • Cognos (10)
  • Informatica (23)
  • Ab Initio (1)
  • Data Stage (4)
  • Micro Strategy (5)
  • ETL (2)
  • Data Warehouse General (3)
  • HR Questions (3)
  • Project Planning (1)
  • SAP Basis (28)
  • SAP ABAP (6)
  • SAPScript (1)
  • SAP SD (19)
  • SAP FI CO (32)
  • SAP HR (1)
  • SAP CRM (1)
  • SAP Business Warehouse (4)
  • SAP Security (17)
  • SAP ALE IDocs (1)
  • SAP B1 (1)
  • Oracle Apps Technical (4)
  • Oracle Apps Financial (2)
  • Oracle Apps Manufacturing (1)
  • Oracle Apps SCM (8)
  • AI Fuzzy Logic (1)
  • AI General (2)
  • WebMethods (1)
  • Electrical Engineering (1)
  • Marketing Sales (1)
  • Banking Finance (2)
  • CompanyAffairs CS (1)
  • Accounting General (2)
  • Accounting AllOther (5)
  • Call Centre AllOther (3)
  • CDS (1)
  • General Aptitude (4)
  • Puzzles (2)
  • Placement Papers (3)
  • CCNA (1)
  • ISTQB Certification (1)
  • C++ Code (1)
  • C C++ Errors (1)