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!
Wait time
Roll In/Out
Database Request
CPU idle time
True
False
ST03
SM04
SM66
SM36
/usr/sap/trans
Sapmnt/<SID>
/usr/sap/data
/usr/sap/<SID>/DVEBMGS##/data
SM50
ST06
SM66
ST02
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?
True
False
Rdisp/wp_no_dia
Rdisp/wp_no_btc
Rdisp/wp_no_enq
Rdisp/dynamic_wp_check
True
False
True
False
Em/initial_size_MB
Em/max_size_MB
Rdisp/roll_SHM
Ztta/roll_extension
True
False
High CPU utilization near 100%
High CPU idle time
High swap/paging activity
High DB time
True
False
Transaction ST02
SAP Management Console
Executable program sappfpar
Transaction RZ10
True
False
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.
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.
SQL statements used by ABAP programs
SQL statements used by SAP Basis Tables
Recursive SQL statements
SQL statements used by Database Administration Tools
True
False
Execution plan (table/index access)
Estimated costs/Estimated rows
Memory usage
Table/indexes statistics
True
False
Single record buffered
Generic area buffered
Fully buffered
Client specific buffered
Rdisp/ddlogmode
Rdisp/switch_bufmode
Rdisp/bufremode
Rdisp/auto_buf
Tables that are seldom changed.
Large tables that are often accessed.
Customizing data.
Transaction data.
Wait!
Here's an interesting quiz for you.