SAP Trivia Questions For Beginners!
This quiz is an SAP Trivia Questions for Beginners. There is a lot of application software that businesses can use to have a connection with their customers, and SAP is one that is gaining popularity so fare. Do give it a shot and get to review all that you have learned so far. All the best, and keep a lookout for other quizzes!
- 1.
On which information does the data access strategy used for exe__ statement depend on? 2 answers
- A.
The fields specified in the WHERE clause of the SQL statement
- B.
The availability of indexes for the queried tables.
- C.
How often an SQL statement is executed
- D.
The number of database records that will be retrieved
Correct Answer(s)
A. The fields specified in the WHERE clause of the SQL statement
B. The availability of indexes for the queried tables.Explanation
The data access strategy used for an SQL statement depends on the fields specified in the WHERE clause of the statement and the availability of indexes for the queried tables. The WHERE clause determines which records need to be retrieved, and the indexes help in optimizing the retrieval process by providing a quick lookup mechanism. Therefore, these two factors play a crucial role in determining the data access strategy for an SQL statement.Rate this question:
-
- 2.
What are some of the reasons for using the extended memory co___ systems? 3 Correct answers.
- A.
Without extended memory, a release of allocated memory in the OS paging file would not be possible.
- B.
The large size of extended memory avoids context switches where possible.
- C.
Fast context switches are needed in SAP systems because many users share few work processes
- D.
SAP transactions usually consist of more than one step or screen
- E.
Extended memory is accessed through pointers; therefore, fast context switches are possible.
Correct Answer(s)
C. Fast context switches are needed in SAP systems because many users share few work processes
D. SAP transactions usually consist of more than one step or screen
E. Extended memory is accessed through pointers; therefore, fast context switches are possible.Explanation
The reasons for using extended memory in the given question are that fast context switches are needed in SAP systems because many users share few work processes, SAP transactions usually consist of more than one step or screen, and extended memory is accessed through pointers, allowing for fast context switches.Rate this question:
-
- 3.
Which elements of total response time should be under 20ms? 2 Correct answers.
- A.
Roll-in time.
- B.
Wait time
- C.
Processing Time
- D.
Database request time
Correct Answer(s)
A. Roll-in time.
B. Wait timeExplanation
The elements of total response time that should be under 20ms are roll-in time and wait time. Roll-in time refers to the time it takes for a process or task to be fully integrated and operational, and wait time refers to the time a user has to wait for a response or action to be completed. Keeping these two elements under 20ms ensures that the overall response time is fast and efficient for users.Rate this question:
-
- 4.
Which of the following reports or transactions can be used to monitor memory consumption? 2 Correct answers
- A.
Report RSMEMORY
- B.
Transaction ST02
- C.
Transaction SM50
- D.
Transaction DBACOCKPIT
Correct Answer(s)
A. Report RSMEMORY
B. Transaction ST02Explanation
The correct answer is Report RSMEMORY and Transaction ST02. The RSMEMORY report can be used to monitor memory consumption in SAP systems. It provides information on various memory areas such as shared memory, heap memory, and extended memory. Transaction ST02, on the other hand, allows monitoring of buffer and memory usage in the SAP system. It provides detailed information on buffer areas, memory usage, and cache hits. Both of these reports and transactions are useful for monitoring memory consumption in SAP systems.Rate this question:
-
- 5.
Which option represents "Generic area buffered"?
- A.
During the first access to a table, all table content is copied to the table buffer on the SAP instance
- B.
You set some of key fields for a table to determine the data to be buffered during access
- C.
Each individual record accessed is buffered on the SAP instance
- D.
You set all key fields of a table to specify which records are buffered on the SAP instance
Correct Answer
B. You set some of key fields for a table to determine the data to be buffered during access -
- 6.
How can expensive SQL statements cause poor performance of o___. 3 Correct Answers
- A.
By displacing many blocks from the database buffer that must be replaced by other processes
- B.
By causing other processes to wait for the database and / or work processes which are busy
- C.
By creating a hardware bottleneck on the database server, causing poor database performance for all processes that use the database
- D.
By displacing many blocks from the SAP buffers (Program, CUA or screen) that must be refilled by other processes
- E.
By causing missing optimizer statistics that cause other processes choose incorrect access paths for SQL
Correct Answer(s)
A. By displacing many blocks from the database buffer that must be replaced by other processes
B. By causing other processes to wait for the database and / or work processes which are busy
C. By creating a hardware bottleneck on the database server, causing poor database performance for all processes that use the databaseExplanation
Expensive SQL statements can cause poor performance because they can displace many blocks from the database buffer, which then need to be replaced by other processes. This can lead to delays and increased wait time for other processes that are trying to access the database. Additionally, these statements can create a hardware bottleneck on the database server, resulting in poor performance for all processes that rely on the database.Rate this question:
-
- 7.
You are reviewing RFC data in the transaction Workload Monitor _____ profile provides information about function modules in other systems ____ from this system?
- A.
RFC client profile
- B.
RFC server profile
- C.
RFC client-destination profile
- D.
RFC server-destination profile
Correct Answer
A. RFC client profileExplanation
The RFC client profile provides information about function modules in other systems that are called from this system.Rate this question:
-
- 8.
Which of the following SQL statement types always bypass the SAP ____? 3 Correct answers
- A.
Native SQL statements
- B.
Select Distinct statements
- C.
Select for Update statements
- D.
Open SQL statements
- E.
Select Single statements
Correct Answer(s)
A. Native SQL statements
B. Select Distinct statements
C. Select for Update statementsExplanation
The given correct answer is Native SQL statements, Select Distinct statements, and Select for Update statements. These statement types always bypass the SAP ____. This means that these statements are not processed by the SAP system and are executed directly at the database level. Native SQL statements allow direct interaction with the database using specific database syntax. Select Distinct statements retrieve unique values from a column in a table. Select for Update statements lock the selected rows in a table for update or delete operations. Open SQL statements and Select Single statements do not always bypass the SAP ____.Rate this question:
-
- 9.
What data is available in transaction Buffer Monitor (ST02)? 2 Correct answers
- A.
Status information of buffers of the SAP instance
- B.
Information on the memory usage of the SAP instance
- C.
Information on operating system level paging / swapping
- D.
Status information of buffers of the SAP system
Correct Answer(s)
A. Status information of buffers of the SAP instance
B. Information on the memory usage of the SAP instanceExplanation
The transaction Buffer Monitor (ST02) provides status information about the buffers of the SAP instance, including details on their usage and performance. It also provides information on the memory usage of the SAP instance, helping administrators monitor and optimize memory usage.Rate this question:
-
- 10.
In transaction Work Process Overview (SM50/SM66) you see that ____ processes are in 'PRIV' mode. What should you do to identify the ____? 2 Correct answers
- A.
Check the extended memory usage in the transaction Tune Summary Monitor (ST02) and extended memory configuration
- B.
Check if all work processes in PRIV mode are using the same transaction or report and investigate it further if they are
- C.
Check the 'Top 40 CPU Processes' in transaction Operating System Monitor (ST06(n)) and investigate the top processes
- D.
Perform a detailed analysis of the database
Correct Answer(s)
A. Check the extended memory usage in the transaction Tune Summary Monitor (ST02) and extended memory configuration
B. Check if all work processes in PRIV mode are using the same transaction or report and investigate it further if they areExplanation
To identify the processes that are in 'PRIV' mode, you should first check the extended memory usage and configuration in the transaction Tune Summary Monitor (ST02). This will help determine if there is any issue with the extended memory that may be causing the processes to be in 'PRIV' mode. Additionally, you should also check if all the work processes in 'PRIV' mode are using the same transaction or report. If they are, further investigation is needed to identify any potential issues with that specific transaction or report.Rate this question:
-
- 11.
The function "Execute Explain for SQL Statements" compromises ______. What details can you get from this plan? 2 Correct answers
- A.
Estimated costs
- B.
Estimated rows
- C.
Estimated response time
- D.
Estimated CPU cost
Correct Answer(s)
A. Estimated costs
B. Estimated rowsExplanation
The function "Execute Explain for SQL Statements" compromises the estimated costs and estimated rows. This means that it provides information about the expected expenses and the number of rows that will be affected by the SQL statements. It does not provide information about the estimated response time or estimated CPU cost.Rate this question:
-
- 12.
You suspect that there is an issue with the network connection from the application layer to the presentation layer. Which check do you perform in which transaction?
- A.
LAN check by ping in transaction Operating System Monitor (ST06(n))
- B.
Connection test in Work Process Overview (SM5O/SM66)
- C.
Trace, in transaction Single Transaction Analysis (ST12).
- D.
Check Cursor Cache in transaction DBA Cockpit (DBACOCKPIT)
Correct Answer
A. LAN check by ping in transaction Operating System Monitor (ST06(n)) -
- 13.
What percentage is considered a potential resource bottleneck for the CPU?
- A.
Below 20% Idle
- B.
Below 10% Idle
- C.
Above 80% Idle
- D.
Above 90% Idle
Correct Answer
A. Below 20% IdleExplanation
A percentage below 20% idle is considered a potential resource bottleneck for the CPU. This means that if the CPU is consistently utilizing more than 80% of its resources, it may struggle to handle additional tasks efficiently. This can result in slower performance, lag, and potential system crashes. Therefore, it is important to monitor CPU usage and ensure it remains below 20% idle to maintain optimal performance.Rate this question:
-
- 14.
What is the SAP Operating System Collector (SAPOSCOL)?
- A.
An SAP proprietary standalone program for collecting Operating System usage information
- B.
An alternative to transaction Operating System Monitor (ST06(n)) for non-ABAP systems
- C.
The built-in tool in ABAP systems for collecting Operating System usage information
- D.
A third party tool for collecting Operating System usage information
Correct Answer
A. An SAP proprietary standalone program for collecting Operating System usage informationExplanation
The correct answer is "An SAP proprietary standalone program for collecting Operating System usage information." SAPOSCOL is a program developed by SAP that is used to collect information about the usage of the operating system. It is a standalone program, meaning it can be run independently from other SAP applications. This program is specifically designed for collecting operating system usage information and is not an alternative to the Operating System Monitor for non-ABAP systems or a third-party tool.Rate this question:
-
- 15.
Which of the following statements bypass the buffer?
- A.
SELECT ... BYPASSING BUFFER
- B.
SELECT FOR UPDATE
- C.
SELECT BY DISTINCT
- D.
ORDER BY (other than the primary key)
- E.
Any aggregate function (COUNT, MIN, MAX, SUM, AVG), for example SELECT MIN(F1) FROM T1 WHERE...
- F.
WHERE clause contains IS NULL
- G.
All native SQL statements
Correct Answer(s)
A. SELECT ... BYPASSING BUFFER
B. SELECT FOR UPDATE
C. SELECT BY DISTINCT
D. ORDER BY (other than the primary key)
E. Any aggregate function (COUNT, MIN, MAX, SUM, AVG), for example SELECT MIN(F1) FROM T1 WHERE...
F. WHERE clause contains IS NULL
G. All native SQL statementsExplanation
All of the given statements bypass the buffer.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Nov 16, 2023Quiz Edited by
ProProfs Editorial Team -
Sep 09, 2019Quiz Created by
Catherine Halcomb
Back to top