SAP DB Interview Questions

A logical database (LDB) in systems engineering is a representation of an organization's data, organized in terms of entities and relationships and is independent of any particular data management technology.

Respected sir,        I am doing job.Please send me more question on module pool programing(real time).  Please give me information about logical database....

Actually R3TRANS is used by TP (Both are SAP Kernel Programs) for anything to write from /to to database.R3 trans also writes transport logs in the DIR_TRANS/tmp directory, which after the job is fini...

R/3trans is the r/3 system transport program which can be used for transporting data between different sap systems ,even when they dont belong to the same group .R3trans normally is not used directo...

A SAP system can contain one and only one Central Instance. 
In the Central Instance you will have Message Server and Enque Workprocessor. The Message Server should be only one per a  single SAP system.

A central instance will be only one in the system.

The Host name is the name of the Computer where the instances (Database/SAP) is installed.
The SID referes to all the instances in a SAP system or a Database.

SID is nothing but a name for an Instance.Host is  the system which hosts the Instance.Hope you will get an idea with the following example,Local Installation: Here we have both Database Instance...

Date modifier distinguishes periods with same frequency but different date. Eg. 10 - for monthly pay period but with the pay date being 5th of every month.

Hope it answers your query.

The Date Modifier (Field name as DATMO) in Payroll is a NUMC 2 field. Its Significance is judged from its existance with Payroll Calendar. Check the view V_T549S_B  for  Payroll Calendar. Business...

A layer is the path to move the development objects and is always assigned to consolidation route.
A route defines the source and target systemd to move the objects and there are two routes---1. Consolidation route bet. DEV and QAS, 2. Delivery route bet. QAS and PRO.

SOX is Sarbanes-Oxley

Its one of the most comprehensive regulations on how companies manage their financial accounting and reporting in the USA.

Database Growth can be monitered from the T-Code DB02
Here you can find the growth of individual tablespaces also.

Common Language Runtime, a runtime environment that manages the execution of .net program code and provides services such as memory and exception management, debugging and profiling and security.

Ans: Commit and Rollbacks are the terms used in Oracle database, Commit is when a request is updated into the datebase tables completely then it is called as Commit, Rollback is nothing but in case of any errors or if a request is not updated into the datebase tabel its called as Rollback .

The Oracle RDBMS provides a transaction model based on a unit of work. The PL/SQL language supports most, but not all, of the database model for transactions (you cannot, for example, ROLLBACK FORCE)....

Update is only for update record not for insert, Modify is used as insert also

INSERT - Add a new record into the database table.

MODIFY - If record is available it modifies otherwise it wont modify.

UPDATE - If record is available its update the record otherwise it creates a new record.

Support package : SAP delivers Support Packages to remove any errors that appear in important transactions. Support Packages may contain language-dependent data, such as message texts, ABAP texts or s...

RMAN IS THE recovery manager of oracle backups
it will recover the backups and put them in the repository catalogue
RMAN is used by the oracle only
in SAP BR tools are used for the recovery of backups
But these BR tools are also integrated with the RMAN only

As my knowledge, copying of data can be done in two ways as per knowledge..1) copying a data from one client to another.... can be done ...  sccl ie client copy database copy can be done by ...

Spool buffer is the memory space which is allocated in DB level or OS level where all the datas are stored in that buffer area at the time giving prints. In another point of view we can say that all p...