Taw12 - Week 1 Part 1 Of 2 (Total 161 Questions)
For preparation for SAP ABAP certification. This was taken from another website ( http://rs223. Rapidshare. Com/files/152577135/taw12_qa. Zip ) where the answers were already provided.
- 1.
Select the valid Customer Defined Message Statement
- A.
MESSAGE Y123.
- B.
MESSAGE E123(9999)
- C.
MESSAGE ID 'AT' TYPE 'S' NUMBER 100.
- D.
MESSAGE E123 by Fielda Fieldb
Correct Answer
C. MESSAGE ID 'AT' TYPE 'S' NUMBER 100.Explanation
The valid customer defined message statement is "MESSAGE ID 'AT' TYPE 'S' NUMBER 100." This statement follows the correct syntax for defining a message, with the message ID 'AT', type 'S', and number 100. It does not contain any errors or missing components, making it a valid option.Rate this question:
-
- 2.
What happens when a 1 to many relationship is encountered with an inner join
- A.
Redundant data is not returned to the resultant set
- B.
Redundant data from the outer table is included
- C.
Runtime error
- D.
Redundant data from the inner table is included
Correct Answer
B. Redundant data from the outer table is includedExplanation
When a 1 to many relationship is encountered with an inner join, redundant data from the outer table is included in the resultant set. This means that for each record in the outer table, multiple matching records from the inner table may be included in the result. This can lead to duplication of data from the outer table in the result set.Rate this question:
-
- 3.
What must be assigned to search help parameters
- A.
Data element
- B.
Domain
- C.
Values
- D.
Nothing
Correct Answer
A. Data elementExplanation
Search help parameters must be assigned to a data element. A data element defines the technical attributes and semantic meaning of a field in a database table. It provides a description of the field's data type, length, and other properties. By assigning search help parameters to a data element, the system can determine how to display and process the search help values for that particular field. This ensures consistency and accuracy in data entry and retrieval processes.Rate this question:
-
- 4.
What is contained in the system variable sy-linsz.
- A.
Row count of the current line
- B.
Height of the current line
- C.
Width of the current line
- D.
Size of vertical bars in your list
Correct Answer
C. Width of the current lineExplanation
The system variable sy-linsz contains the width of the current line. This variable is used in programming to determine the length or width of a line in a system. It is commonly used to adjust the formatting or layout of text or data within a line.Rate this question:
-
- 5.
Identify the line number that will cause the break for AT NEW CONNECTION CARRIER CONNECTION FLIGHTDATE 10 AA FFF Jan 220 AA FFF Jan 330 DL FFF Jan 5
- A.
All the rows will cause a break
- B.
20
- C.
30
- D.
NO rows will cause a break
Correct Answer
C. 30Explanation
Line 30 will cause the break for AT NEW CONNECTION because it is the last line in the given data and there are no more rows after it. Since there are no more rows, the AT NEW CONNECTION condition will be satisfied and a break will occur.Rate this question:
-
- 6.
On what line does the output 'AAA' appear in the following code: REPORT ZPGM NO STANDARD PAGE HEADING. DO 8 TIMES. WRITE / ' '.ENDDO. SKIP. WRITE 'AAAA'.
- A.
9
- B.
2
- C.
1
- D.
10
Correct Answer
B. 2Explanation
The output 'AAA' appears on line 2 of the code. This is because the DO loop is executed 8 times, resulting in 8 blank lines being written. After the DO loop, a SKIP statement is used to move the cursor to the next line. Then, the WRITE statement is used to write 'AAAA' on the next line, which is line 2.Rate this question:
-
- 7.
What determines if a table is Client Specific versus client independent
- A.
The first field is MANDT with an external data type CLNT and specified as a key field
- B.
Depends how Basis has configured the client
- C.
The option ' Client-Specified' is added to the Select statement
- D.
The first field is MANDT with a domain CLNT but not specified as a key field
Correct Answer
A. The first field is MANDT with an external data type CLNT and specified as a key fieldExplanation
The correct answer is that the first field is MANDT with an external data type CLNT and specified as a key field. This is because in SAP, the field MANDT is used to determine if a table is client specific or client independent. When MANDT is specified as a key field with a data type of CLNT, it means that the table is client specific, meaning that it stores data specific to a particular client. If MANDT is not specified as a key field or has a different data type, then the table is client independent, meaning that it stores data that is shared across all clients.Rate this question:
-
- 8.
What is true about the primary index of a table
- A.
The primary index is automatically created when the table is activated.
- B.
The key fields of the table make up the primary index
- C.
The primary index ID is designated by the Database Administrator
- D.
The developer designates the fields to be used as the primary index
Correct Answer(s)
A. The primary index is automatically created when the table is activated.
B. The key fields of the table make up the primary indexExplanation
The correct answer is that the key fields of the table make up the primary index. This means that the primary index is not automatically created when the table is activated, but rather it is determined by the key fields that are designated by the developer. The primary index is used to uniquely identify each record in the table and is essential for efficient data retrieval and manipulation operations. The primary index ID is not designated by the Database Administrator, but rather it is based on the key fields chosen by the developer.Rate this question:
-
- 9.
Default Page Headings are created on which type of list.
- A.
All lists
- B.
Basis
- C.
Secondary
Correct Answer
B. BasisExplanation
Default Page Headings are created on the Basis type of list.Rate this question:
-
- 10.
Identify the dictionary type of the field catalog used for the ALV control
- A.
Fieldcat
- B.
Catalog
- C.
Alv_catalog
- D.
Lcv_t_fcat
Correct Answer
D. Lcv_t_fcatExplanation
The correct answer is "lcv_t_fcat". This is because the field catalog used for ALV control is typically declared as a table type, where "lcv_t_fcat" suggests that it is a table type named "lcv_fcat". The naming convention "lcv_t_fcat" indicates that it is a table type specifically designed for field catalogs in ALV control.Rate this question:
-
- 11.
Program A issues the following statement SUBMIT PROGRAM B. What takes place
- A.
Program A becomes active in the same internal session of Program B
- B.
Program B becomes active in the same internal session of Program A
- C.
User Context is flushed
- D.
Program B runs in a new internal session
Correct Answer
B. Program B becomes active in the same internal session of Program AExplanation
When Program A issues the statement "SUBMIT PROGRAM B", Program B becomes active in the same internal session of Program A. This means that Program B will run within the same context and environment as Program A, sharing the same resources and data.Rate this question:
-
- 12.
What are valid methods for including text elements in your program
- A.
Write: 'Hello'(001)
- B.
Write: TEXT-001
- C.
Write: 001(Hello)
- D.
Write: TEXT-001'Hello'.
Correct Answer(s)
A. Write: 'Hello'(001)
B. Write: TEXT-001Explanation
The valid methods for including text elements in a program are to use the "Write" command followed by the text in single quotes and a code or identifier in parentheses. The correct answer includes two valid methods: "Write: 'Hello'(001)" and "Write: TEXT-001". The other two options, "Write: 001(Hello)" and "Write: TEXT-001'Hello'", are not valid methods as they do not follow the correct syntax of including text elements in the program.Rate this question:
-
- 13.
Refer to the following. If there are no entries in my_tab, what is the result? Select * from mytable for all entries in my_itab where key1 = my_itab-key1.
- A.
Run time error
- B.
All entries are retrieved
- C.
Only distinct values for key1
- D.
No entries are retrieved
Correct Answer
B. All entries are retrievedExplanation
The correct answer is "All entries are retrieved." This is because the query is using the "for all entries" clause, which means that it will retrieve all entries from the table that match any of the entries in the internal table my_itab. Since there are no entries in my_tab, the query will not have any matching entries to retrieve, resulting in all entries being retrieved.Rate this question:
-
- 14.
When writing a list, what command would allow you to overwrite a line
- A.
Back
- B.
Overtype
- C.
Reserve
- D.
Write:/ 1
Correct Answer
A. BackExplanation
The correct answer is "Back" because when writing a list, the "Back" command allows you to go back to the previous line and overwrite it with new information. This command is useful when you want to make changes or corrections to a line without having to rewrite the entire list.Rate this question:
-
- 15.
What conditions apply for a LEFT outer Join in OPEN SQL
- A.
Only 'Or' can be used as a logical operator in the ON condition
- B.
A Left Outer Join is not permitted in OPEN SQL
- C.
A join statement is found to the right of the join operator
- D.
At least one field from the table on the right is required for comparison in the ON condition
Correct Answer
D. At least one field from the table on the right is required for comparison in the ON conditionExplanation
In a LEFT outer join in OPEN SQL, at least one field from the table on the right is required for comparison in the ON condition. This means that when performing a LEFT outer join, the ON condition must include a comparison between a field from the table on the left and a field from the table on the right. This ensures that the join is performed correctly and that the appropriate data is retrieved from both tables.Rate this question:
-
- 16.
What does a LDB provide
- A.
Consistent and flexible user interface.
- B.
A method to access the data in a random manner
- C.
Centrally defined authorization checks
- D.
Central performance improvements for update accesses
Correct Answer(s)
A. Consistent and flexible user interface.
C. Centrally defined authorization checksExplanation
A LDB (Logical Database) provides a consistent and flexible user interface, allowing users to interact with the data in a standardized manner. It also provides centrally defined authorization checks, ensuring that only authorized users can access and modify the data.Rate this question:
-
- 17.
What is needed to ensure a check field is verified against the referenced key field of the check table.
- A.
Same data type only is required for check field and referenced field
- B.
All key fields MUST have domain equality between check table and foreign key table.
- C.
Same domain is required for check field and referenced field
- D.
Same data element is required for check fied and referenced field
Correct Answer
C. Same domain is required for check field and referenced fieldExplanation
To ensure a check field is verified against the referenced key field of the check table, it is necessary to have the same domain for both the check field and the referenced field. The domain defines the technical attributes and the value range of a field, so having the same domain ensures that the data type and restrictions are consistent between the check field and the referenced field, allowing for proper verification.Rate this question:
-
- 18.
Select an example of Organizational Data
- A.
Sales Order
- B.
Country Keys
- C.
Cost Centers
- D.
Vendors
Correct Answer
B. Country KeysExplanation
Country Keys can be considered as an example of Organizational Data because they represent the different countries in which an organization operates. These keys are used to classify and differentiate data based on country-specific criteria. They provide a way to organize and manage data related to different countries, such as sales figures, customer information, or regulatory requirements. By using country keys, organizations can easily analyze and report data based on geographical regions, enabling better decision-making and understanding of their global operations.Rate this question:
-
- 19.
Identify the valid attributes of a domain
- A.
Header
- B.
Label
- C.
Length
- D.
Fixed Values
- E.
Type
Correct Answer(s)
C. Length
D. Fixed Values
E. TypeExplanation
The valid attributes of a domain are length, fixed values, and type. Length refers to the maximum number of characters or digits that can be stored in the domain. Fixed values are specific predefined values that the domain can take. Type refers to the data type of the domain, such as string, integer, or boolean. These attributes help define the characteristics and constraints of the domain, allowing for proper data validation and manipulation.Rate this question:
-
- 20.
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
Correct Answer
B. They run in their own roll areaExplanation
When called program components are of type transaction or report, they run in their own roll area. This means that each program component has its own separate roll area for storing data during processing. The roll area is not shared with other program components or the calling program. This allows for independent processing and storage of data within each program component.Rate this question:
-
- 21.
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
Correct Answer(s)
A. To insulate the ABAP/4 developer from the database
D. To support the creation and management of metadataExplanation
The main functions of the Data Dictionary are to insulate the ABAP/4 developer from the database and to support the creation and management of metadata. By insulating the developer from the database, the Data Dictionary provides a layer of abstraction that allows developers to work with data in a simplified and standardized manner, without having to directly interact with the underlying database structure. Additionally, the Data Dictionary supports the creation and management of metadata, which includes information about the structure, relationships, and attributes of the data stored in the database. This metadata is essential for data integrity, data consistency, and data manipulation operations.Rate this question:
-
- 22.
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
Correct Answer
C. SAP user can be assigned to only one user groups -
- 23.
Programs that extend beyond transaction limits and want to pass data should use
- A.
SAP Memory
- B.
Tables
- C.
ABAP/4 Memory
Correct Answer
A. SAP MemoryExplanation
Programs that extend beyond transaction limits and want to pass data should use SAP Memory. SAP Memory is a shared memory area that allows different programs to exchange data during the same user session. It provides a temporary storage space where programs can store and retrieve data, ensuring that the data is accessible by all programs running in the same user session. This makes it a suitable choice for passing data between programs that need to communicate with each other and share information.Rate this question:
-
- 24.
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
Correct Answer
C. Read Table ITABExplanation
The "Read Table ITAB" method is an invalid method for populating an internal table. The "Read Table" statement is used to read individual lines from an internal table based on a key or a condition, but it does not populate the entire internal table. To populate an internal table, valid methods include using the "Insert ITAB" statement to add new lines, using the "Append" statement to add a single line at the end, using the "Select * into Table ITAB from dbtab" statement to retrieve data from a database table, or using the "Collect" statement to combine lines from one internal table into another.Rate this question:
-
- 25.
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
Correct Answer
B. No Standard Page HeadingExplanation
The correct answer is "No Standard Page Heading" because this clause is specifically mentioned as the one used to suppress standard headers. The other options do not mention anything about suppressing headers or are not relevant to the given context.Rate this question:
-
- 26.
What appears in the standard header of a list
- A.
Page Number
- B.
User
- C.
Program Title
- D.
Date
- E.
Underline
Correct Answer(s)
A. Page Number
C. Program Title
E. UnderlineExplanation
The standard header of a list typically includes the page number, program title, and an underline. This information is commonly included at the top of each page in a list to provide context and organization. The page number helps identify the page within the list, the program title specifies the name of the program or document, and the underline is used to visually separate the header from the rest of the content.Rate this question:
-
- 27.
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
Correct Answer
D. It is transferred back to the fields defined in the programExplanation
After a READ LINE on a list, the HIDE data is transferred back to the fields defined in the program. This means that the data which was previously hidden is now made available and assigned to the corresponding fields in the program.Rate this question:
-
- 28.
Which of the following short programs will not display the text "SY-LSIND= 1" during interactive reporting. REPORT ZPGM1.WRITE: 'Basic List: List Number =', SY-LSIND.AT LINE-SELECTION. WRITE: 'Secondary List'. IF SY-LSIND = 2. SY-LSIND = SY-LSIND - 1. WRITE: 'SY-LSIND=’, SY-LSIND. ENDIF. REPORT ZPGM2.WRITE: 'Basic List: List Number =', SY-LSIND.AT LINE-SELECTION. CHECK NOT SY-LSIND = 1. WRITE: 'SY-LSIND=’, SY-LSIND. REPORT ZPGM3.WRITE: 'Basic List: List Number =', SY-LSIND.AT LINE-SELECTION. WRITE: 'Secondary List'. IF SY-LSIND = 1. WRITE: 'SY-LSIND=’, SY-LSIND. ENDIF.
- A.
ZPGM3
- B.
ZPGM2
- C.
ZPGM1
Correct Answer
B. ZPGM2Explanation
ZPGM2 will not display the text "SY-LSIND= 1" during interactive reporting because it includes a CHECK statement that checks if SY-LSIND is not equal to 1. If the condition is true, the program will skip the WRITE statement that displays "SY-LSIND= 1". Therefore, the text will not be displayed.Rate this question:
-
- 29.
Where does information come from when you press F1 on a screen field
- A.
Data element documentation
- B.
Domain short text
- C.
Search help
- D.
Domain Help values
Correct Answer
A. Data element documentationExplanation
When you press F1 on a screen field, the information comes from the data element documentation. Data element documentation provides detailed information about the data element, including its description, possible values, and any restrictions or rules associated with it. Pressing F1 allows users to access this documentation and get a better understanding of the field and how it should be used.Rate this question:
-
- 30.
What will cause the AT USER-COMMAND to fire
- A.
Type S Function Codes
- B.
Type T Function Codes
- C.
Normal Function Codes
- D.
Function Codes that start with P
Correct Answer
C. Normal Function CodesExplanation
The AT USER-COMMAND event will fire when the user enters a normal function code. This means that any function code that does not fall under the categories of Type S, Type T, or start with P will cause the AT USER-COMMAND event to trigger.Rate this question:
-
- 31.
What are the corrdinates of the following Modal Dialog Box. Window Starting at 10 20 Ending at 20 30
- A.
Starting at Column 10, Row 20 Ending at Column 20, Row 30
- B.
Starting at Column 10, Row 30 Ending at Column 20, Row 20
- C.
Starting at Row 10, Column 20 Ending at Row 20, Column 30
Correct Answer
A. Starting at Column 10, Row 20 Ending at Column 20, Row 30Explanation
The correct answer is "Starting at Column 10, Row 20 Ending at Column 20, Row 30." This answer accurately describes the coordinates of the modal dialog box by specifying the starting and ending positions in terms of columns and rows.Rate this question:
-
- 32.
What is the effect of the Collect Statement if an entry with the same key already exists
- A.
Appends a new line
- B.
Adds the numeric fields to an existing entry
- C.
Creates a new entery
Correct Answer
B. Adds the numeric fields to an existing entryExplanation
The Collect Statement, when used with an existing entry with the same key, will add the numeric fields to that existing entry. This means that the values of the numeric fields will be combined or updated in the existing entry, rather than creating a new entry or appending a new line.Rate this question:
-
- 33.
How are buffers used by inner and outer joins
- A.
Buffers are always used
- B.
Buffers are always bypassed
- C.
The choice can be made to use or bypass buffers
Correct Answer
B. Buffers are always bypassedExplanation
Buffers are used to temporarily store data during join operations. However, in the case of inner and outer joins, buffers are always bypassed. This means that the join operation is performed directly without the need for temporary storage. This can improve the efficiency and speed of the join operation as it eliminates the overhead of buffering the data. Therefore, the choice to use or bypass buffers is not applicable in the context of inner and outer joins.Rate this question:
-
- 34.
Mark the code that will display the selection screen of the called program ZTST,
- A.
SUBMIT ZTST USING SELECTION-SET 'VAR1'
- B.
SUBMIT ZTST VIA SELECTION-SCREEN
- C.
SUBMIT ZTST AND RETURN.
- D.
SUBMIT ZTST VIA SELECTION-SCREEN USING SELECTION-SET 'VAR1'
Correct Answer(s)
B. SUBMIT ZTST VIA SELECTION-SCREEN
D. SUBMIT ZTST VIA SELECTION-SCREEN USING SELECTION-SET 'VAR1'Explanation
The correct answer is "SUBMIT ZTST VIA SELECTION-SCREEN, SUBMIT ZTST VIA SELECTION-SCREEN USING SELECTION-SET 'VAR1'". These two options will display the selection screen of the called program ZTST. The first option "SUBMIT ZTST USING SELECTION-SET 'VAR1'" will not display the selection screen, it will only execute the program with the specified selection set. The last option "SUBMIT ZTST AND RETURN" will execute the program and return to the calling program without displaying the selection screen.Rate this question:
-
- 35.
During interactive reporting, at what point does sy-lsind get incremented by the system
- A.
When you programatically increment it
- B.
At the end of an interactive processing block
- C.
At the beginning of an interactive processing block
Correct Answer
C. At the beginning of an interactive processing blockExplanation
The system increments the value of sy-lsind at the beginning of an interactive processing block. This means that before any code within the interactive processing block is executed, sy-lsind is already incremented by the system.Rate this question:
-
- 36.
What requirement exists if a field is defined in the dictionary of type CURR
- A.
Decimals must be defined in the domain
- B.
The field must be numeric
- C.
The field must be linked to another field of type CUKY
- D.
No other requirements exist
Correct Answer
C. The field must be linked to another field of type CUKYExplanation
If a field is defined in the dictionary of type CURR, the requirement is that the field must be linked to another field of type CUKY. This means that the field representing currency values must be associated with another field that represents the currency code. This linkage ensures that the currency values are correctly interpreted and displayed in the appropriate currency format.Rate this question:
-
- 37.
What is true about views
- A.
A view contains data
- B.
Maintenance Views are not updateable
- C.
A view is automatically created on the database upon activation
- D.
Views can be buffered
Correct Answer(s)
C. A view is automatically created on the database upon activation
D. Views can be bufferedExplanation
Views are database objects that are created based on the result of a query. When a view is activated, it is automatically created on the database. This means that the view is stored and can be accessed by other users. Additionally, views can be buffered, which means that the result of the query used to create the view is stored in memory for faster access. However, maintenance views, which are used for system administration purposes, are not updateable.Rate this question:
-
- 38.
READ CURRENT LINE make used of what system variables....
- A.
SY-CUROW
- B.
SY-PAGENO
- C.
SY-CPAGE
- D.
SY-INDEX
Correct Answer(s)
A. SY-CUROW
C. SY-CPAGEExplanation
The correct answer is SY-CUROW and SY-CPAGE. These system variables are used in ABAP programming language to determine the current row and current page number respectively. SY-CUROW stores the current row number of the internal table being processed, while SY-CPAGE stores the current page number of the list being processed. These variables are commonly used when displaying data in a tabular format or when implementing pagination in a report.Rate this question:
-
- 39.
When does a table get physically created in the underlying database
- A.
When you activate a transparent table the the ABAP Workbench
- B.
When you create a transparent table
- C.
When Basis created the tablespace at the OS Layer
- D.
When you activate a transparent table in the Dictionary
Correct Answer
D. When you activate a transparent table in the DictionaryExplanation
When you activate a transparent table in the Dictionary, the table gets physically created in the underlying database. The activation process ensures that the table structure and properties defined in the Dictionary are implemented in the database. This includes creating the necessary database objects, such as the table itself, indexes, and constraints. Once the activation is successful, the table is ready for data storage and retrieval in the database.Rate this question:
-
- 40.
When you EXPORT an internal table that has a header line to ABAP/4 memory, what is the result.
- A.
The header line and contents of the internal table are stored
- B.
You cannot EXPORT an internal table with a header line
- C.
Only the header line is stored
- D.
Only the contents of the internal table is stored
Correct Answer
D. Only the contents of the internal table is storedExplanation
When you export an internal table that has a header line to ABAP/4 memory, only the contents of the internal table are stored. The header line is not included in the export.Rate this question:
-
- 41.
What is the code required in order to scroll to the 3rd detail list to page 5
- A.
Scroll LIST Index 3 to Page 5
- B.
Scroll LIST sy-index 3 to Page 5
- C.
Scroll LIST sy-lsind 3 to Page 5
- D.
Scroll LIST 3 5
Correct Answer
A. Scroll LIST Index 3 to Page 5Explanation
The correct answer is "Scroll LIST Index 3 to Page 5" because it specifies the correct syntax for scrolling to the 3rd detail list on page 5. The keyword "Index" is used to indicate the position of the list, and "Page" is used to specify the page number.Rate this question:
-
- 42.
In the context of a logical database, which is not a valid ABAP/4 keyword event
- A.
Get
- B.
Initialization
- C.
At Selection-Screen
- D.
End-of-Selection
- E.
Put
Correct Answer
E. PutExplanation
In the context of a logical database, "Put" is not a valid ABAP/4 keyword event. The other options listed (Get, Initialization, At Selection-Screen, and End-of-Selection) are valid ABAP/4 keyword events that can be used in the logical database.Rate this question:
-
- 43.
Mark the sort statement that is more efficient
- A.
Sort Itab Ascending
- B.
Sort ITAB
- C.
Sort ITAB BY (fieldname)
- D.
Sort ITAB by keys
Correct Answer
C. Sort ITAB BY (fieldname)Explanation
Sorting a table by a specific field name using the "Sort ITAB BY (fieldname)" statement is more efficient compared to the other options provided. This statement allows for a more targeted and precise sorting process, as it only sorts the table based on the specified field, resulting in faster execution time and better performance. The other options either lack specificity or do not provide a clear indication of the sorting criteria, making them less efficient choices.Rate this question:
-
- 44.
Select the methods used to access data on the database.
- A.
Read Table
- B.
Get Node
- C.
Native SQL
- D.
ABAP/ Open SQL
- E.
LDB
Correct Answer(s)
C. Native SQL
D. ABAP/ Open SQL
E. LDBExplanation
The methods listed in the answer options are commonly used to access data on a database. Native SQL allows direct execution of SQL statements in the database, ABAP/Open SQL is a programming language used to access database tables, and LDB (Logical Database) provides a high-level interface to access data from multiple tables. Therefore, Native SQL, ABAP/Open SQL, and LDB are the correct methods for accessing data on a database.Rate this question:
-
- 45.
Where does the system store the data after a Read Line has been performed on a list.
- A.
In Memory
- B.
In an Internal Table
- C.
SY-LISTI
- D.
SY-LISEL
Correct Answer
D. SY-LISELExplanation
After a Read Line operation is performed on a list, the system stores the data in the SY-LISEL.Rate this question:
-
- 46.
What is true about sorting an Extract (Intermediate) dataset.
- A.
You can sort an extract dataset even without a header
- B.
The extract dataset is typically sorted in the Start-of-Selection processing block
- C.
The sequence of the control breaks in the Loop does not have to correspond to the extract dataset sort sequence
- D.
The extract dataset must be sorted for processing to begin
Correct Answer
D. The extract dataset must be sorted for processing to beginExplanation
The correct answer states that the extract dataset must be sorted for processing to begin. This means that in order to perform any operations or calculations on the extract dataset, it is necessary to sort it first. Sorting the dataset allows for easier and more efficient processing, as it organizes the data in a specific order that can be easily navigated. Without sorting the dataset, the processing may not yield accurate or desired results.Rate this question:
-
- 47.
When is the Top-of-Page event triggered
- A.
When the Top-of-Page eventer is encountered in sequence
- B.
After number of lines per pages, as specified in the REPORT, have been written to the list buffer
- C.
When the report starts
- D.
When the first write statement is encountered
Correct Answer
D. When the first write statement is encounteredExplanation
The Top-of-Page event is triggered when the first write statement is encountered in the program. This event is used to perform certain actions, such as printing headers or formatting, before the data is written to the output. It allows for customization of the output layout and appearance at the beginning of each page.Rate this question:
-
- 48.
What is the purpose of the Nodes statement in an ABAP program
- A.
Points to cluster tables
- B.
Indicates the nodes from the logical database
- C.
Specifies the logical database
- D.
Sets up an address pointer to the nodes in the shared memory buffers
Correct Answer
B. Indicates the nodes from the logical databaseExplanation
The Nodes statement in an ABAP program is used to indicate the nodes from the logical database. This means that it specifies which nodes within the logical database should be accessed or processed in the program. By indicating the nodes, the program can efficiently retrieve or manipulate data from specific areas within the logical database, allowing for more targeted and optimized operations.Rate this question:
-
- 49.
What happens when an EXIT statement is executed in the AT event
- A.
The program ends
- B.
The remainder of the current processing block is executed
- C.
The output list is displayed
- D.
The sytem leaves the processing block and branches to the processing block of the next event
Correct Answer
D. The sytem leaves the processing block and branches to the processing block of the next eventExplanation
When an EXIT statement is executed in the AT event, the system leaves the current processing block and branches to the processing block of the next event. This means that the program does not end immediately, but rather continues processing with the next event in the sequence. The remaining code in the current processing block is not executed, and the output list is not displayed at that point.Rate this question:
-
- 50.
What makes a text table
- A.
The type of foreign key field defined must be "No key / Candidates'
- B.
The key of the text table consists of the key of the check table plus an additional language key
- C.
Cardinality must be defined as 1:1
Correct Answer
B. The key of the text table consists of the key of the check table plus an additional language keyExplanation
The key of the text table consists of the key of the check table plus an additional language key. This means that the text table is linked to the check table using the key field, and the language key is added to differentiate between different languages for the same entry in the check table. This allows for the storage and retrieval of text data in multiple languages for the same entry in the check table. The other two options mentioned (type of foreign key field and cardinality) are not directly related to what makes a text table.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Aug 10, 2009Quiz Created by
Newtonskn
Back to top