SAP BASIS Interview Questions

SAP BASIS Interview Questions with hint:

1. On which port SAPINST runs? (21212 or 21213)
2. What are different types of client copy? (local, Remote & export import)
3. In export/Import client copy what are created ?( 3 transport req-> RX,RT, RO)
4. What is control file? how many control files present at DB?
5. What if one controlfile is corrupted?
6. What if one datafile is corrupted?
7. Tell me point in time recovery.
8. At OS level how you will check kernel level? (disp+work –v)
9. How you will check OS version at OS level? (uname -a)
10. Methods of system refsresh?
11. Steps of system refsresh with commands?
12. Steps of kernel upgrade?
13. Steps of oracle upgrade?
14. Why dbua and OUI is used for an oracle upgrade?
15. Troubleshoot background job delayed.
16. There are 3 Requests out of which only 2 Requests got imported to target. but 3rd Request is not getting imported. why? (local Request/import buffer full/tp check)
17. If size of my database is 650 gb, then what will be the size of export? (1/10 th of your databse size=65 gb here)
18. If I am trying to add datafile, it is not letting me to add though there is space, why?
19. What is spool store location? (paramter name, G & DB concepts expected)
20. What is spool buffer overflow error & how to trouble shoot it? any proactive action to resolve this issue?
21. What is access method and what are they? (printer related : L & F expected)
22. How to configure new printer? (steps)
23. How to disable import all option in STMS?
24. In which table, clients are stored? (T000)
25. In which table ST22 dumps are stored (SNAP)
26. What if my SAP* user is locked? (unlocked & reset at OS level: steps expected)
27. How to unlock user at OS level?
28. How to create control file in system refresh?
29. Difference between enhancement package and support packages?
30. Steps of SAP system installation?
31. What DVDs requires for installation?
32. In which tables T-codes are stored? (TSTC)
33. Difference betwwen Role & profile?
34. What is derived role?
35. What is pwd excpetion list & in which table it is stored? (USR40)
36. Troubleshoot if SAP system is down.
37. What is OPS$ mechanaism?
38. What is diagnostic agent?
39. What is private mode?
40. Types of RFC communication & explain each?
41. What is consolidation & delivery route?
42. Return codes of transports and explain each? (4, 8, 12 & 16)
43. Transport architecture.
44. Troubleshoot if transport request is hanged.
45. Types of transport Requests? (4 types: customizing, workbench, Transport of copies, Relocation)
46. How to take export of rfc?
47. How to transport request at os level?
48. What will you do if CPU values are showing null in st06? (related to SAPOSCOL)
49. How to define job? (steps, job class, variant etc expected)
50. DR concept.
51. What is Restore & recovery?
52. Generally we take sat sun offline backup and remaining weekdays online backup, what solution you will give if customer is not giving downtime for offline backup?
53. How to find out expensive SQL statements in SAP?(ST04 --> buffer gets)
54. What are SPDD & SPAU?
55. Where you can see logs of support patches? (both R/3 & OS level expected)
56. What is alert_SID.log contains? location of this file at os?
57. User is executing transaction, response is very slow, troubleshoot it.
58. What are online redo log, offline redo log & datafile contains?
59. If my orarach is full, how it will impact SAP?
60. What is oratab & what it contains?
61. During oracle upgrade when you run ./runinstaller it asks you to execute one script, tell me name of that script & why it is used?
62. If your SAP is down which logs you will check at OS level?
63. How you will check if your system is dual stack or not? (DB02--> PSAPSR3:ABAP, PSAPSR3DB: JAVA)
64. What is stack upgrade?
65. Difference between stack upgrade & support pack?
66. Scopes of oracle parameters?
67. Different shutdown modes of Oracle?
68. What is the status of database of DR? (Mount)
69. RDDIMPDP background job is used for?
70. What is logicat system name?
71. how to set logical system name and naming convention?
72. Preinstallation steps?
73. How to apply license at OS level?
74. What is the location & parameters of security audit log?(rsau/enable, rsau/local/fle, rsau/mx_diskspace/local etc)
75. What is memory allocation process for SAP workprocess? (Roll first, extended memory, remaining Roll area, heap memory)
76. In SM50 , when work process is on hold what are the reasons of on hold? (ENQ, PRIV, UPD, CPIC, RFC)
77. How many users each work process can handle?
78. Name and location of oracle log & trace files? (alert log, trace file, core dump file, audit file, network log)
79. What is Roll in & roll out?
80. What is SNOTE and is it possible to rollback SNOTE & support packs?