Trivia Quiz: SQL And SAP Advanced Business Application Program!

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Joshua Lieghio

Joshua Lieghio, System Analysis

Joshua is a Support Engineer with 4 years of experience in System Analysis, Service Delivery, and Incident Handling, along with 3 years in Customer Service. He has recently completed a Diploma in ICT Technologies.

Quizzes Created: 1 | Total Attempts: 414

| Attempts: 414

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

1/52 Questions

Which of the following is not a component of dialog response time?
- Wait time
- Roll In/Out
- Database Request
- CPU idle time

About This Quiz

Are you a computer programmer looking for a way to test their understanding when it comes to the advanced business application program SQL and SAP language? You are in luck as the quiz below will do that for you. Do give it a try and see just how well you understand them both. All the best!

Trivia Quiz: SQL And SAP Advanced Business Application Program! - Quiz

Quiz Preview

2.

A Single Statistical Record captures an entire transaction in SAP.
- True
- False
Correct Answer

A. False

Explanation

A Single Statistical Record does not capture an entire transaction in SAP. It is used to store statistical data related to a specific transaction or event, but it does not contain all the details and information of the transaction itself.

Rate this question:
3.

Which of the following transactions are used in evaluating system performance? There are 3 correct answers
- ST03
- SM04
- SM66
- SM36
Correct Answer(s)

A. ST03
A. SM04
A. SM66

Explanation

ST03, SM04, and SM66 are transactions that are used in evaluating system performance.

ST03 is a transaction used for workload analysis and performance monitoring. It provides information about system resources, response times, and workload distribution.

SM04 is a transaction used for user monitoring. It displays information about logged-in users, their activities, and resources being used.

SM66 is a transaction used for monitoring and managing work processes. It provides information about the status and performance of work processes in the system.

These transactions help administrators and system analysts in evaluating and optimizing the performance of the system.

Rate this question:
4.

Where is the default location of the statistical records that are written to the fie system?
- /usr/sap/trans
- Sapmnt/<SID>
- /usr/sap/data
- /usr/sap/<SID>/DVEBMGS##/data
Correct Answer

A. /usr/sap/<SID>/DVEBMGS##/data

Explanation

The correct answer is /usr/sap//DVEBMGS##/data. This is the default location where the statistical records are written to the file system. The /usr/sap directory is the root directory for SAP installations, and represents the system ID of the SAP system. DVEBMGS## represents the instance number of the SAP system. The /data directory within this path is where the statistical records are stored.

Rate this question:
5.

Which of the following transactions are used to evaluate the work process statuses and activities that are currently happening? There are 2 correct answers
- SM50
- ST06
- SM66
- ST02
Correct Answer(s)

A. SM50
A. SM66

Explanation

SM50 and SM66 are the correct answers because these transactions in SAP are used to monitor and evaluate the work process statuses and activities that are currently happening. SM50 provides an overview of the work processes in the system and allows for analysis and troubleshooting, while SM66 displays the current status of all work processes in the system and provides detailed information about each process. Both transactions are essential for monitoring and managing the work processes in SAP.

Rate this question:
6.

Which of the following are two key criteria when evaluating performance problems? There are 2 correct answers
- Did the performance problem occur in the past?
- Which user is experiencing the problem?
- Is the problem happening right now?
- How close is it to quitting time?
Correct Answer(s)

A. Did the performance problem occur in the past?
A. Is the problem happening right now?

Explanation

When evaluating performance problems, two key criteria are whether the problem occurred in the past and whether the problem is happening right now. These criteria help in understanding the nature and timing of the performance issue. By considering whether the problem occurred in the past, one can identify any recurring patterns or potential causes. Evaluating whether the problem is happening right now helps in assessing the immediate impact and urgency of the issue. The other options, such as which user is experiencing the problem and how close it is to quitting time, are not directly related to evaluating performance problems.

Rate this question:
7.

SWAPS in transactions ST02 are an indication of high CPU utilization.
- True
- False
Correct Answer

A. False

Explanation

The statement is false because SWAPS in transactions ST02 are not necessarily an indication of high CPU utilization. SWAPS can occur due to various reasons such as insufficient memory, inefficient memory management, or high disk I/O. While high CPU utilization can contribute to SWAPS, it is not the only factor. Therefore, SWAPS in transactions ST02 can be caused by factors other than high CPU utilization.

Rate this question:
8.

Which of the following profile parameters affect activation of dynamic work processes?
- Rdisp/wp_no_dia
- Rdisp/wp_no_btc
- Rdisp/wp_no_enq
- Rdisp/dynamic_wp_check
Correct Answer

A. Rdisp/dynamic_wp_check

Explanation

The profile parameter "rdisp/dynamic_wp_check" affects the activation of dynamic work processes. This parameter determines whether the system should automatically activate additional work processes when the existing ones are fully utilized. If this parameter is set to "1", the system will activate dynamic work processes as needed. If it is set to "0", the system will not activate additional work processes dynamically.

