Week2

35 Questions | Total Attempts: 110

SettingsSettingsSettings
Reasoning Quizzes & Trivia

This is a mock up exam covering week2 of the course. This test no way should be associated with the real exam, it just give you a feeler and gauge your current knowledge. Passing this test no way guarantees that you will pass the actual exam you still need to read the books and study more till the examBest of LuckSN


Questions and Answers
  • 1. 
    Which of the following statements about field transport from ABAP to screen are correct(more than 1 correct answers)
    • A. 

      Field transport from screen to ABAP is delayed if you have a FIELD statement

    • B. 

      Name equivalence is imperative for field transport between ABAP and screen

    • C. 

      Field transport from ABAP to screen generally takes place before the first PBO module of the screen

    • D. 

      For the screen fields from Dictionary tables or structures you need to create data object in ABAP using TABLES keyword

  • 2. 
    Which of the following statements are true about push buttons(More than 1 correct answer)
    • A. 

      With Function Code 'E' causes program termination

    • B. 

      On a screen always have a corresponding function key

    • C. 

      In application toolbar always have corresponding function key

    • D. 

      In application toolbar always have function code

  • 3. 
    Which of the following syntax are correct for open SQL statement Select (More than 1 correct answer)Assuming that transparent table tab exists in ABAP dictionary and following declarations are done in the program alreadydata: wa type tab.data: it_tab type standard table of tab.
    • A. 

      Select single * into wa from tab. ………. EndSelect.

    • B. 

      Select * from tab into it_tab.

    • C. 

      Select * from tab into corresponding fields of wa. ......... EndSelect.

    • D. 

      Select * from tab into table it_tab.

    • E. 

      Select single * into corresponding fields of wa from tab

  • 4. 
    If the following Open SQL select statement gives only one row as the output what could be possible reasons.Select * from tab into wa where col = pa_col. write: wa-col1, wa-col2, wa-col3.EndSelect.(More than 1 correct answer)
    • A. 

      Select statement retrieves only one row from database

    • B. 

      Select statement syntax is wrong, Select single should have been used

    • C. 

      New line statement should be added to the write

    • D. 

      In the where clause in operator should be used instead of =.

  • 5. 
    Authorization concept in SAP System is used for (More than 1 correct answer)
    • A. 

      SAP System uses this Authorization concept for individual Database to provide access security.

    • B. 

      Each application in SAP System is protected by Authorization.

    • C. 

      Using Authorization critical data and parts of functional scope of the SAP system can be protected from unauthorized access

    • D. 

      Authorizations are combined into profiles

  • 6. 
    Evaluate the following code snippetdata: it_sflight type table of sflight.Authority-Check Object 'S_CARRID'                             ID        'CARRID' field 'AA'                             ID        'ACTVT' field '03'.select * from sflight into table it_sflight where carrid = 'AA'.Assuming there is no syntax error, which of the following would be valid
    • A. 

      If the user running the program does not have display access on 'AA' as defined in his profile, internal table it_sflight would be empty

    • B. 

      If the user running the program does not have display access on 'AA' as defined in his profile, internal table it_sflight still would contain all records of carrier 'AA'

    • C. 

      If the user running the report has 01,02, and 03 access to AA in his profile, then only the rows be fetched into the internal table

  • 7. 
    Which of the following statements about indexes are correct (More than 1 correct answer)
    • A. 

      A database table can have more than one index.

    • B. 

      A primary index consists of the primary key fields of the database table.

    • C. 

      An Index can be assigned to several tables.

    • D. 

      Using indexes speed up the data retrieval from table

    • E. 

      Using Indexes speeds up the transaction process for the table.

  • 8. 
    Evaluate the following code snippetdata: wa_spfli type spfli.select-options : so_carr for wa_spfli-connid.select * from spfli into wa_spfli where carrid in so_carr.write:/ wa_spfli-carrid, wa_spfli-connid.endselect.When you run the above report, assuming that user do not key in any values in selection screen .Which of the following statement are true in this condition
    • A. 

      All the records from spfli will be displayed in the list

    • B. 

      No rows will be displayed as user haven't entered the value in selection screen

    • C. 

      Instead of IN operator in where clause, if = operator is used it will display only one row

  • 9. 
    In which of the following events, would you ideally write the validation code for the data entered in the selection screen by the user
    • A. 

      PAI

    • B. 

      AT SELECTION-SCREEN OUTPUT

    • C. 

      AT SELECTION-SCREEN INPUT

    • D. 

      AT SELECTION-SCREEN

    • E. 

      AT SELECTION-SCREEN ON REQUEST

  • 10. 
    If you create a variant for a report program(zrep) , and name the variant as zvar00. When you transport the report (zrep) will the variant (zvar00) also automatically transported
    • A. 

      Yes

    • B. 

      No

  • 11. 
    In Program ZPROG , the submit statement is used to call a report ZREP , how can you pass the data from ZPROG to ZREP?(more than 1 correct answer)
    • A. 

      By declaring same name data object in ZPROG and ZREP, as the name is same value gets automatically copied.

    • B. 

      Using ABAP memory

    • C. 

      By passing parameters using additions in submit statement e,g submit zrep with

    • D. 

      Using SET/GET parameter ID

  • 12. 
    Which of the following statements are true(more than 1 correct answer)
    • A. 

      A key field in database table uniquely identifies the data record

    • B. 

      A secondary index for non key fields generally works like a primary index of key fields

    • C. 

      The client field is selective field and should always be specified in WHERE condition of SELECT statement

    • D. 

      You can select from several tables using database view or joins in your program

    • E. 

      OPEN SQL statement are converted into database specific statements by the database interface

  • 13. 
    Which statement at the time of AT SELECTION-SCREEN causes the selection screen to be displayed again and fields ready to input and message in the status line?
    • A. 

      A MESSAGE I ... statement

    • B. 

      An AUTHORITY-CHECK statement which returns sy-subrc NE 0

    • C. 

      A MESSAGE E .... statement.

  • 14. 
    Which of the following statements about SELECT statement are correct?(More than 1 correct answer)
    • A. 

      With SELECT .... ENDSELECT access,at any particular time you have one data record maximum.

    • B. 

      With SELECT .... INTO TABLE access, the result is 1 data record maximum.

    • C. 

      With SELECT SINGLE * access, the result is 1 data record maximum

    • D. 

      SELECT statement will always load data into SAP memory

    • E. 

      SELECT statement supports the return code (sy-subrc)

  • 15. 
    Which of the following calls will return the control back to the calling program (More than 1 correct answer)
    • A. 

      Call Transaction

    • B. 

      Leave Transaction

    • C. 

      Submit

    • D. 

      Submit ... and return

  • 16. 
    • A. 

      ABAP debugger

    • B. 

      SQL TRACE

    • C. 

      Code Inspector

    • D. 

      Not possible, as the tools are only available for BASIS administrators

  • 17. 
    To interrupt the processing of the current screen and branch to new screen, or sequence of screen, you can use which of the following statements(Only 1 correct answer)
    • A. 

      CALL SCREEN

    • B. 

      SET SCREEN

    • C. 

      LEAVE SCREEN .

    • D. 

      LEAVE TO SCREEN

  • 18. 
    Which conditions must be fulfilled in a programmed check so that s screen input field is made ready for input again ?(More than 1 correct answer)
    • A. 

      The module must output an E type message or W message

    • B. 

      The check module must be calling using : FIELD fileldname MODULE check_module

    • C. 

      The check module must be calling using : FIELD fileldname MODULE check_module message Exxx

    • D. 

      An I type message must be output

  • 19. 
    Does a PAI occur when you switch between tab pages whose titles have function type 'P' in a tabstrip
    • A. 

      No

    • B. 

      Yes, if at least one PAI module exist in subscreen container

    • C. 

      Yes, if at least one required entry field exists on one of the tab pages

    • D. 

      Yes always

  • 20. 
    You have defined a screen with required entries. You want the "CANCEL" function to work even if all the required entry field are not filled. How can you do this?
    • A. 

      There is no way to do this; required entry fields must always be filled first

    • B. 

      No special actions are required.

    • C. 

      The "CANCEL" function must have function code "BACK"

    • D. 

      The "CANCEL" function must be type "E" and be handled in a module with AT EXIT-COMMAND.

    • E. 

      You must temporarily switch of the required entry of the field within LOOP at SCREEN.. ENDLOOP.

  • 21. 
    Which of the following are valid screen flow logic statements if you want the module to be executed when a single field content are not equal to initial value
    • A. 

      Module first AT EXIT-COMMAND

    • B. 

      Field fname Module first ON INPUT

    • C. 

      CHAIN. FIELDS: fnames Module first on CHAIN-REQUEST ENDCHAIN.

    • D. 

      Field fname Module first ON REQUEST.

  • 22. 
    In the PAI of screen 100 following flow logic statements are written, assuming you have 4 fields in the screen named f1,f2,f3 and f4Module setStatus.Field f1 module pai_f1_100.Field f3 module pai_f3_100.Module pai_4_100.When module setStatus is executed which of the following fields are already transported to ABAP.
    • A. 

      F1

    • B. 

      F2

    • C. 

      F3

    • D. 

      F4

  • 23. 
    • A. 

      Statement LEAVE TO SCREEN is not allowed in Subscreens PBO/PAI

    • B. 

      You can call subscreen using screen command CALL SUBSCREEN

    • C. 

      You can call subscreen using ABAP command CALL SUBSCREEN

    • D. 

      Subscreens have their own OK CODE field

  • 24. 
    What do you get when you refer to client specific transparent table in the ABAP Dictionary , if you have data definition with DATA?
    • A. 

      An Internal table

    • B. 

      A Field

    • C. 

      An Object

    • D. 

      Structured Work Area (line)

  • 25. 
    Which of the following are true about Generic Buffering. (More than 1 correct answer)
    • A. 

      Generic Buffering is always done using generic keys

    • B. 

      Generic keys can be any columns of the table

    • C. 

      All fully buffered client dependent tables are generically buffered on mandt

    • D. 

      All Fully buffered tables are generically buffered by primary key.

    • E. 

      Generic keys for Generic buffering should be less than number of Primary Keys

    • F. 

      If you have client independent table with one column as primary key, it is not possible to do generic buffering on such tables

  • 26. 
    If Primary Key of a table is also a Foreign key to another table which of the following is the Foreign Keys characteristics
    • A. 

      Key Fields of text table

    • B. 

      Key Fields of Primary Table

    • C. 

      Key Fields/Candidates

    • D. 

      No Key Fields/Candidates

  • 27. 
    Which of the following assertions are right. (More than 1 correct answer)
    • A. 

      Field of the foreign key table to be checked is called Check field.

    • B. 

      Field of the Primary Key Table is called check field.

    • C. 

      For Check field and referenced key field Data Element should be exactly same.

    • D. 

      For Check field and referenced key field Data Element can be different but domain should be exactly same.

  • 28. 
    Changes to Active transparent table : the type for the non key field is to be changed from NUMC to CHAR. What follow up actions are to be expected?(more than 1 correct answer)
    • A. 

      If the table already contains data, this changes need to be executed first in the database by the database administrator, afterwards you can reactivate your table in ABAP dictionary

    • B. 

      Type changes in Dictionary are only supported for key fields only, in case of non key fields such changes has to be done manually in database by the database administrator

    • C. 

      If the table already contain data, SAP either make such changes using ALTER TABLE or using the conversion process

    • D. 

      If the table does not contain any data, SAP drops and recreates the table with new definition

  • 29. 
    In which of the following types there is an one-to-one relationship between the table defined in ABAP dictionary and the relevant physical table in database
    • A. 

      Structure

    • B. 

      Cluster table

    • C. 

      Pool table

    • D. 

      Transparent table

  • 30. 
    If you have created a Type Group named Z01 in abap dictionary and if in this type group you need to define a constant called pi, such constants declared in type group should be defined  ____________ to adhere to the naming conventions of type group.
  • 31. 
    Which of the following view supports left outer join?(more than 1 correct answer)
    • A. 

      Database View

    • B. 

      Projection View

    • C. 

      Maintainence View

    • D. 

      Help View

    • E. 

      Outer Join View

  • 32. 
    For Search Help you should have
    • A. 

      Atleast one import parameter

    • B. 

      Atleast one export parameter

    • C. 

      One import and one export parameter minimum

    • D. 

      Both import and export parameters are optional

  • 33. 
    Is it possible to increase number of key fields in the transparent table that is active?
    • A. 

      Yes, however the table must be empty

    • B. 

      Yes, irrespective of whether table has data or not

    • C. 

      No, key changes are not allowed once activated

  • 34. 
    Which of the following one are correct sequence mechanism for determining the input Help or search help?
    • A. 

      Search Help for Field, Check Table, Search Help for Dataelement

    • B. 

      Search Help for Field, Check Table, Fixed Values

    • C. 

      Process on Value-Request,Domain Fixed Value, check table

    • D. 

      Check Table, Search help for Field, Search Help for Dataelement, Fixed Values

  • 35. 
    If a Table called as CUSTOMER which has data in the DB , has been changed in the ABAP DICTIONARY and activated which has resulted in conversion process, during the conversion process in one of the steps before data is transported , SAP creates the table with the new changed information in db as ______________