Interview questions

Database Administrator (dba) interview questions – page 3

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

  1. Did u worked with functions, procedures in SQR?

  2. You have configured logrotate to rotate your logs weekly and keep them for eight weeks. You are running our of disk space. What should you do? Choose one:a. Quit using logrotate and manually save old logs to another location.b. Reconfigure logrotate to onl

  3. You notice that the amount of free space is getting low. When you check the contents of the /tmp directory you find several hundred files so you delete them. After deleting these temp files, you check the amount of free space, however, it has not increase

  4. Which of the following became obsolete with PS Ver8

  5. PSWORKLIST record is used for workflow routing . It should contains minimum of .

  6. You are a PeopleSoft Partner and wish to get information on database performance benchmark ( or something like this)Where would you look for the info ?

  7. SMTP sendMail failed error during testing of HRMS upgrade to 8.9 (8.46.09 tools). On all of our triggerbusinessevents trying to send an email, we receive the above error. Any help would be appreciated.

  8. How can a parent and child process communicate?

  9. What are all stored in System Catalog

  10. What are the Outputs of SQR?

  11. What is difference between lilo and stub?

  12. What are rename, reporting and layout commands, break point etc in sqr?

  13. Number of zeros in the product of the first 100 numbers?

  14. If u change the long name of translate field what object to be altered

  15. Simple Select Statement and Find the Results

  16. Where are workflow work items found ?

  17. Partition sizes can be set manually or from what configuration?

  18. What is meant by sticky bit? Choose one:a. When set on a directory, then only the owner of a file can delete it.b. When set on an executable, then any user can run the executable.c. When set on a file, only the owner can see the file in a directory listing

  19. What is app messaging, where did you use?

  20. Each command has two types of output. There are standard output and standard __________.

  21. How do you remove a file?

  22. How do you do number comparison in shell scripts?

  23. What is the difference between SaveEdit and FieldEdit?

  24. How do you keep your self professionally updated?

  25. Display Characteristics are associated with which peolecode event

  26. Is WebSphere certified on PeopleTools 8.1x

  27. Which of the following is correct in order to start the Process Scheduler Server from the command line using psadmin.

  28. How do you denote null in DB2?

  29. How can a subclass call a method or a constructor defined in a superclass?

  30. What Record Changes does not affect Database?

Companies that ask Database Administrator (dba) questions