Quiz: SAP Trivia Questions For Beginners!

15 Questions | Total Attempts: 846

SettingsSettingsSettings
Quiz: 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!


Questions and Answers
  • 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

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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

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

  • 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

  • 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

  • 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