SAP Basis Interview Question and Ans

DB Related Questions

1. What is the use of ops$  mechanism ? 

For the database, the SAP system is a single user, SAP<SAPSCHEMAID>, or SAPR3 whose password is stored in the table SAPUSER. Therefore, to access the database, the SAP system uses a mechanism called the OPS$ mechanism
To Avoid problems with the data consistency.

2. Which Oracle specific files must be saved during an online database backup to be able to restore the Oracle database to a consistent state?

 

Whole online backup and offline and online redo log files.

OrilogA,orilogB,mirriorlogA, mirriorlogB

3. what is the name of Oracle alert log file and where it is located as OS level

Alert_<sid.>.log

/oracle/SID/saptrace/background

4. If candidate has worked on UNIX/oracle platform.

  yes

SAP Related Questions

5. Where do you check the curent usage of extended memory in SAP

St04 and st02

6. What would you do if SAP system is not coming

Check  oracle archive directory may be full .file system may be full, there is not enough space under home directory. Check the log files located under work directory for abap system related log files

/usr/sap/SID/DV*/work

  

7. Have you seen update got deactivated ? If yes what is the reason

Yes, due to errors entered in the customer screen

8. What are V1/V2 updates in SAP

Normal and critical updates

9. IF you unable to login to SAP from GUI level, how would you check at OS level which processes are running

Dpmon is the command to check what the processes are running, consult with the customer and kill the required process which is running like background process.

  

10. Have you applied support packs, if yes .. What is SPAU and SPDD. Please specifically ask examples of SPAU and SPDD

yes

SPAU :repository related checks

The SPAU transaction contains the objects – Programs, Reports, Screens, Messages, Notes, Function Modules etc. which have difference in the Latest SAP request and the previous ones. This SPAU phase can be done either just after SPDD or after the Upgrade of the system by the Basis team.

SPDD :Data dictionary realted info  check

This transaction code SPDD is the core step in an upgrade project. The system compares all the dictionary objects – data elements, database tables and structures of the latest system (say CRM 70. EPH1) with the previous or the old system (e.g CRM 4.0).

These all elements are present under two nodes – with modification assistant and without modification assistant. Objects present under with modification assistant have the modification assistant ‘ON’ and we can see the modification logs.The objects in green color as shown below are the objects processed already and the ones in blue are the ones which still need to be processed. Apart from the nodes – ‘With modification assistant ‘and ‘Without modification assistant ‘, there is one more node sometimes – ‘Deleted objects’. This node contains objects which are deleted in the newer version of SAP and this node is to be left as it is. The objects under ‘With modification assistant’ and ‘Without modification assistant’ are to be processed by the ABAP team.

____________________________________________

JAVA Related Questions

11. If candidate has worked in JAVA. Where does the log related to JAVA get stored at OS level

Dev_jcontrol

Dev_dispatcher

Dev_bootstrap

Dev_jstart

Stdserver0.out

Avlialble.log

Jvmbootsrap.out

12. What is the default SMICM port for a instance with instance no 00   -- 8000

8000

13. How will you check if SLD is working correctly.

  SLD_Check

Question Related to OS (UNIX)

14.  if candidate has worked in any of the UNIX OS. ASk him how to list down hidden files in a particular directory

Ps-eaf