Important SAP Database Interview Questions
Q – 1 Explain “Commit” and “Roll back” Commands?
Ans- 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).
Transactions begin with the first change to data and end with either a COMMIT or ROLLBACK. COMMIT makes the database changes permanent and visible to other database sessions. ROLLBACK undoes the changes made in the current transaction either to the beginning of the transaction or to a savepoint.
A savepoint is a named processing point in a transaction, created with the SAVEPOINT statement. Rolling back to a savepoint is a partial rollback of a transaction, wiping out all changes (and savepoints) that occurred later than the named savepoint.
Q – 2 What happens “Update” command is used without where clause?
Ans- Based on query condition. it will update all the fields which are mentioned in the query. ex: update employee set firstname= @firstname,lastname=@lastname where employee_id =@employee_id. so in the above case nothing wil be happen if you used where clause or not. if you have many statements in the query you need to use the where clause.
Q – 3 Difference between Insert, Update and Modify?
Ans- 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.
Q – 4 What is “Catch” Command?
Ans- Trying to catch any runtime errors programmatically or manually we use this statement catch.
Q – 5 What is the difference between R3trans and Tp in SAP-DBA?
Ans- 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 directorly but called from the Tp controle program or by the R/3 upgrade. Tp is the basic tool for the transporting the request.
Q – 6 What are the tools used in SAP Implementation? How do you create Alert Messages?
Ans- One of the Tools being used for SAP Implemention is QuickSizer, which is used to size the SAP Server based on number of users using various modules in SAP. Alert Message is created in the CCMS monitor using TCodes RZ20 and RZ21. The values for Alert
AutoReaction Methods are defined using the TCode RZ21, while this particular method is assigned to the Monitoring Tree Element (MTE) in the TCode RZ20. One as well can have an Alert Management System, where alerts from the Entire Landscape can be configured in a Central Monitoring System from where it can trigger a alert mail or SMS to the concerned Administrator
Q – 7 Select statement to read data into internal tables. Types of Select statements?
Ans- select * from database table into (internal table name) the above statement collects data into the header area of the internal table. and select * from database table into table (internal table name) the above statement collects the data into the body area directly.
Q – 8 What is Group by in Select statement using SAP database?
Ans- A “group by” is used to group selected rows in a table to perform arg functions on them. Rows not included in the “group by” clouse and not part of ARG functions cannot be used …(logical grouping of data) or orerations performed (on groups of data) can be used with the “HAVING” clause to further refine the output. ex of some ARG functions : SUM() , MIN(),MAX(), AVG()
Q – 9 When spool buffer is full and new spool request is raised what happens to the request ?
Ans- The new spool request will be in the queue. If it is urgent request then the current request will be be stoped and newrequest will be send.