Trivia Quiz: SQL And SAP Advanced Business Application Program!

52 Questions | Total Attempts: 273

SettingsSettingsSettings
Please wait...
Trivia Quiz: SQL And SAP Advanced Business Application Program!

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!


Questions and Answers
  • 1. 
    Which of the following is not a component of dialog response time? 
    • A. 

      Wait time

    • B. 

      Roll In/Out

    • C. 

      Database Request

    • D. 

      CPU idle time

  • 2. 
    A Single Statistical Record captures an entire transaction in SAP.
    • A. 

      True

    • B. 

      False

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

      ST03

    • B. 

      SM04

    • C. 

      SM66

    • D. 

      SM36

  • 4. 
    Where is the default location of the statistical records that are written to the fie system?
    • A. 

      /usr/sap/trans

    • B. 

      Sapmnt/<SID>

    • C. 

      /usr/sap/data

    • D. 

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

  • 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
    • A. 

      SM50

    • B. 

      ST06

    • C. 

      SM66

    • D. 

      ST02

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

      Did the performance problem occur in the past?

    • B. 

      Which user is experiencing the problem?

    • C. 

      Is the problem happening right now?

    • D. 

      How close is it to quitting time?

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

      True

    • B. 

      False

  • 8. 
    Which of the following profile parameters affect activation of dynamic work processes?
    • A. 

      Rdisp/wp_no_dia

    • B. 

      Rdisp/wp_no_btc

    • C. 

      Rdisp/wp_no_enq

    • D. 

      Rdisp/dynamic_wp_check

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

      True

    • B. 

      False

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

      True

    • B. 

      False

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

      Em/initial_size_MB

    • B. 

      Em/max_size_MB

    • C. 

      Rdisp/roll_SHM

    • D. 

      Ztta/roll_extension

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

      True

    • B. 

      False

  • 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
    • A. 

      High CPU utilization near 100%

    • B. 

      High CPU idle time

    • C. 

      High swap/paging activity

    • D. 

      High DB time

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

      True

    • B. 

      False

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

      Transaction ST02

    • B. 

      SAP Management Console

    • C. 

      Executable program sappfpar

    • D. 

      Transaction RZ10

  • 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.
    • A. 

      True

    • B. 

      False

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

      SQL statement which requires many records to be transferred to the ABAP program.

    • B. 

      SQL statement which uses index during data retrieval.

    • C. 

      SQL statement which reads many blocks but retrieves only a few records from the database. 

    • D. 

      SQL statement which uses table buffering.

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

      SQL Monitor can be switched on for all or dedicated servers.

    • B. 

      SQL Monitor is designed to trace a single process.

    • C. 

      SQL Monitor can trace every SQL statement coming from ABAP programs, which include all OPEN SQL, native SQL, and ABAP kernel SQL statements.

    • D. 

      SQL Monitor has low impact on the performance of the production system.

  • 19. 
    Which of the following SQL statements cannot be tuned? There are 3 correct answers
    • A. 

      SQL statements used by ABAP programs

    • B. 

      SQL statements used by SAP Basis Tables

    • C. 

      Recursive SQL statements

    • D. 

      SQL statements used by Database Administration Tools

  • 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.
    • A. 

      True

    • B. 

      False

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

      Execution plan (table/index access)

    • B. 

      Estimated costs/Estimated rows

    • C. 

      Memory usage

    • D. 

      Table/indexes statistics

  • 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.
    • A. 

      True

    • B. 

      False

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

      Single record buffered

    • B. 

      Generic area buffered

    • C. 

      Fully buffered

    • D. 

      Client specific buffered

  • 24. 
    Which of the following parameters controls the buffer synchronization behavior in the SAP system?
    • A. 

      Rdisp/ddlogmode

    • B. 

      Rdisp/switch_bufmode

    • C. 

      Rdisp/bufremode

    • D. 

      Rdisp/auto_buf

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

      Tables that are seldom changed. 

    • B. 

      Large tables that are often accessed.

    • C. 

      Customizing data.

    • D. 

      Transaction data.

  • 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.
    • A. 

      True

    • B. 

      False

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

      Asynchronous RFC

    • B. 

      Transactional RFC

    • C. 

      Queued RFC

    • D. 

      Synchronous RFC

  • 28. 
    What is RFC+CPIC time in synchronous RFC?
    • A. 

      Time needed to establish the RFC communications to the RFC server.

    • B. 

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

    • C. 

      Roll wait time caused by RFC communication.

    • D. 

      GUI time.

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

      SM58

    • B. 

      SMQ1

    • C. 

      SMQ2

    • D. 

      ST05

  • 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?
    • A. 

      Rdisp/rfc_max_own_wp

    • B. 

      Rdisp/rfc_min_wait_dia_wp

    • C. 

      Rdisp/rfc_max_own_login

    • D. 

      Rdisp/rfc_max_comm_entries

  • 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?
    • A. 

      Synchronous RFC (sRFC)

    • B. 

      Asynchronous RFC (aRFC)

    • C. 

      Transactional RFC (tRFC)

    • D. 

      Background RFC (bgRFC)

  • 32. 
    Which features does the SQL Monitor offer? There are 2 correct answers
    • A. 

      It can be switched on for all or dedicated servers of an ABAP system.

    • B. 

      It can be optimized expensive SQL statements automatically.

    • C. 

      It can trace each and every SQL statement coming from an ABAP program.

    • D. 

      It can trace the SQL execution of selected ABAP work processes.

  • 33. 
    What is stored in extended memory? There are 2 correct answers
    • A. 

      User context data.

    • B. 

      Buffered programs and tables.

    • C. 

      Objects associated with individual users and their open transactions.

    • D. 

      Application program data that correspond to specific ABAP commands, such as "export to memory".

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

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

    • B. 

      In a Windows system, more than 25% of RAM paged in per hour. 

    • C. 

      In Unix system, more than 20% of RAM paged in/swapped in per hour. 

    • D. 

      In a Windows system, more than 20% of RAM pages out per hour.

  • 35. 
    What are reserved work processes?
    • A. 

      Work processes that are started in certain situations and are stopped again when no longer needed. 

    • B. 

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

    • C. 

      Work processes used to communicate with printers.

    • D. 

      Work processes used to perform non-urgent changes to a database.

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

      To creating better access paths to data.

    • B. 

      To speed up access to data.

    • C. 

      To save space on the hard disk.

    • D. 

      To reduce load on the database.

  • 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
    • 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. 

    • B. 

      If this process leaves 10% or less overall CPU idle time, there is no need for further action because there is still headroom.

    • C. 

      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.

    • D. 

      If it is the SAP gateway process, you might check if update processing can be moved to another instance.

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

      To prevent outdated data from being selected from buffers.

    • B. 

      To prevent outdated data being committed to the database.

    • C. 

      To improve performance. 

    • D. 

      To reduce the load on the database.

  • 39. 
    How is SAP Dialog Response time defined?
    • A. 

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

    • B. 

      As the time span between the browser sends a request to the back-end till he completely rendered the response

    • C. 

      As the time span between the roll-in and the roll-out of a work process is once completed.

    • D. 

      As the time span between an ABAP request is being loaded into the program buffer till the request processing is finished.

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

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

    • B. 

      The executing work process has a long-running action with "PRIV".

    • C. 

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

    • D. 

      The executing work process has a long-running action with "semaphore".

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

      Work process utilization data of all instances of an SAP system.

    • B. 

      Automatically refreshed information on local work process utilization.

    • C. 

      The status of an individual work process, for example, waiting, running, on hold, etc.

    • D. 

      The process ID of the work process.

    • E. 

      The program that is currently executed by the work process.

  • 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?
    • A. 

      Analyze the database.

    • B. 

      Analyze the SAP memory configuration.

    • C. 

      Perform a LAN Check by Ping.

    • D. 

      Check the 'Top 40 CPU Processes' in transaction Operating System Monitor (ST06(n))

  • 43. 
    Where can you find the top expensive SQL statements on the system?
    • A. 

      In the cursor cache of the DBS Cockpit.

    • B. 

      In the transaction Operating System Monitor (ST06(n)).

    • C. 

      In transaction SQL trace (ST05 or ST12).

    • D. 

      In transaction Work Process Overview (SM50 and SM66).

  • 44. 
    In which sequence do dialog work processes allocate memory as of SAP NetWeaver 7.40?
    • A. 

      Extended memory, Heap memory

    • B. 

      Heap memory, Extended memory

    • C. 

      Local memory, Extended memory, Heap memory

    • D. 

      Heap memory, Extended memory, PRIV memory

  • 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?
    • A. 

      PROC buffer.

    • B. 

      Paging buffer.

    • C. 

      SAP buffer (programs, tables, and so on).

    • D. 

      Extended memory (user contexts).

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

      If a buffered table is seldom changed, there is a risk of reading outdated data.

    • B. 

      If a buffered table is accessed too often, there is a risk that the statistics of the database optimizer will become outdated.

    • C. 

      If a buffered table is very large, there is a risk that other buffered tables will be swapped out because of missing free space.

    • D. 

      If the content of a buffered table is changed very often, the process to refill the table buffer can reduce the overall system performance.

  • 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
    • A. 

      Its total response time and average response time are high.

    • B. 

      Its average CPU time and/or database time are high.

    • C. 

      Its number of steps is very low.

    • D. 

      Its average CPU time is greater than the average processing time.

  • 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
    • A. 

      Not enough dialog work processes configured.

    • B. 

      Problems with the external RFC communication. 

    • C. 

      SAP roll Area is too small.

    • D. 

      Communication problems with the GUI front end.

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

      An increased number of work processes accessing table REPOLOAD

    • B. 

      Increased load and generation time in transaction ST03.

    • C. 

      An increased number of program buffer swaps visible in transaction ST02.

    • D. 

      An increased number of work processes entering PRIV mode.

    • E. 

      Increased GUI time caused by unbuffered objects.

  • 50. 
    How can SAP shared memory be accessed?
    • A. 

      Shared memory is only accessible on operating system level.

    • B. 

      Shared memory is accessible by all processes across all instances.

    • C. 

      Shared memory is accessible only by dialog work processes of one instance.

    • D. 

      Shared memory is accessible by all processes of one instance.

  • 51. 
    The function "Execute Explain for SQL Statements" comprises an execution plan. What details can you get from this plan? There are 3 correct answers
    • A. 

      Estimated costs.

    • B. 

      Estimated rows.

    • C. 

      Estimated response time.

    • D. 

      Estimated CPU cost.

  • 52. 
    When you run transaction Table Call Statistics (ST10), which of the following indicates that a table should be unbuffered? There are 3 correct answers
    • A. 

      Tables with a high number of invalidations.

    • B. 

      Tables with a high number of 'Rows affected'.

    • C. 

      Tables with a large buffer size.

    • D. 

      Tables with buffer state 'pending'.

    • E. 

      Tables with more direct reads than sequential reads.