Interview questions

Database Administrator (dba) interview questions – page 25

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

  1. How do I insert a footnote or an endnote?

  2. Which procedure should be used to make the DFF read only at run time?

  3. What is lockbox?

  4. What is set of books?

  5. How can I track changes made to a document?

  6. Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?

  7. What are different types of images?

  8. How can you restrict the access(to oracle apps)to a group of users using personalization?

  9. What are the different types of lookups in datastage?

  10. What are the different types of lookups available in DataStage?

  11. What are the different types of key triggers ?

  12. Wht is the difference beteen validated ok and compiled in datastage.

  13. How to find the number of rows in a sequential file?

  14. How do you do Usage analysis in datastage ?

  15. How we can call the routine in datastage job?explain with steps?

  16. Can I have different page formatting within one document?

  17. Purpose of using the key and difference between Surrogate keys and natural key

  18. What does an on-clear-block Trigger fire?

  19. What is Distributed database ?

  20. How do you run ms_batch file in forms?what could be the value :system.mode?

  21. Describe two phases of Two-phase commit ?

  22. My security rules don't work for the Account Analysis and General Ledger reports in Release 11.0.3.

  23. What are the environment variables in datastage?give some examples?

  24. Explain the process of taking backup in DataStage?

  25. How do I control where a column ends?

  26. I have defined a security rule and assigned it to my responsibilty, but is still does not work, why?

  27. State the order in which these triggers are executed ?

  28. Is there a way to assign different security rules to a responsibility based on the User ID?

  29. How do I remove the page number from the first page?

  30. Can Security Rules prevent users in one organization in the same set of books from adding Cross Validation Rules to another organization?

Companies that ask Database Administrator (dba) questions