Question 1 :
What are the tools used in SAP Implementation? How do you create Alert Messages?
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
Question 2 :
When spool buffer is full and new spool request is raised what happens to the request ? where does the request stored?
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.
Question 3 :
What is the difference between R3trans and Tp in SAP-DBA?
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.
Question 4 :
What is "Group by" in Select statement?
Group by is used to fetch a unique data from a column.
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()
Question 5 :
Select statement to read data into internal tables. Types of Select statements?
select * from database table into (internal table name)
the above statement collects data into the header area of the internal table.
select * from database table into table (internal table name)
the above statement collects the data into the body area directly .