New Questions

Interview Questions :: Civil EngineeringPosted By : sudip


:Q: How much sand and cement requirement for 1 SQM 125mm thickness Brickwork


Interview Questions :: Electrical EngineeringPosted By : deepak pal


:Q: DG cranking voltage?


Interview Questions :: Chemical EngineeringPosted By : nandini m


:Q: Corenuts technology interview questions


Interview Questions :: JCLPosted By : priya110842


:Q: What is one line to pass PARM from JCL to COBOL?


Interview Questions :: JCLPosted By : priya110842


:Q: Step 1 RC 4 Step 2 Step 3 I want to know the COND parameter which can be coded in step 2 or 3. Step 2 should be executed based on Step 1 RC and Step 3 should not be executed based on step 1's RC


Interview Questions :: COBOLPosted By : priya110842


:Q: How to traceback if I am getting SOC7 or SOC4 abend? List down the steps


Interview Questions :: InformaticaPosted By : lokesh kumar


:Q: Difference between task flow and linear task flow


Interview Questions :: InformaticaPosted By : lokesh kumar


:Q: Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.


Interview Questions :: InformaticaPosted By : lokesh kumar


:Q: Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.


Interview Questions :: InformaticaPosted By : lokesh kumar


:Q: Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.


Interview Questions :: InformaticaPosted By : lokesh kumar


:Q: Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer


Interview Questions :: InformaticaPosted By : lokesh kumar


:Q: Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.


Interview Questions :: Electrical EngineeringPosted By : manmohan singh


:Q: Can we use LT(150 sq. mm) cable in place of HT (120 sq.mm.) cable.?


Interview Questions :: Accounting AllOtherPosted By : kedar pawar


:Q: I need all WNS interview questions


Interview Questions :: InstrumentationPosted By : dabhi4375@gmail.com


:Q: Why not come out analog output in ABB EL3020 when display show correct value


New Answers

Interview Questions :: SQL PLSQL Posted By : rutujagabhane


:Q: How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

A :: SELECT * FROM employees ORDER BY EMPLOYEE_ID OFFSET 99 ROWS FETCH NEXT 21 ROWS ONLY;


Interview Questions :: SQL PLSQL Posted By : rutujagabhane


:Q: i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

A :: select salary from emp wher dno in (select dno from dept where salary < any (select avg(salary) from dept where dept = 3)


Interview Questions :: SQL PLSQL Posted By : rutujagabhane


:Q: What does “select count(1) from tab” result?

A :: select* from tab; gives you the o/p as a table containing rows and columns. The rows contain the name of table ,select count(1) from tab returns the no or rows in tab . Indirectly the statement returns no of tables in tab;


Interview Questions :: SQL PLSQL Posted By : rutujagabhane


:Q: how to check the 3rd max salary from an employee table?

A :: SELECT * FROM( SELECT SALARY, DEPARTMENT_ID,EMPLOYEE_ID, DENSE_RANK() OVER (PARTITION BY DEPARTMENT_ID ORDER BY SALARY DESC) AS RN FROM EMPLOYEES ) WHERE RN = 2 ;


Interview Questions :: Servlets Posted By : rani


:Q: Which exception is thrown if servlet is not initialized properly?

A :: If an initialisation errors occurs the servlet incapable of handle client requests, throws an "UnavailableException". This indicates the servlet is unavailable.


Interview Questions :: CISA Certification Posted By : an


:Q: A request for a change to a report format in a module (subsystem) was made. After making the required changes, the programmer should carry out: A. unit testing. B. unit and module testing. C. unit, module and regression testing. D. module testing.

A :: C. unit, module and regression testing.


Interview Questions :: CISA Certification Posted By : an


:Q: Which of the following would be the LEAST helpful in restoring service from an incident currently underway? A. Developing a database repository of past incidents and actions to facilitate future corrective actions B. Declaring the incident, which not only helps to carry out corrective measures, but also improves the awareness level C. Developing a detailed operations plan that outlines specific actions to be taken to recover from an incident D. Establishing multidisciplinary teams consisting of executive management, security staff, information systems staff, legal counsel, public relations, etc., to carry out the response.

A :: A. Developing a database repository of past incidents and actions to facilitate future corrective actions


Interview Questions :: CISA Certification Posted By : an


:Q: Once an organization has finished the business process reengineering (BPR) of all its critical operations, the IS auditor would MOST likely focus on a review of: A. pre-BPR process flowcharts. B. post-BPR process flowcharts. C. BPR project plans. D. continuous improvement and monitoring plans.

A :: B. post-BPR process flowcharts.


Interview Questions :: CISA Certification Posted By : an


:Q: An IT steering committee would MOST likely perform which of the following functions? A. Placement of a purchase order with the approved IT vendor B. Installation of systems software and application software C. Provide liaison between IT department and user department D. Interview staff for the IT department

A :: C. Provide liaison between IT department and user department


Interview Questions :: CISA Certification Posted By : an


:Q: A malicious code that changes itself with each file it infects is called a: A. logic bomb. B. stealth virus. C. trojan horse. D. polymorphic virus.

A :: C. trojan horse.


Subscription

Top Users { Questions }
  • lokesh kumar
  • priya110842
  • kedar pawar
  • deepak pal
  • manmohan singh
  • sudip
  • nandini m
  • samuelabrham2148@gmail.com

(This Month)

Top Users { Answers }
  • an
  • rutujagabhane
  • siddu
  • rahul
  • manzoor hussain
  • rehaman
  • mahesh
  • raghu varma
  • p
  • manmohan singh

(This Month)

New Interview Questions
Welcome to Our New Friends
rutuja gabhane, balasubramaniyam s, oooo, shikha, vipin singh,


Active Participants
{ Questions } samuelabrham2148@gmail.com, ..

{ Answers } an, rutujagabhane, deepak singh, rani, lokesh, samuelabrham2148@gmail.com, p,


ALLInterview.com ... First of its kind encrypted with a motto to post as many interview questions as possible along with answers that were asked in various company interviews and expected questions which may be asked in job interviews, to help the needy young generation who are going to face interviews. This site will enlighten the nature and scope of interview questions that will be asked in various company interviews, keeping in view the present interviews scenario.

Many eminent personalities from all walks of life have contributed a lot in posting interview questions and answers relating to all categories viz., Software, Sciences, Engineering, Management, Accounting, Government & Private Sector and what not every branch has been covered in this site.

The viewers can also add questions and answers that they have faced in any job interviews, to share their interview experience and knowledge with the upcoming young generation.