Interview questions

DB Administration interview questions – page 3

611 questions. Tap “Show answer” to check yourself.

  1. Can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

  2. What is the difference between OLAP and datawarehosue?

  3. Can you suggest me good author for Hyperion in data warehousing ?

  4. What is the difference between ODS and OLTP

  5. What are the major differences between Informatica 7.1,8.1,8.5 and 8.6?

  6. Can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

  7. What is serialization? What is the difference between sql and oracle?

  8. How many error tables are there in fload and what are their significance/use? Can we see the data of error tables? How many error tables are their in mload and what is there use? When mload job fails, can we access mload tables? If yes then how?

  9. What do you mean by static and local variable?

  10. What are the vital features of Firebird that makes it powerful database?

  11. What is ORA-1555?

  12. What is the relation between free list and buffer busy wait?

  14. What is the use of ASSIGN statement in progress database?

  15. A)Which two statements are true about a foreign key?b)Is each Foreign Key must exist as a Primary Key? Foreign Keys can change values over time.

  16. What is command for supporting foreign key in Firebird?

  17. How does indexing improve query performance?

  18. Define the "integrity rules"

  19. Define piconet.

  20. Define and expansion of ssl.

  21. What is the maximum number of rows in a table in Firebird?

  22. Can you tell me where the applications where ware house management system is used?

  23. Disadvantage in File Processing System?

  24. What is fact less fact table? where you have used it in your project?

  25. In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

  27. What is explain in teradata?

  28. What is aggregate table and aggregate fact table ... any examples of both

  29. Which two can be implemented as a centrally located logical architecture?a)operational data storeb)logical data mart

  30. If one wants to see the time dependent master data, what table is to be referred?

  31. What are logical databases?

  32. What are the operating systems under which Clipper can operate?

Companies that ask DB Administration questions

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