-->

Thursday, October 26, 2023

SAP ABAP CERTIFICATION MCQs PART 2


ABAP CERTIFICATION Multiple Choice Questions

The following are true about database locking.

For this question there are 2 correct options.

1.         Database systems set physical locks on all lines affected by a database call. True
2.         Read locks prevent the setting of further read locks for the objects in question. False
3.         Read locks prevent other transactions from setting write locks for the objects in question. True
4.         Write locks allow other transactions to set read locks for the objects in question. False


What are field symbols? 

For this question there are 2 correct options.

1.         Field symbols are like pointers in C that can point to any data object in ABAP/4 and to structures defined in ABAP/4 dictionary.True
2.         Field symbols have to be created with type specifications only.False
3.         You cannot assign one field symbol to another. False
4.         All operations you have programmed with the field symbol are carried out with the assigned field. True


You want to modify an SAP program. What do you need to watch out for?

For this question there are 3 correct options.

1)       If SAP delivers a new version of an object, the modified object must be adjusted if you upgrade or import a Support Package.False
2)       The SAP system does not allow modifications by user DDIC or SAP*. True

3)       Before you can change the program, you must request a key for the object. False
4)       You can use the Modification Assistant to change application programs delivered by SAP, without the need for registration.True
5)       You can perform the modification immediately if you set the global setting for the system change option to “Modifiable”. True

Which of the following ABAP statements create a list for executable programs?

For this question there are 3 correct options.

1.         SKIP. True
2.         WRITE. True
3.         PERFORM. False
4.         CLEAR. False
5.         ULINE. True
6.         SET SCREEN. False

For which tasks is the database interface responsible?

For this question there are 4 correct options.

1.         Syntax check of "native" SQL commands. False
2.         Conversion of Open SQL statement from ABAP statements into the corresponding database statements. True
3.         Data consistency check with respect to foreign key relationships.True
4.         Database independence of application programs. True
5.         Usage of the SAP buffers. True


The search help function know various link options in the ABAP dictionary. Which of the following statements apply?

For this question there are 3 correct options.


1.         A search help function that is linked to the table field can return values only for the search field (field where the f4 help was triggered). True
2.         A search help function that is linked to the data element can return values only for the search field (field where the f4 help was triggered). False
3.         If the search help function is linked to the data element as well as to the field. The search help for the field is displayed. True
4.         If the search help function is linked to a table A. this search help is displayed whenever there are input field from A on the screen.True
5.         If the search help function is linked to a table A. this search help displayed whenever there are input fields on that screen that have A as the check table. False

Which statement is correct for Index?

For this question there are 4 correct options.

1.         An index can be considered to be a copy of a database table reduced to certain fields. True
2.         All of the fields of the table are contained in the index. False
3.         The index also contains a pointer from the index entry to the corresponding table entry to permit all the field contents to be read. True
4.         When you change a data record of a table, you must adjust the index sorting. True
5.         An index can be used to speed up the selection of data records from a table. True

Which of the following statements about indexes are correct?

For this question there are 3 correct options

1.         The primary index consists of the key fields of the database table.True
2.         An index can be assigned to several database tables. False
3.         A database table can have more than one index. True
4.         Using an index speeds up data selection from a table. True

Which statements about parameters for an elementary search help apply?

For this question there are 4 correct options.

1.         Parameters can be displayed on the result list. True
2.         Parameters must be fields from the selection method only. False
3.         Import parameters control which data can be included in the data selection. True
4.         Export parameters control which data can be returned to the input template. True
5.         A parameter is either an import or an export parameter. True