Rate this question:
9.

Virtual memory is made up of OS swap or page file and physical memory components.
- True
- False
Correct Answer

A. True

Explanation

Virtual memory is a memory management technique used by operating systems to provide the illusion of having more physical memory than is actually available. It is made up of two main components: the OS swap or page file, which is a portion of the hard drive used as an extension of physical memory, and the physical memory itself, which includes RAM. This allows the operating system to store data that is not currently being used in physical memory and retrieve it when needed. Therefore, the statement that virtual memory is made up of OS swap or page file and physical memory components is true.

Rate this question:
10.

In transaction ST02, there is a problem if there is a lot of swapping in the SAP buffers.
- True
- False
Correct Answer

A. True

Explanation

In transaction ST02, if there is a lot of swapping in the SAP buffers, it indicates a problem. Swapping refers to the process of moving data between the physical memory and the disk storage. When there is excessive swapping, it means that the system is constantly moving data in and out of the memory, which can lead to performance issues and slower response times. Therefore, the statement "True" suggests that a problem exists when there is a high amount of swapping in the SAP buffers.

Rate this question:
11.

Which of the following parameters lead to the allocation of heap memory for dialog processes? There are 2 correct answers
- Em/initial_size_MB
- Em/max_size_MB
- Rdisp/roll_SHM
- Ztta/roll_extension
Correct Answer(s)

A. Em/max_size_MB
A. Ztta/roll_extension

Explanation

The parameters "em/max_size_MB" and "Ztta/roll_extension" lead to the allocation of heap memory for dialog processes. The "em/max_size_MB" parameter determines the maximum size of the extended memory (heap) that can be allocated for a single dialog work process. The "Ztta/roll_extension" parameter determines the size of the extended memory (heap) extension for roll area. These parameters control the allocation of heap memory for dialog processes, allowing them to efficiently manage and utilize memory resources during their execution.

Rate this question:
12.

The user's context is initially stored in the heap area in shared memory.
- True
- False
Correct Answer

A. False

Explanation

The user's context is not initially stored in the heap area in shared memory. The user's context is typically stored in the stack area of memory. The stack is used to keep track of function calls, local variables, and other data related to the execution of a program. The heap, on the other hand, is used for dynamically allocated memory. Therefore, the correct answer is False.

Rate this question:
13.

Which of the following from the Operating System Monitor (transaction ST06) indicates that there is some hardware bottleneck in the SAP system if it happens all the time? There are 2 correct answers
- High CPU utilization near 100%
- High CPU idle time
- High swap/paging activity
- High DB time
Correct Answer(s)

A. High CPU utilization near 100%
A. High swap/paging activity

Explanation

High CPU utilization near 100% indicates that there is a hardware bottleneck in the SAP system because it means that the CPU is constantly running at maximum capacity, which can indicate that it is struggling to handle the workload. Similarly, high swap/paging activity also suggests a hardware bottleneck as it indicates that the system is frequently swapping data between the RAM and the hard disk, which can slow down performance and indicate a lack of available memory.

Rate this question:
14.

There is hardware bottleneck in the CPU if processing time is more than twice the CPU time.
- True
- False
Correct Answer

A. True

Explanation

If the processing time is more than twice the CPU time, it indicates that the CPU is not able to handle the workload efficiently. This suggests that there is a hardware bottleneck in the CPU, meaning that the CPU is unable to process data as quickly as it should. This can result in slower overall performance and decreased efficiency in completing tasks. Therefore, the statement "True" is correct.

Rate this question:
15.

Which of the following tools can be used to check the formulas and the values used in the formula-based memory parameters?
- Transaction ST02
- SAP Management Console
- Executable program sappfpar
- Transaction RZ10
Correct Answer

A. Executable program sappfpar

Explanation

The executable program sappfpar can be used to check the formulas and the values used in the formula-based memory parameters. This program allows users to view and modify the memory parameters in the SAP system. It provides a comprehensive overview of the current memory settings and allows users to analyze and optimize the memory allocation based on the formulas and values used in the parameters.

Rate this question:
16.

pHYS_MEMSIZE indicates how much memory is used in an SAP instance and it can be used to automatically initiate changes of those formula_based memory parameters.
- True
- False
Correct Answer

A. True

Explanation

The explanation for the given correct answer is that PHYS_MEMSIZE is a parameter that indicates the amount of memory used in an SAP instance. This parameter can be used to automatically initiate changes to formula-based memory parameters. Therefore, the statement that PHYS_MEMSIZE can be used to automatically initiate changes of those formula-based memory parameters is true.

Rate this question:
17.

Which of the following statements is considered to be an expensive SQL statement? There are 2 correct answers
- SQL statement which requires many records to be transferred to the ABAP program.
- SQL statement which uses index during data retrieval.
- SQL statement which reads many blocks but retrieves only a few records from the database.
- SQL statement which uses table buffering.
Correct Answer(s)

