SAP BASIS sample interview questions part III

Administration

1. As an administrator what are the Transactions code that you would use
Ans. The most commonly used transactions by me are sm50, st02, st06, st07, spad, db01, st05.
2. What are ST04, DB02, DB16 and ST06 used for?
St04 – database performance
Db02 – database monitoring
Db16 – database tuning
St06 – OS monitor

Backup & Restore

1. Suggest a backup strategy for a client, which works 365 days a year.
Online backup is the solution I will provide and the archive log mode is on.
2. What is the advantage of taking backup to a disk and then to the tape?
3. Have you used any other backup solution?
4. Have you ever restored?

Homogenous / Heterogeneous Copy

1. What is the difference between remote client copy and client export and import?
2. What is homogenous system copy?
3. What is heterogeneous system copy?
4. Your PM tells that you have to move a whole SAP system from one machine to the other how would you go about it?
5. What is the step where you would specify the different SID to be used?
6. Can you change the SID during copy?
7. Can you change the hostname during copy?

Patches

1. You have to load new kernel patches, how would you go about the same?
2. If there is a problem in R3 trans after the kernel upgrade, what would you do?
3. What is Spam used for?
4. What is the Client that you would use to apply patches?
5. Will you use DDIC, or SAP*? If not why?
6. What are the phase while loading the patches?

Profile Parameters

1. A colleague of yours changed a parameter in one of the application server, and it is behaving differently what would you do?
2. What is the program that you would use from SID ADM to check the parameters? - SAPPFPAR
3. Where are the profile files located?

Saprouter

1. How and where would you configure the Saprouter?
2. Why not on CI or DI?
3. What is the name of the file where you specify the permissions?
4. Do you think that it is cost effective tool?

Printing

1. Have you worked on any third party printing option with SAP?
2. How will you configure a printer in SAP?
3. Where are the Spool Logs stored?
4. How would you clean them? Why not delete them?

Background Jobs

1. A user calls and reports to you that his background job is taking long time, and which normally does not take so much time. What will you do?
2. Can you kill an active job?
3. What is repercussion of the same?

BW

1. How will you enable BW statistics cube?
2. How would you enhance the performance of the Delta load from R/3 to BW?

EDT (Electronic Data Transfer)

1. How do you go about configuring EDT?
2. What are the ini files in EDT?
3. What type of RFC connection would you use for EDT?
4. What is the program file that you would execute in the Background for the Email transfer to happen?
5. How would the FAX used to pick the number to be dialed
6. How would you configure internet users?
7. How would you enable SAP office for the users?

Oracle

1. What would you do if you get an error called SNAP Shot too Old, or ORA -1555 or ORA -1650
2. Can you create your own roll back segments?
3. Can you allocate Rollback segments for a particular JOB or Tcode?
4. What is SGA?
5. Which is the process that is used for writing logs?
6. What is the process that may or may not run and would not affect your functioning of oracle?
7. Can you give a size of data file more than 2 GB?
8. Which is the profile file for listener and where is it located?