undefinedWhen using Open SQL statements in an ABAP/4 program, you must ensure the following. undefinedThe database system being addressed must be supported by SAP. undefinedThe database tables being addressed must be defined in the ABAP/4 dictionary. undefinedBoth a and b undefinedNone.
undefinedWhich of the following statements are correct? database interface translates SAPs Open SQL statements into SQL commands specific to the database in use. Native SQL statements access the database directly When you use Native SQL, the addressed database tables do not have to be known to the ABAP/4 dictionary. In Open SQL, the addressed database tables must be defined in the ABAP/4 dictionary There is automatic client handling in Native SQL whereas clients must always be specified in Open SQL.
undefinedWhich of the following are true? TABLE is used as a synonym for STANDARD TABLE You can only access a hashed table using the generic key operations. Explicit or implicit index operations (such as LOOP ... FROM oe INSERT itab within a LOOP) are not allowed. All hashed tables are index tables We have to define the hash procedure explicitly for HASHED TABLE.
Can a transparent table exist in data dictionary but not in the database physically? true false.
Can you create a table with fields not referring to data elements? Yes No.
How do you create a batch input session for a transaction? Call transaction in background mode. Call transaction in error mode. Bdc_insert for the transaction. None of the above.
What is the alternative to batch input session? Load module Call transaction BAPI Idoc segment.
The following are true about EXEC SQL. You can end the Native SQL with a semicolon. You can end the Native SQL with a period You cannot perform reliable authorization checks using EXEC SQL. Host variables in the Native SQL are identified with a preceding hash (#).
The following are true about database locking. Database systems set physical locks on all lines affected by a database call. Read locks prevent the setting of further read locks for the objects in question. Read locks prevent other transactions from setting write locks for the objects in question Write locks allow other transactions to set read locks for the objects in question.
What are field symbols? 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. Field symbols have to be created with type specifications only. You cannot assign one field symbol to another. All operations you have programmed with the field symbol are carried out with the assigned field.
EXTRACT statement The first EXTRACT statement extracts the first extract record. The first EXTRACT statement creates the extract dataset and adds the first extract record. Each extract record contains, if specified, the fields of the field group. Each extract record contains, if specified, the fields of the field symbol.
You cannot assign a local data object defined in a subroutine or function module to a field group. true false.
Which of the following are true? COLLECT can only be used with STANDARD TABLE. To use COLLECT, the internal table should be derived from a database table with an explicit key. If the system finds a numeric component, that is not part of the key, the numeric fields that are not part of the table key (see ABAP number types) are added to the sum total of the existing entries. If it does not find an entry, control passes on to the next record in the internal table. the system finds a numeric component, that is not part of the key, the numeric fields that are not part of the table key (see ABAP number types) are added to the sum total of the existing entries. If it does not find an entry, the system creates a new entry instead.
Which of the following are true? ABAP queries are created by associating them to a logical database or through a direct read/data retrieval program. ABAP queries are created from functional areas that are created from a logical database or through a direct read/retrieval program. ABAP queries are created from user groups attached to the functional areas that are created from a logical database or through a direct read/retrieval program ABAP queries are created through the regular report program.
A logical unit of work (LUW or transaction) begins Each time you start a transaction. Each time you end a transaction When the database changes of the previous LUW have been confirmed (database commit). Before the database changes of the previous LUW have been cancelled (database rollback).
A database commit is triggered by ABAP/4 command COMMIT WORK. CALL SCREEN, CALL DIALOG. A Remote Function Call CALL TRANSACTION.
The following are true about SAPscript control commands. If a control command is unknown or it contains syntax errors, the line containing it will be printed out as it is. If a control command is unknown or it contains syntax errors, the line containing it will be treated as a comment line. A maximum of one control command may appear in each line. A maximum of six control commands may appear in each line.
To output SAPscript layout sets, in the print program You must always start the output with OPEN_FORM and end it with CLOSE_FORM Within one transaction, you can use only one OPEN_FORM and CLOSE_FORM to open and close a layout set. WRITE_FORM should be used within an OPEN_FORM and CLOSE_FORM. WRITE_FORM can be used without an OPEN_FORM and CLOSE_FORM.
The transaction CMOD and SMOD are Used to create enhancements to standard SAP programs Used to create enhancements to ABAP queries. Used to create the user exits, menu exits and screen exits Used to modify the standard function groups.
Which of the following are tools to report data in ABAP? ALV ALE LSMW SmartForms.
ABAP Query tool is used to: Enquire about a running-program status Automatically generate code for reporting Perform database operations for user-written programs None of the above.
In ABAP Query tool... Each user can be assigned to several user-groups Each user can be assigned to several functional areas Each functional area can be assigned to several user-groups One user can be assigned only to one user-group.
Logical databases must be used to create an ABAP Query true false.
In a BDC program, how would you handle errored records? Would you Rerun the program Report the errored records Generate a batch-input session with errored records Create an output file, to be run again after corrections.
What are IDocs? Documentation of executable programs Documents used for data-transport between SAP and non-SAP s/w. Documents used for data-transport between two different SAP systems Documents used for one-time data-migration activities.
For transportation of data from a presentation server into SAP, the function module used is UPLOAD WS_UPLOAD FILE_UPLOAD DATA_UPLOAD.
For one-time high volume data-uploads into SAP from non-reliable systems, the following are generally used: BDC LSMW Direct table update Idocs.
In an ABAP program, the INITIALIZATION event is invoked Before the AT-SELECTION-SCREEN event After the AT-SELECTION-SCREEN event Could be either way Cannot be predicted.
The statement to check whether an internal table itab_test has no records, is:IF itab_test is initial. true false.
The statement used to clear all the contents of an internal table is: CLEAR itab. REFRESH itab. FREE itab. DELETE itab.
The AT-SELECTION-SCREEN event is triggered when ENTER key is hit on the selection-screen F8 key is hit on the selection-screen Any field on selection-screen is populated F4 key is hit on the selection-screen .
What is the transaction-code for viewing batch-runs of a program? SE37 SM37 SM35 SM30.
SY-BATCH can be used to determine whether a program is being run in batch-mode, within the AT-SELECTION-SCREEN event true false.
The following statements will clear the header-line of an internal table: DELETE ITAB. FREE ITAB REFRESH ITAB. CLEAR ITAB.
The SAP Logon password is always case-insensitive true false.
undefinedPERFORM ROUTINE1 USING val1.
..
FORM ROUTINE1 USING temp1.
Temp1 = 10.
ENDFORM.
yes no.
Within an IF-ENDIF block, undefinedELSE must be used undefinedELSEIF must be used undefinedIf ELSEIF is used, ELSE must be used undefinedNone of the above.
undefinedThe user-list in a given SAP client can be found using transaction STO4 SE04 SM04 None of the above.
The DESCRIBE statement on internal tables is used to: undefineda) Find the number of lines currently in table undefinedb) Find initial size of the table undefinedc) Find type of the internal table undefinedd) Give the line size, in number of characters, of the table.
undefined54. Which of the following statements can work without a corresponding END-statement? undefineda) DO undefinedb) AT undefinedc) IF undefinedd) SELECT.
undefined55. In an ABAP program, we can specify a variable to be of HEXADECIMAL type. true false.
undefined56. In an ABAP program, we can specify a variable to be of OCTAL type. true false.
undefined57. The default length of a field of type time(T) in an ABAP program is: 6 8 14 0.
undefined. Can ABAP control statements be used within a sap script? yes no.
undefined70. When is Top-of-page event executed undefineda) Triggered by a New-page statement undefinedb) When the First Write Statement of the program is encountered. undefinedc) Before outputting the first line on a new page.
|