A. SQL statement which requires many records to be transferred to the ABAP program.
A. SQL statement which reads many blocks but retrieves only a few records from the database.

Explanation

An expensive SQL statement refers to a statement that requires a significant amount of resources, such as time, memory, or disk I/O, to execute. In this case, the two correct answers are "SQL statement which requires many records to be transferred to the ABAP program" and "SQL statement which reads many blocks but retrieves only a few records from the database." These statements involve transferring or reading a large amount of data, which can be time-consuming and resource-intensive, making them expensive in terms of execution.

Rate this question:
18.

Which of the following statements is true about the SQL Monitor? There are 3 correct answers
- SQL Monitor can be switched on for all or dedicated servers.
- SQL Monitor is designed to trace a single process.
- SQL Monitor can trace every SQL statement coming from ABAP programs, which include all OPEN SQL, native SQL, and ABAP kernel SQL statements.
- SQL Monitor has low impact on the performance of the production system.
Correct Answer(s)

A. SQL Monitor can be switched on for all or dedicated servers.
A. SQL Monitor can trace every SQL statement coming from ABAP programs, which include all OPEN SQL, native SQL, and ABAP kernel SQL statements.
A. SQL Monitor has low impact on the performance of the production system.

Explanation

The SQL Monitor can be switched on for all or dedicated servers, allowing for flexibility in monitoring options. It is designed to trace a single process, allowing for detailed analysis of specific queries. Additionally, the SQL Monitor can trace every SQL statement coming from ABAP programs, including OPEN SQL, native SQL, and ABAP kernel SQL statements. Despite its comprehensive monitoring capabilities, the SQL Monitor has a low impact on the performance of the production system, ensuring minimal disruption to ongoing operations.

Rate this question:
19.

Which of the following SQL statements cannot be tuned? There are 3 correct answers
- SQL statements used by ABAP programs
- SQL statements used by SAP Basis Tables
- Recursive SQL statements
- SQL statements used by Database Administration Tools
Correct Answer(s)

A. SQL statements used by SAP Basis Tables
A. Recursive SQL statements
A. SQL statements used by Database Administration Tools

Explanation

SQL statements used by SAP Basis Tables, Recursive SQL statements, and SQL statements used by Database Administration Tools cannot be tuned. Tuning refers to the process of optimizing the performance of SQL statements. However, these types of SQL statements have specific purposes or functionalities that cannot be modified or optimized for better performance. SQL statements used by ABAP programs, on the other hand, can be tuned to improve their performance.

Rate this question:
20.

The ABAP trace (transaction SE30 or SAT) is the tool to use if want to find out more about the expensive SQL statements and its execution plan.
- True
- False
Correct Answer

A. False

Explanation

The ABAP trace is not the tool to use if you want to find out more about expensive SQL statements and their execution plan. The correct tool to use for this purpose is the SQL trace (transaction ST05). The ABAP trace is used to analyze ABAP code and its performance, while the SQL trace specifically focuses on SQL statements and their performance.

Rate this question:
21.

Which of the following can be found in the Explain function in SQL trace? There are 3 correct answers
- Execution plan (table/index access)
- Estimated costs/Estimated rows
- Memory usage
- Table/indexes statistics
Correct Answer(s)

A. Execution plan (table/index access)
A. Estimated costs/Estimated rows
A. Table/indexes statistics

Explanation

The Explain function in SQL trace provides information about the execution plan, including table and index access. It also provides estimated costs and estimated rows for the query. Additionally, it includes statistics about the tables and indexes used in the query.

Rate this question:
22.

Programs which show database request time >40% (response times - wait time) in the transaction profile of ST03 are potential candidates for containing expensive SQL statements.
- True
- False
Correct Answer

A. True

Explanation

Programs that have a high percentage of database request time in the transaction profile of ST03 indicate that a significant portion of the program's execution time is spent on executing SQL statements. This suggests that the program may contain expensive SQL statements, which could be causing performance issues. Therefore, the statement is true.

Rate this question:
23.

Which of the following are valid options for table buffering types? There are 3 correct answers
- Single record buffered
- Generic area buffered
- Fully buffered
- Client specific buffered
Correct Answer(s)

A. Single record buffered
A. Generic area buffered
A. Fully buffered

Explanation

The question asks for valid options for table buffering types. The correct answer is "Single record buffered," "Generic area buffered," and "Fully buffered." These are all valid options for table buffering types.

Rate this question:
24.

Which of the following parameters controls the buffer synchronization behavior in the SAP system?
- Rdisp/ddlogmode
- Rdisp/switch_bufmode
- Rdisp/bufremode
- Rdisp/auto_buf
Correct Answer

A. Rdisp/bufremode

Explanation

