Interview questions

Database Administrator (dba) interview questions – page 11

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

  1. Can we use more than one null value for unique key?

  2. Do you have plans for continued study?

  3. How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

  4. What is Row_Number()?

  5. Can we use union transformation in joiner transformation?how?

  6. The ? Hypothetical Problem?

  7. What is the difference between a data item and a query item?

  8. What is Materialized View? In What Scenario we UseMaterialized View?

  9. What steps do you take to establish a rapport with others?

  10. What are constraints?

  11. Which transformation uses cache?

  12. Difference between a primary key and a unique key?

  14. What is the difference between look up and joiner(don't sayjoiner sopport only = where as look up support non-equijoin).

  15. What are the two key events for the sql connection class?explain the differnce between the two.

  16. What is checksum termnology in informatica? Where do you useit ?

  17. How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

  18. I want insert 10 records from table a to table b.if i m using statement level trigger how many record insert ?in row level trigger how many record inserted?

  19. How to select second mauximum value in a given table under salary column

  20. Take one table is t1 and in that column name is f1f1 column values are200500030007000300600100400800400i want display the values asc and desc in a single output.sample output isf1.a100200300400500600etc... and f1.d is50004000300020001000etc...

  21. What is the diff between Dynamic queries and static queries

  22. What is the difference between OLEDB and ODBC

  23. How to handle sql exceptions?

  24. What was the toughest part of your last job?

  25. How can i change the column name.

  27. Tell me about the most boring job you've ever had.

  28. What are the advantages and disadvantages of primary key and foreign key in SQL?

  29. What is the difference between filter and lookup transformation?

  30. What is surrogatekey ? In ur project in which situation u has used ? explain with example ?

  31. If a session fails after loading of 10,000 records in to the target.How can u load the records from 10001 th record when u run the session next time in informatica 6.1?

  32. Is sorter an active or passive transformation? What happens if we uncheck the distinct option in sorter.Will it be under active or passive transformation?

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