Functions Of Data Base SAP Query

96 Questions | Total Attempts: 65

SettingsSettingsSettings
Functions Of Data Base SAP Query

In an SAP query, we are able to generate different types of reports on computer programs. In this quiz, we look at the functions of the database in running an SAP query. How good are you? Find out below.


Questions and Answers
  • 1. 
    Select the valid customer defined Message Stement:
    • A. 

      MESSAGE Y123.

    • B. 

      MESSAGE E123 (9999).

    • C. 

      MESSAGE ID 'AT' TYPE 'S' NUMBER 100

    • D. 

      MESSAGE E123 by Fielda Fieldb

  • 2. 
    Select an example of Organizational Data
    • A. 

      Sales Order

    • B. 

      Country Keys

    • C. 

      Cost Centers

    • D. 

      Vendors

  • 3. 
    Identify the valid attributes of a domain
    • A. 

      Header

    • B. 

      Label

    • C. 

      Length

    • D. 

      Fixed Values

    • E. 

      Type

  • 4. 
    For called program components that are of type transaction or report, what is true about the roll area (assuming processing will resume in the calling program).
    • A. 

      Share the same roll area

    • B. 

      They run in their own roll area

    • C. 

      They run in the roll area of the caller

  • 5. 
    What are the main functions of the Data Dictionary.
    • A. 

      To insulate the ABAP/4 developer from the database

    • B. 

      To provide data security at the application level

    • C. 

      To connect to the operating system

    • D. 

      To support the creation and management of metadata

  • 6. 
    What is not true about SAP Query
    • A. 

      Users can access only the fields which are assigned to a functional group

    • B. 

      A user master record is generated when the query is defined

    • C. 

      SAP user can be assigned to only one user groups

    • D. 

      Functional Area can be a special view of a logical database

  • 7. 
    Programs that extend beyond transaction limits and want to pass data should use
    • A. 

      SAP Memory

    • B. 

      Tables

    • C. 

      ABAP/4 Memory

  • 8. 
    Which of the following is an invalid method for Populating an internal table
    • A. 

      Insert ITAB

    • B. 

      Append

    • C. 

      Read Table ITAB

    • D. 

      Select * into Table ITAB from dbtab

    • E. 

      Collect

  • 9. 
    Identify the clause that is used to suppress standard headers
    • A. 

      No Standard Heading

    • B. 

      No Standard Page Heading

    • C. 

      Suppress Standard

    • D. 

      System>List>Save

  • 10. 
    What appears in the standard header of a list
    • A. 

      Page Number

    • B. 

      User

    • C. 

      Program Title

    • D. 

      Date

    • E. 

      Underline

  • 11. 
    You have made changes to an existing table that contains data.  What takes place when the Database Conversion utility is executed
    • A. 

      Data in the table is automatically deleted and must be reloaded

    • B. 

      The table in the database is renamed and eventually deleted

    • C. 

      The indexes for the table needs to manually be reconstructed in the ABAP dictionary

    • D. 

      The revised table in the ABAP/4 Dictionary is activated

    • E. 

      The table in the database is recreated.

  • 12. 
    After a READ LINE on a list, what happens to the HIDE data
    • A. 

      Nothing, the data remains in the hidden area

    • B. 

      The hide data is restored to shared memory

    • C. 

      The Hide data is not available to the program

    • D. 

      It is transferred back to the fields defined in the program

  • 13. 
    Identify the object that cannot have a search help attached to it.
    • A. 

      Table

    • B. 

      Table field

    • C. 

      Type

    • D. 

      Check table

    • E. 

      Data element

  • 14. 
    Identify the different type categories in teh ABAP dictionary
    • A. 

      Table Types

    • B. 

      Data Models

    • C. 

      Structures

    • D. 

      Data Definitions

    • E. 

      Data Elements

  • 15. 
    Table ZMYTABLE is created in the dictionary.  When does the table get created in the underlying database.
    • A. 

      When the database administrator physically creates the table

    • B. 

      At the end of the table creation after it is saved

    • C. 

      When the table is activated

    • D. 

      At the beginning of the table creation

    • E. 

      It does not correspond to an object in the underlying database and does not get created

  • 16. 
    What is the order of events that fire. 10 Start-of-Selection 20 End-of-Selection 30 Initialization 40 Get 50 At Selection-Screen
    • A. 

      30 50 10 40 20

    • B. 

      50 10 40 10 20

    • C. 

      30 10 50 40 20

  • 17. 
    What are the 3 main sub objects of a LDB
    • A. 

      Search Helps

    • B. 

      DB Program

    • C. 

      Tables

    • D. 

      Structure

    • E. 

      Selection Screen

  • 18. 
    The Cardinality of a foreign key relationship is define as 1:NWhat does this imply?
    • A. 

      One record of the check table is assigned to many records of the foreign key table

    • B. 

      One record of the check table is assigned to one record of the foreign key table

    • C. 

      One record of the foreign key table is assigned to one record of the check table

  • 19. 
    In what manner can lists be saved.
    • A. 

      Local file to the application server

    • B. 

      SAPOFFICE

    • C. 

      HTML Format on local PC

    • D. 

      ABAP Editor

    • E. 

      Report Tree

  • 20. 
    Identify the valid methods for setting the value of a select-options selection field.
    • A. 

      SELECT-OPTIONS AIRLINE FOR ZFLIGHTS-CARRID MEMORY ID CAR

  • 21. 
    When does the processing block for a GET statement end.
    • A. 

      When the END GET statement is encountered

    • B. 

      When the next keyword event is encountered

    • C. 

      When all data has been retrieved for the GET

    • D. 

      After each PUT in the LDB

  • 22. 
    What is true about the result set of an left outer join at the database level
    • A. 

      Contains all entries from teh left table

    • B. 

      Contains only entries that match in the ON clause

    • C. 

      Fields from unmatched rows in the right table are null filled

    • D. 

      Fields from unmatched rows in the left table are null filled

    • E. 

      Contains all entries from the right table

  • 23. 
    What is required to establish an interactive list.
    • A. 

      The user interface allows actions to trigger interactive list type events

    • B. 

      Corresponding interactive enents are programmed

    • C. 

      The HIDE command is programmed in the report.

  • 24. 
    Assuming a Detail list exists, what takes place when sy-lsind is set to zero.
    • A. 

      All secondary lists are deleted

    • B. 

      The basic and secondary lists are deleted

    • C. 

      The basic list is overwritten with the current secondary list

    • D. 

      The original basic list is re-displayed

  • 25. 
    Which is not a valid option of the Write Statement
    • A. 

      Input

    • B. 

      NO-GAP

    • C. 

      NO-ZERO

    • D. 

      As RadioBox

    • E. 

      Centered

Related Topics
Back to Top Back to top