The parameter rdisp/bufremode controls the buffer synchronization behavior in the SAP system. This parameter determines whether the system should remove data from the buffer when it is no longer needed or keep it for future use. By setting this parameter to a specific value, the system can optimize the buffer usage and improve performance by managing the data in the buffer efficiently.

Rate this question:
25.

Table buffering is recommended for which of the following scenarios? There are 2 correct answers
- Tables that are seldom changed.
- Large tables that are often accessed.
- Customizing data.
- Transaction data.
Correct Answer(s)

A. Tables that are seldom changed.
A. Customizing data.

Explanation

Table buffering is recommended for tables that are seldom changed and customizing data. Table buffering allows for the temporary storage of frequently accessed data in the application server's memory, reducing the need for frequent database accesses. This can greatly improve performance for tables that are rarely changed, as the data can be retrieved quickly from the buffer instead of making repeated database calls. Additionally, customizing data, which is specific to individual users or organizations, can also benefit from table buffering as it is often accessed frequently by those users.

Rate this question:
26.

SQL trace (transaction ST05) offers a lot of information on table accesses, which includes the database activities, number of ABAP requests, and number of invalidations.
- True
- False
Correct Answer

A. False

Explanation

The statement is false because SQL trace (transaction ST05) does not provide information on table accesses, database activities, number of ABAP requests, or number of invalidations. SQL trace is used to trace and analyze the SQL statements executed by the database during the execution of an ABAP program. It helps in identifying performance issues and optimizing the SQL statements.

Rate this question:
27.

Which of the following types of RFC calls guarantees multiple communications steps in a specific order?
- Asynchronous RFC
- Transactional RFC
- Queued RFC
- Synchronous RFC
Correct Answer

A. Queued RFC

Explanation

Queued RFC calls guarantee multiple communication steps in a specific order. In a queued RFC, the system queues the requests and processes them sequentially, ensuring that each step is executed in the order it was received. This is particularly useful when multiple steps need to be executed in a specific sequence, such as in a batch processing scenario. Asynchronous RFC, Transactional RFC, and Synchronous RFC do not guarantee a specific order of communication steps.

Rate this question:
28.

What is RFC+CPIC time in synchronous RFC?
- Time needed to establish the RFC communications to the RFC server.
- Time needed to establish the RFC communication plus roll out time, roll wait time, and roll in time.
- Roll wait time caused by RFC communication.
- GUI time.
Correct Answer

A. Time needed to establish the RFC communication plus roll out time, roll wait time, and roll in time.

Explanation

The RFC+CPIC time in synchronous RFC refers to the time required to establish the RFC communication with the RFC server, as well as the additional time needed for roll out, roll wait, and roll in processes. This includes the time for transferring data, waiting for responses, and integrating the results back into the system. The answer option captures all of these components, providing a comprehensive explanation of the RFC+CPIC time in synchronous RFC.

Rate this question:
29.

Which of the following tools is best for monitoring and analyzing issues in the transactional RFC queue?
- SM58
- SMQ1
- SMQ2
- ST05
Correct Answer

A. SM58

Explanation

SM58 is the correct answer because it is the transaction code used for monitoring and analyzing issues in the transactional RFC queue. SM58 allows users to view and manage the tRFC (transactional RFC) queues, which are used for asynchronous communication between SAP systems. It provides detailed information about the status, errors, and processing of tRFCs, allowing users to identify and resolve any issues efficiently. SMQ1 and SMQ2 are transaction codes used for monitoring and managing the qRFC (queued RFC) queues, while ST05 is a transaction code used for performance analysis and tuning.

Rate this question:
30.

Which of the following RFC quota parameters should be set to maintain the number of dialog work processes that should be kept free for users?
- Rdisp/rfc_max_own_wp
- Rdisp/rfc_min_wait_dia_wp
- Rdisp/rfc_max_own_login
- Rdisp/rfc_max_comm_entries
Correct Answer

A. Rdisp/rfc_min_wait_dia_wp

Explanation

The parameter rdisp/rfc_min_wait_dia_wp should be set to maintain the number of dialog work processes that should be kept free for users. This parameter determines the minimum number of dialog work processes that should be available for user requests. By setting this parameter appropriately, the system ensures that there are enough free work processes to handle user interactions efficiently.

Rate this question:
31.

Which RFC type is used if you want to establish communication with a remote system, but don't want to wait for the result for further processing?
- Synchronous RFC (sRFC)
- Asynchronous RFC (aRFC)
- Transactional RFC (tRFC)
- Background RFC (bgRFC)
Correct Answer

A. Asynchronous RFC (aRFC)

Explanation

Asynchronous RFC (aRFC) is the correct answer because it allows the caller to continue with further processing without waiting for the result of the remote system's communication. This means that the caller can initiate the communication and move on to other tasks, while the remote system processes the request and sends the result back at a later time. This is useful in scenarios where the caller does not need the immediate response and wants to optimize performance by not waiting for the result.

