Interview questions

Database Administrator (dba) interview questions – page 5

1,040 questions. Tap “Show answer” to check yourself.

  1. What are the different actions in APP ENGINE.

  2. What is the STUFF function and how does it differ from theREPLACE function?

  3. Is LOAD MANAGER AND LOAD BALANCER same in informatica?

  4. Can we send mail when ever it get success or faulure to other mailid?

  5. What is curr val use for in sequence generator?

  6. What would you do if a fellow executive on your own corporate level wasn't pulling his/her weight?and this was hurting your department?

  7. We have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have torun how can you do in unix?

  8. How to improve the performance of Aggregate transformation?

  9. What are joins and subjoins in the data bases

  10. Can u explain me banking domain projects ?

  11. Advantages and Disadvantages of Cursor?

  12. Which will fire first ? Trigger or Constraint

  14. Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

  15. Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno.No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ?can we have right outer join and left outer join in the same SQL ---

  16. When we can say that is in BCNF?

  17. How would find total records in files using seqientional

  18. Why the UNION TRANSFERMATION is an Active TRANSFERMATION

  19. What is a self join?

  20. How to write a procedure for a date which is in threedifferent formats,and you want to load into datawarehouse inany single date formate

  21. 2,if we have 3 pipeline containing 3 targets and each targetis connected with diff sequence generator ,let us assumefirst target is populated with seq no1-9,so what would bethe number generated by other two sequence generator?what isthe diff in o/p if when we use reusable sequencegenerator?what would be the diff if we place expression inbetween target and sequence generator?

  22. Tell me something negative you've heard about our company?

  23. In Open SQL statements such as Insert update delete whichone is FASTlLY retrieve the results and which one is Efficient?

  24. What is nocopy in plsql?

  25. In update strategy t/r we had given dd_insert condition& in session we gave delete condition .Then what will happen? mapping will run ?

  27. How to do Integration testing in Informatica?

  28. How to load data from a text file into a table?

  29. How will you convert table row to a column comma separated value

  30. How to connect qtp to sqlserver?(if any body know about this please send mail to me:sheik_feroz5@yahoo.com)thank u

  31. Give me an example of a time when you tried to accomplish something and failed.

  32. My session have to run Monday to Saturday not run sunday howto sedule in informatica level?

Companies that ask Database Administrator (dba) questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide