DB Architecture interview questions – page 4

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

Advertisement
  1. What is .abinitiorc and What it contain?

  2. Can I keep different versions of a document in the same file?

  3. Have you worked with packages?

  4. Can anyone tell me what happens when the graph run? i.e The Co-operating System will be at the host, We are running the graph at some other place. How the Co-operating System interprets with Native OS?

  5. What is the difference between OLAP and DSS?

  6. Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data.

  7. What is candidate check?

  8. How to do we run sequences of jobs ,null,like output of A JOB is Input to BHow do we co-ordinate the jobs

  9. Describe the elements you would review to ensure multiple scheduled "batch" jobs do not "collide" with each other.

  10. How to retrive data from database to source in that case whice componenet is used for this?

  11. How to run the graph without GDE?

  12. What is an outer join?

  13. Advertisement
  14. What is BRODCASTING and REPLICATE ?

  15. What is mean by Co > Operating system andwhy it is special for Ab-initio ?

  16. How would you find out whether a SQL query is using the indices you expect?

  17. What does layout means in terms of Ab Initio

  18. When running a stored procedure definition script how would you guarantee the definition could be "rolled back" in the event of problems.

  19. How do I clear the formatting in a paragraph or block of text?

  20. What is skew and skew measurement?

  21. How do I change the default document font?

  22. What is the difference between look-up file and look-up, with a relevant example?

  23. I'm unable to connect sever database(oracle) from GDE(db config file) local system.i set all these

  24. What is Hybrid OLAP?

  25. Explain the encoding technique used in bitmaps indexes.

  26. Advertisement
  27. What are MOLAP and ROLAP?

  28. What are local and formal parameter?

  29. What are styles? How do I use them?

  30. What are the most commonly used components in a Abinition graph?can anybody give me a practical example of a trasformation of data, say customer data in a credit card company into meaningful output based on business rules?

  31. How to get DML using Utilities in UNIX?

  32. What is the latest version that is available in Ab-initio?

Advertisement