Rate this question:
32.

Which features does the SQL Monitor offer? There are 2 correct answers
- It can be switched on for all or dedicated servers of an ABAP system.
- It can be optimized expensive SQL statements automatically.
- It can trace each and every SQL statement coming from an ABAP program.
- It can trace the SQL execution of selected ABAP work processes.
Correct Answer(s)

A. It can be switched on for all or dedicated servers of an ABAP system.
A. It can trace each and every SQL statement coming from an ABAP program.

Explanation

The SQL Monitor offers the ability to switch it on for all or dedicated servers of an ABAP system, allowing for comprehensive monitoring. Additionally, it can trace each and every SQL statement coming from an ABAP program, providing detailed analysis of SQL execution.

Rate this question:
33.

What is stored in extended memory? There are 2 correct answers
- User context data.
- Buffered programs and tables.
- Objects associated with individual users and their open transactions.
- Application program data that correspond to specific ABAP commands, such as "export to memory".
Correct Answer(s)

A. User context data.
A. Objects associated with individual users and their open transactions.

Explanation

Extended memory stores user context data and objects associated with individual users and their open transactions. This means that extended memory holds information about the current state of a user's session and any ongoing transactions they have. It also stores objects that are specific to each user, such as temporary data or variables. Additionally, extended memory can hold application program data that corresponds to specific ABAP commands, like exporting data to memory.

Rate this question:
34.

In transaction Operating System Monitor (ST06) in an ABAP-only system, how can you recognise a memory bottleneck? There are 2 correct answers
- In a Unix system, more than 20% of RAM paged out/swapped out per hour.
- In a Windows system, more than 25% of RAM paged in per hour.
- In Unix system, more than 20% of RAM paged in/swapped in per hour.
- In a Windows system, more than 20% of RAM pages out per hour.
Correct Answer(s)

A. In a Unix system, more than 20% of RAM paged out/swapped out per hour.
A. In a Windows system, more than 25% of RAM paged in per hour.

Explanation

In the transaction Operating System Monitor (ST06) in an ABAP-only system, a memory bottleneck can be recognized by monitoring the amount of RAM being paged out or swapped out per hour. In a Unix system, if more than 20% of RAM is paged out or swapped out per hour, it indicates a memory bottleneck. Similarly, in a Windows system, if more than 25% of RAM is paged in per hour, it indicates a memory bottleneck.

Rate this question:
35.

What are reserved work processes?
- Work processes that are started in certain situations and are stopped again when no longer needed.
- Dialog work processes that can only be used for a specific task.
- Work processes used to communicate with printers.
- Work processes used to perform non-urgent changes to a database.
Correct Answer

A. Dialog work processes that can only be used for a specific task.

Explanation

Reserved work processes are dialog work processes that can only be used for a specific task. These work processes are allocated for specific activities and are not available for general use. They are reserved and dedicated to performing a particular function or task, ensuring efficient and specialized processing. Once the task is completed, these work processes are released and made available for other tasks or activities.

Rate this question:
36.

What is the purpose of buffering data in SAP table buffers? There are 2 correct answers
- To creating better access paths to data.
- To speed up access to data.
- To save space on the hard disk.
- To reduce load on the database.
Correct Answer(s)

A. To speed up access to data.
A. To reduce load on the database.

Explanation

Buffering data in SAP table buffers serves two purposes: to speed up access to data and to reduce load on the database. By buffering data, frequently accessed data is stored in memory, allowing for faster retrieval times. Additionally, buffering helps reduce the number of database requests, thereby reducing the load on the database server. This improves overall system performance and efficiency.

Rate this question:
37.

With transaction Operating System Monitor (ST06) - Top 40 CPU Processes, you identified a process with unusually high CPU utilization. What are the next steps to check the root cause? There are 2 correct answers
- If it is a database process, you use the database monitor (ST04) and check if this activity can be tuned or moved to another time.
- If this process leaves 10% or less overall CPU idle time, there is no need for further action because there is still headroom.
- If it an SAP work process, you compare the process ID (PID) to the list of transaction in SM50 to find out what activity is causing the load.
- If it is the SAP gateway process, you might check if update processing can be moved to another instance.
Correct Answer(s)

A. If it is a database process, you use the database monitor (ST04) and check if this activity can be tuned or moved to another time.
A. If it an SAP work process, you compare the process ID (PID) to the list of transaction in SM50 to find out what activity is causing the load.

Explanation

The first step to check the root cause is to use the database monitor (ST04) to analyze if the high CPU utilization is caused by a database process. This involves checking if the activity can be optimized or scheduled at a different time. The second step is to compare the process ID (PID) of the SAP work process to the list of transactions in SM50. This helps identify the specific activity that is causing the high CPU load.

Rate this question:
38.

