Interview questions

DB Administration interview questions – page 4

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

  1. What is hybrid slowly changing dimension

  2. What is data validation strategies?

  3. 1)What ll be in the redolog file after deleting the table ,will it stores the table or any thing else? 2)Can we resize the redolog files?

  4. State some of the products of Sybase?

  5. What is Sybase system databases?

  6. State some of the criticism about Sybase IQ?

  7. What is the difference between Business Requirement Document and Use case Document. What is the difference. I need a good BRD and UC template.

  8. What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS

  9. When is a functional dependency F said to be minimal?

  10. Explain about openEdge translation manager?

  11. Explain about Progress open edge?

  12. How to parametarise a field in a sequential file?I am using Datastage as ETL Tool,Sequential file as source.

  14. In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id?

  15. What is Data warehosuing Hierarchy?

  16. Where we use link partitioner in data stage job?explain with example?

  17. Explain about the mainframe connect tools from Sybase?

  18. What is the difference between ETL tool and OLAP tool? What are various ETL in the market? What are various OLAP tools? what is the future for both for next five years?

  19. How to kill the job in data stage?

  20. What is incremintal loading? What is batch processing? What is crass reference table? What is aggregate fact table

  21. What is Fact table?

  22. Explain about the advantages of Progress Actional?

  23. What is junk dimension?what is the difference between junk dimension and degenerated dimension?

  24. Explain about the features of Sybase IQ?

  25. Is it advisable to force an index when you want to select mostof the entries in the table?

  27. What do you mean by slection sort and buble sort?please explain with example.

  28. Name some built-in functions that can be used in SQL queries?

  29. What is BUS Schema?

  30. What is difference between stack and queue?

  31. How to drop the index befor loading data in target and how to rebuild it in data stage?

  32. What is Data Storage - Definition Language?

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