Trivia Quiz: SQL And SAP Advanced Business Application Program!

52 Questions | Total Attempts: 368

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.

Back to Top Back to top