Why is buffer synchronization important in an SAP system with more than one instance? There are 2 correct answers
- To prevent outdated data from being selected from buffers.
- To prevent outdated data being committed to the database.
- To improve performance.
- To reduce the load on the database.
Correct Answer(s)

A. To prevent outdated data from being selected from buffers.
A. To prevent outdated data being committed to the database.

Explanation

Buffer synchronization is important in an SAP system with more than one instance to prevent outdated data from being selected from buffers and to prevent outdated data from being committed to the database. When multiple instances are accessing and updating the same data, it is crucial to synchronize the buffers to ensure that all instances have the most up-to-date information. This helps to maintain data integrity and consistency across the system. By preventing outdated data from being selected or committed, buffer synchronization ensures that users are always working with the most accurate and reliable data.

Rate this question:
39.

How is SAP Dialog Response time defined?
- As the time span between the dispatcher receives a request till he sends out the final response to the front end.
- As the time span between the browser sends a request to the back-end till he completely rendered the response
- As the time span between the roll-in and the roll-out of a work process is once completed.
- As the time span between an ABAP request is being loaded into the program buffer till the request processing is finished.
Correct Answer

A. As the time span between the dispatcher receives a request till he sends out the final response to the front end.

Explanation

The SAP Dialog Response time is defined as the time span between the dispatcher receiving a request and sending out the final response to the front end. This means that it measures the time it takes for the SAP system to process a request and provide a response to the user. It does not include the time taken for the browser to send the request or for the back-end to completely render the response. It also does not refer to the time span between the roll-in and roll-out of a work process or the loading of an ABAP request into the program buffer.

Rate this question:
40.

How can you identify potentially expensive SQL statements in programs with transaction Local Work Process Overview (SM50)? There are 2 correct answers
- The executing work process has a long-running action with "sequential read".
- The executing work process has a long-running action with "PRIV".
- The executing work process has a long-running action with "direct read".
- The executing work process has a long-running action with "semaphore".
Correct Answer(s)

A. The executing work process has a long-running action with "sequential read".
A. The executing work process has a long-running action with "direct read".

Explanation

The presence of a long-running action with "sequential read" and "direct read" in the executing work process indicates potentially expensive SQL statements in programs with transaction Local Work Process Overview (SM50). These actions suggest that the work process is spending a significant amount of time reading data sequentially or directly from the database, which can be a sign of inefficient or poorly optimized SQL queries. By identifying these actions, one can focus on optimizing the corresponding SQL statements to improve performance and potentially reduce costs.

Rate this question:
41.

What information can be retrieved with transaction Local Work Process Overview (SM50)? There are 3 correct answers
- Work process utilization data of all instances of an SAP system.
- Automatically refreshed information on local work process utilization.
- The status of an individual work process, for example, waiting, running, on hold, etc.
- The process ID of the work process.
- The program that is currently executed by the work process.
Correct Answer(s)

A. The status of an individual work process, for example, waiting, running, on hold, etc.
A. The process ID of the work process.
A. The program that is currently executed by the work process.

Explanation

The transaction Local Work Process Overview (SM50) allows users to retrieve the status of an individual work process, such as whether it is waiting, running, or on hold. It also provides the process ID of the work process and the program that is currently being executed by the work process.

Rate this question:
42.

You are investigating a performance problem. In transaction Work Process Overview (SM50 or SM66) you see that many work processes stay in status 'running' with action 'read directly' and 'sequential read' for a long time. What do you do next?
- Analyze the database.
- Analyze the SAP memory configuration.
- Perform a LAN Check by Ping.
- Check the 'Top 40 CPU Processes' in transaction Operating System Monitor (ST06(n))
Correct Answer

A. Analyze the database.

Explanation

The correct answer is to analyze the database. This is because the given information suggests that the work processes are spending a long time in the 'running' status with actions related to reading data from the database. Therefore, it is logical to investigate the performance of the database to identify any issues or bottlenecks that may be causing the delay in processing. Analyzing the SAP memory configuration, performing a LAN check, or checking the top CPU processes may be relevant in other scenarios, but in this specific case, analyzing the database is the most appropriate next step.

Rate this question:
43.

Where can you find the top expensive SQL statements on the system?
- In the cursor cache of the DBS Cockpit.
- In the transaction Operating System Monitor (ST06(n)).
- In transaction SQL trace (ST05 or ST12).
- In transaction Work Process Overview (SM50 and SM66).
Correct Answer

A. In the cursor cache of the DBS Cockpit.

Explanation

The cursor cache of the DBS Cockpit is the correct answer because it is the specific location where the top expensive SQL statements on the system can be found. The other options mentioned (transaction Operating System Monitor, transaction SQL trace, and transaction Work Process Overview) do not specifically mention the cursor cache of the DBS Cockpit as the location to find the top expensive SQL statements.

Rate this question:
44.

In which sequence do dialog work processes allocate memory as of SAP NetWeaver 7.40?
- Extended memory, Heap memory
- Heap memory, Extended memory
- Local memory, Extended memory, Heap memory
- Heap memory, Extended memory, PRIV memory
Correct Answer

