DB Architecture interview questions – page 5

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

Advertisement
  1. Which one is faster for processing fixed length dmls or delimited dmls and why ?

  2. Will Word help me compare two similar documents?

  3. How can I change settings, turn features off or on, and alter the way Word behaves?

  4. How to take the input data from an excel sheet?

  5. Why might you create a stored procedure with the 'with recompile' option?

  6. Explain the role of bitmap indexes to solve aggregation problems.

  7. What's going on with the document windows when I have more than one file open?

  8. How do I turn off the automatic URLs?

  9. How can you force the optimizer to use a particular index?

  10. How can I display more toolbars?

  11. Can I add or remove buttons from the toolbars?

  12. The toolbars and the menus in my old version of Word looked different. What happened?

  13. Advertisement
  14. How Does MAXCORE works?

  15. What is the purpose of having stored procedures in a database?

  16. How many components in your most complicated graph?

  17. How do I change the default font for things like page numbers, headers, footers, footnotes, and endnotes?

  18. Can anyone please explain the environment variables with example?

  19. How do I get Word to stop helping me type?

  20. Sift links to MFS files on Unix for Ab Initio ? what is this ....2) $pound what is this 3) $? what for it is used 4) types of loading 5 overwrite when it used ?

  21. Explain the shared features of OLAP.

  22. How do I double-space my document?

  23. What is data mapping and data modelling?

  24. Compare Data Warehouse database and OLTP database.

  25. Explain the functionality of OLAP.

  26. Advertisement
  27. What are Word XP/2003 Task Panes?

  28. Can I turn the Ruler off (or turn it back on)?

  29. What is semi-join?

  30. How do I change the default margins?

  31. How to work with parameterized graphs?

  32. What is a cursor? Within a cursor, how would you update fields on the row just fetched?

Advertisement