Interview questions

Database Administrator (dba) interview questions – page 7

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

  1. ,if we have single SQ in flow and we have router in which ithas two group and we want to join these two groups withjoiner ?is it possible?

  2. What do you for when you hire people?

  3. Find top Nth employee from each department in terms of salary?

  4. Difference between a User Defined Function and a Stored Procedure

  5. I hav 10 records only one column1,2,3,4,5...10now am writing query select max(column name)ThenWhat is The Output

  6. Difference between join and a subquery?

  7. How many new transformations are introduced in 8.1 which arenot available in 7.1?any new transformation in 8.6?

  8. How many clustered index can have a table

  9. What are limitations of joiner transformation?

  10. Difference between char and varchar data types

  11. Difference between Cluster and Non-cluster index?

  12. Write code to find the date difference b/w two given date using PHP not MYSQL function?

  14. If there are 3 workflows are running and if 1st workflowfails then how could we start 2nd workflow or if 2ndworkflow fails how could we start 3rd workflow?

  15. What is the difference between SQL table and the PLSQL table?

  16. I'm concerned that you don't have as much experience as we'd like in?

  17. You've been with your firm a long time. Won't it be hard switching to a new company?

  18. How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

  19. Difference between Triggers and Stored Procedures

  20. I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

  21. I hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeksi need 1st dd for evry wk

  22. Difference between UNION ALL Statement and UNION

  23. What is data driven in update strategy transformation?

  24. How to find maximum identity number in a table ?

  25. Wt is the diff b/w greast and max ,least and min?wt is the diff b/w case and decod?

  27. How can we take a backup of a mysql table and how can werestore it. ?

  28. What are %TYPE and %ROWTYPE? what is the difference?

  29. Are there any types of Dynamic Caches in informatica

  30. I have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

  31. What are Ranking Functions?

  32. In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

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