A. Extended memory, Heap memory

Explanation

In SAP NetWeaver 7.40, dialog work processes allocate memory in the sequence of extended memory first and then heap memory. Extended memory is used for storing large amounts of data that cannot fit in the main memory, while heap memory is used for dynamic memory allocation during program execution. This sequence ensures that the dialog work processes first utilize the extended memory for data storage and then use the heap memory for any additional memory requirements.

Rate this question:
45.

Which of the following areas of an instance's shared memory has a corresponding file on hard disk to which SAP system will copy data that would not fit in that shared memory area?
- PROC buffer.
- Paging buffer.
- SAP buffer (programs, tables, and so on).
- Extended memory (user contexts).
Correct Answer

A. Paging buffer.

Explanation

The paging buffer in an instance's shared memory is used to store data that cannot fit in the shared memory area. This data is copied to a corresponding file on the hard disk by the SAP system. This allows the system to free up space in the shared memory area and retrieve the data from the hard disk when needed. The other options, such as PROC buffer, SAP buffer, and extended memory, do not involve copying data to the hard disk.

Rate this question:
46.

What are some of the negative effects of incorrect table buffering settings? There are 2 correct answers
- If a buffered table is seldom changed, there is a risk of reading outdated data.
- If a buffered table is accessed too often, there is a risk that the statistics of the database optimizer will become outdated.
- If a buffered table is very large, there is a risk that other buffered tables will be swapped out because of missing free space.
- If the content of a buffered table is changed very often, the process to refill the table buffer can reduce the overall system performance.
Correct Answer(s)

A. If a buffered table is very large, there is a risk that other buffered tables will be swapped out because of missing free space.
A. If the content of a buffered table is changed very often, the process to refill the table buffer can reduce the overall system performance.

Explanation

If a buffered table is very large, there is a risk that other buffered tables will be swapped out because of missing free space. This means that if the table is taking up a lot of memory space, it may cause other tables to be removed from the buffer in order to make space for it. This can result in slower performance and increased response times for accessing those other tables.

If the content of a buffered table is changed very often, the process to refill the table buffer can reduce the overall system performance. This means that if the data in the table is frequently updated or modified, the buffer needs to be constantly refilled with the updated data. This process can be resource-intensive and can slow down the overall system performance.

Rate this question:
47.

In the transaction profile of transaction Workload Monitor (ST03n), how do you identify a poorly performing program that may be causing overall performance problems? There are 2 correct answers
- Its total response time and average response time are high.
- Its average CPU time and/or database time are high.
- Its number of steps is very low.
- Its average CPU time is greater than the average processing time.
Correct Answer(s)

A. Its total response time and average response time are high.
A. Its average CPU time and/or database time are high.

Explanation

The correct answers suggest that a poorly performing program can be identified by looking at its total response time and average response time, as well as its average CPU time and/or database time. If these metrics are high, it indicates that the program is taking longer to respond and is consuming a significant amount of CPU or database resources, which may be causing overall performance problems. The number of steps or the comparison between average CPU time and average processing time are not reliable indicators of a poorly performing program.

Rate this question:
48.

In transaction Workload Analysis Monitor (ST03n), average roll-wait time for task type DIALOG is high. Which of the following can cause this issue? There are 2 correct answers
- Not enough dialog work processes configured.
- Problems with the external RFC communication.
- SAP roll Area is too small.
- Communication problems with the GUI front end.
Correct Answer(s)

A. Problems with the external RFC communication.
A. Communication problems with the GUI front end.

Explanation

Problems with the external RFC communication can cause a high average roll-wait time for task type DIALOG in transaction Workload Analysis Monitor (ST03n). This is because if there are issues with the external RFC communication, it can lead to delays in data retrieval or processing, causing the dialog tasks to wait for longer periods of time. Similarly, communication problems with the GUI front end can also contribute to a high roll-wait time as it can result in delays or interruptions in the user interface interactions, leading to longer wait times for the dialog tasks.

Rate this question:
49.

What are some possible effects if the program buffer was made too small in configuration? There are 3 correct answers
- An increased number of work processes accessing table REPOLOAD
- Increased load and generation time in transaction ST03.
- An increased number of program buffer swaps visible in transaction ST02.
- An increased number of work processes entering PRIV mode.
- Increased GUI time caused by unbuffered objects.
Correct Answer(s)

A. An increased number of work processes accessing table REPOLOAD
A. Increased load and generation time in transaction ST03.
A. An increased number of program buffer swaps visible in transaction ST02.

Explanation

If the program buffer was made too small in configuration, it would lead to an increased number of work processes accessing table REPOLOAD. This is because the program buffer stores frequently accessed programs, and if it is too small, more work processes would need to access the table directly. Additionally, it would result in an increased load and generation time in transaction ST03, as the system would need to generate programs more frequently. Lastly, there would be an increased number of program buffer swaps visible in transaction ST02, indicating that the buffer is constantly being filled and emptied, causing performance issues.

