- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
SAP SQL Trace Tool Interview Questions & Answers - Learning Mode

SAP SQL Trace Tool Interview Questions & Answers - Learning Mode

SQL trace is a performance analysis tool that shows how open SQL statements are converted into native SQL statements. Its transaction code is ST05. SAP transaction ST05 can be used to trace execution of SAP program/job to catch performance statistics related to SQL statement execution, SAP enqueue operation, SAP RFC activities, SAP Buffer access and HTTP activities. So you can analyze trace to validate performance or identify performance bottleneck. SAP ST05 allows you to enter a SQL statement and analyze its execution plan without executing a program.

Try SAP SQL Trace Tool Interview Questions & Answers - Exam Mode
Subcategories for SAP SQL Trace Tool Interview Questions & Answers - Learning Mode

Following are sub categories for which Interview Questions & Answers are available under SAP SQL Trace Tool Interview Questions & Answers - Learning Mode. Please select the appropriate sub-category:-

ABB Tool Interview Questions & Answers (1) Learning Mode | Exam Mode

SAP Testing Tools Interview Questions & Answers (1) Learning Mode | Exam Mode

SQL Trace Tools Interview Questions & Answers (1) Learning Mode | Exam Mode


Sort By : Latest First | Oldest First | By Rating

SAP SQL Trace Tool Interview Questions & Answers - Learning Mode
Try SAP SQL Trace Tool Interview Questions & Answers - Exam Mode
Question: What is the difference between OLAP and Data Mining?

Answer: OLAP - On line Analytical processing is a reporting tool configured to understand your database schema ,composition facts and dimensions . By simple point-n-clicking, a user can run any number of canned or user-designed reports without having to know anything of SQL or the schema. Because of that prior configuration, the OLAP engine ?builds? and executes the appropriate SQL. Mining is to build the application to specifically look at detailed analyses, often algorithmic; even more often misapprop Source:
Question: What are datasets?

Answer: The sequential files (processed on application server) are called datasets. They are used for file handling in SAP. Source:
Question: How can an ERP such as SAP help a business owner learn more about how business operates?

Answer: In order to use an ERP system, a business person must understand the business processes and how they work together from one functional area to the other. This knowledge gives the student a much deeper understanding of how a business operates. Using SAP as a tool to learn about ERP systems will require that the people understand the business processes and how they integrate. Source:
Question: What SAP tools you use to install SAP patches?

Answer: SPAM is used to install SAP patches and SAINT is used to install SAP Add-ons. Source:
Question: 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 .
Question: 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.
Question: 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.
Question: 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 con Source:
Question: 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()
Question: Explain open SQL vs native SQL?

Answer: ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. If different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of standard SQL statements), allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tab Source:
Question: What are the major benefits of reporting with BW over R/3? Would it be sufficient just to Web-enable R/3 Reports?

Answer: Performance ? Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year-end ? now imagine that occurring even more frequently. Data analysis ? BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 b Source:


India News Network
Latest 20 Questions
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
"Holiday Packages" announced as an advertisement are an example of _________: (a) Offer (b) Counter Offer (c) Invitation to Offer (d) None of the above
A match fixing contract between a player and a broker is a: (a) Valid Contract (b) Unenforceable Contract (c) Void Contract (d) Illegal Contract
When a bookseller sells a book on cash payment then it is called as ___________: (a) Unilateral Contract (b) Bilateral Contract (c) Executed Contract (d) Executory Contract
____________ agreements are created by situation: (a) Written (b) Oral (c) Void (d) Implied
Cache = 0.03125 Seconds