SAP Database Interview Questions
And Answers Guide.
Global Guideline.
http://www.globalguideline.com/
SAP Database Interview Questions And Answers
SAP Database Job Interview Preparation Guide.
Question # 1
When spool buffer is full and new spool request is raised what happens to the request ?
Answer:-
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.
Read More Answers.
Question # 2
What is Group by in Select statement using SAP database?
Answer:-
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()
Read More Answers.
Question # 3
Select statement to read data into internal tables. Types of Select statements?
Answer:-
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 .
Read More Answers.
Question # 4
What are the tools used in SAP Implementation? How do you create Alert Messages?
Answer:-
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
Read More Answers.
Question # 5
What is the difference between R3trans and Tp in SAP-DBA?
Answer:-
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.
Read More Answers.
Question # 6
What is Catch Command?
Answer:-
Trying to catch any runtime errors programmatically or manually we use this statement catch.
Read More Answers.
Question # 7
Difference between Insert, Update and Modify?
Copyright http://www.GlobalGuideline.COM Page 2/5
SAP Database Interview Questions And Answers
Answer:-
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.
Read More Answers.
Question # 8
What happens Update command is used without where clause?
Answer:-
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.
Read More Answers.
Question # 9
Explain Commit and Roll back Commands?
Answer:-
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.
Read More Answers.
Copyright http://www.GlobalGuideline.COM Page 3/5
SAP (Systems, Applications, Products) Most Popular
Interview Topics.
1 : SAP ABAP Frequently Asked Interview Questions and Answers Guide.
2 : SAP (Systems, Applications, Products) Frequently Asked Interview Questions
and Answers Guide.
3 : SAP Modules Frequently Asked Interview Questions and Answers Guide.
4 : SAP Reports Frequently Asked Interview Questions and Answers Guide.
5 : SAP Internal Tables Frequently Asked Interview Questions and Answers
Guide.
6 : BDC (Batch Data Communication) Frequently Asked Interview Questions and
Answers Guide.
About Global Guideline.
Global Guideline is a platform to develop your own skills with thousands of job interview questions
and web tutorials for fresher's and experienced candidates. These interview questions and web
tutorials will help you strengthen your technical skills, prepare for the interviews and quickly revise
the concepts. Global Guideline invite you to unlock your potentials with thousands of Interview
Questions with Answers or begin a tutorial right away, such as HTML, XML, XSLT, Cascading
Style Sheet (CSS), Search Engine Optimization (SEO), JavaScript, Structure Query Language (SQL),
Database Articles, Web Hosting Guide and much more. Learn the most common technologies
Interview Questions and Answers. We will help you to explore the resources of the World Wide Web
and develop your own skills from the basics to the advanced. Here you will learn anything quite
easily and you will really enjoy while learning. Global Guideline will help you to become a
professional and Expert, well prepared for the future.
* This PDF was generated from http://www.GlobalGuideline.com at November 29th, 2012
* If any answer or question is incorrect or inappropriate or you have correct answer or you found any
problem in this document then don't hesitate feel free and e-mail us we will fix it.
You can follow us on FaceBook for latest Jobs, Updates and other interviews material.
www.facebook.com/InterviewQuestionsAnswers
Follow us on Twitter for latest Jobs and interview preparation guides
http://twitter.com/InterviewGuide
Best Of Luck.
Global Guideline Team
http://www.globalguideline.com
[email protected]