Rate this question:

Quiz Review Timeline (Updated): Mar 15, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 15, 2023

Quiz Edited by
ProProfs Editorial Team
Jun 20, 2019

Quiz Created by
Joshua Lieghio

Trivia Quiz: SQL And SAP Advanced Business Application Program!

Which of the following is not a component of dialog response time?

Quiz Preview

A Single Statistical Record captures an entire transaction in SAP.

Which of the following transactions are used in evaluating system performance? There are 3 correct answers

Where is the default location of the statistical records that are written to the fie system?

Which of the following transactions are used to evaluate the work process statuses and activities that are currently happening? There are 2 correct answers

Which of the following are two key criteria when evaluating performance problems? There are 2 correct answers

SWAPS in transactions ST02 are an indication of high CPU utilization.

Which of the following profile parameters affect activation of dynamic work processes?

Virtual memory is made up of OS swap or page file and physical memory components.

In transaction ST02, there is a problem if there is a lot of swapping in the SAP buffers.

Which of the following parameters lead to the allocation of heap memory for dialog processes? There are 2 correct answers

The user's context is initially stored in the heap area in shared memory.

Which of the following from the Operating System Monitor (transaction ST06) indicates that there is some hardware bottleneck in the SAP system if it happens all the time? There are 2 correct answers

There is hardware bottleneck in the CPU if processing time is more than twice the CPU time.

Which of the following tools can be used to check the formulas and the values used in the formula-based memory parameters?

pHYS_MEMSIZE indicates how much memory is used in an SAP instance and it can be used to automatically initiate changes of those formula_based memory parameters.

Which of the following statements is considered to be an expensive SQL statement? There are 2 correct answers

Which of the following statements is true about the SQL Monitor? There are 3 correct answers

Which of the following SQL statements cannot be tuned? There are 3 correct answers

The ABAP trace (transaction SE30 or SAT) is the tool to use if want to find out more about the expensive SQL statements and its execution plan.

Which of the following can be found in the Explain function in SQL trace? There are 3 correct answers

Programs which show database request time >40% (response times - wait time) in the transaction profile of ST03 are potential candidates for containing expensive SQL statements.

Which of the following are valid options for table buffering types? There are 3 correct answers

Which of the following parameters controls the buffer synchronization behavior in the SAP system?

Table buffering is recommended for which of the following scenarios? There are 2 correct answers

SQL trace (transaction ST05) offers a lot of information on table accesses, which includes the database activities, number of ABAP requests, and number of invalidations.

Which of the following types of RFC calls guarantees multiple communications steps in a specific order?

What is RFC+CPIC time in synchronous RFC?

Which of the following tools is best for monitoring and analyzing issues in the transactional RFC queue?

Which of the following RFC quota parameters should be set to maintain the number of dialog work processes that should be kept free for users?

Which RFC type is used if you want to establish communication with a remote system, but don't want to wait for the result for further processing?

Which features does the SQL Monitor offer? There are 2 correct answers

What is stored in extended memory? There are 2 correct answers

In transaction Operating System Monitor (ST06) in an ABAP-only system, how can you recognise a memory bottleneck? There are 2 correct answers

What are reserved work processes?

What is the purpose of buffering data in SAP table buffers? There are 2 correct answers

With transaction Operating System Monitor (ST06) - Top 40 CPU Processes, you identified a process with unusually high CPU utilization. What are the next steps to check the root cause? There are 2 correct answers

Why is buffer synchronization important in an SAP system with more than one instance? There are 2 correct answers

How is SAP Dialog Response time defined?

How can you identify potentially expensive SQL statements in programs with transaction Local Work Process Overview (SM50)? There are 2 correct answers

What information can be retrieved with transaction Local Work Process Overview (SM50)? There are 3 correct answers

You are investigating a performance problem. In transaction Work Process Overview (SM50 or SM66) you see that many work processes stay in status 'running' with action 'read directly' and 'sequential read' for a long time. What do you do next?

Where can you find the top expensive SQL statements on the system?

In which sequence do dialog work processes allocate memory as of SAP NetWeaver 7.40?

Which of the following areas of an instance's shared memory has a corresponding file on hard disk to which SAP system will copy data that would not fit in that shared memory area?

What are some of the negative effects of incorrect table buffering settings? There are 2 correct answers

In the transaction profile of transaction Workload Monitor (ST03n), how do you identify a poorly performing program that may be causing overall performance problems? There are 2 correct answers

In transaction Workload Analysis Monitor (ST03n), average roll-wait time for task type DIALOG is high. Which of the following can cause this issue? There are 2 correct answers

What are some possible effects if the program buffer was made too small in configuration? There are 3 correct answers