Dictionary, Object and Database Updates, Exam ABAP 7,5

Which of the following generic types can you use to define a field symbol that will be assigned to a character string? There are 3 correct answers to this question. Type xsequence. Type any. Type clike. Type csequence. Type any table.

Which of the following statements are true? There are 3 correct answers to this question. The tables included in the help view should have a foreign key relationship. Projection views can have more than one table included for the view definition. You cannot use a pooled or cluster table for a database view. The tables included in the maintenace view should have foreign key relationships.

What is the allowed length of the ABAP Dictionary data type DF34_RAW? Please choose the correct answer. The allowed length is between 0 and 33 digits. The allowed length is between 1 and 34 digits. None of the above. The allowed length is 34 digits. The allowed length is between 1 and 31 digits.

What are the advantages of creating a database view to implement a join, instead of formulating the join directly in an OPEN SQL SELECT statement? There are 2 correct answers to this question. A secondary index can be created for a database view. An outer join can only be implemented in a database view. A database view can be buffered. A database view can be reused in other programs.

Which screen in the ABAP Dictionary allows you to log data changes to the table? Please choose the correct answer. Utilities Database Object Database Utility. Delivery and Maintenance tab. Utilities Settings. Technical settings. Attributes tab.

Which statement is true? Please choose the correct answer. A SAP LUW must be placed within a database LUW. A database LUW cannot be placed within a SAP LUW. A database LUW must be placed without a SAP LUW. A database LUW must be placed within a SAP LUW.

The data buffered on each application server... Please choose the correct answer. Is never the same. Depends on the users. Is always the same.

You have created table ZTAB and you want to create a foreign-key relationship to table SAPTAB.Under which condition is this possible? Please choose the correct answers. The check field in ZTAB must have the same name as the corresponding field of check table SAPTAB. The check field in ZTAB must have a data element that does NOT refer to a domain. The check field in ZTAB must have the same domain as the corresponding field of check table SAPTAB. The check field in ZTAB must have the same ABAP Dictionary type as the corresponding field of check table SAPTAB.

In which circumstances is a table considered to be a text table? There are 3 correct answers to this question. This table only has one character-based data field. The ABAP runtime system determines that the relationship exists. The entire key of this data table is included as the key to this table. This table has a foreign key to the data table as a text table. This table has an additional language key field.

Which components belong to an elementary search help? There are 2 correct answers to this question. Attachment to a field. Selection method. Fixed values. Import/export parameters.

What do you have to take into account before you decide to buffer a table?. The data read from the buffer may NOT be current. The data must always be read from the buffer. The entire table content must be loaded into the table buffer. The database server must allow table buffering.

Which data element property do you set so that the system logs changes to the content of fields with this data element? Please choose the correct answer. Change document. Documentation. Parameter ID. Input history.

What properties will be set when you define a table type in the ABAP Dictionary? There are 3 correct answers to this question. Line type. Access mode. Primary key. GET/SET Parameter. Change document.

Which of the following regarding search helps is a true statement? Please elect all the correct answers that apply. The text table for the selection method is automatically populated if the text table is attached to the database table being used as the selection method. The interface for the search help is define by the IMP (import) and EXP (export) flag of the search help parameter. The LPos parameter defines the position of the search help parameter in the search hit list. The SPos parameter defines the position of th einput field on the dialog screen.

A structure has enhancement category 3, can be enhanced (character-type). Which set of elementary types is allowed for the new fields? Please choose the correct answer. C,D,N,X. C,D,N,T. D,I,string,T. F,I,P,X.

You want to define two database tables with different structures. Both tables should contain the fields CHANGE_DATE and CHANGE_TIME.How do you implement this in order to minimize the maintenance effort? Please choose the correct answer. Define the two fields in one database table and copy them to the other database table. Define an append structure with these two fields and assign this append structure to both database tables. Define the two fields in each database table separately. Define a structure with these two fields and include this structure in both database tables.

What type of ABAP Dictionary view is implemented as an INNER JOIN? Please choose the correct answer. Database view. Maintenance view. Projection view. Help view.

Which of the following are incomplete ABAP pre-defined data types?. D. T. P. N. X.

When must a foreign key have domain equality? Please choose the correct answer. Always. For a text table. For a check field. Never.

Which database objects can you create in the ABAP Dictionary? There are 2 correct answers to this question. Indexes. Projection views. Foreign key relationships. Logical databases.

Which of the following statements correctly define a data object with the type of data element s_conn_id? There are 3 correct answers to this question. DATA gv_id TYPE REF TO s_conn_id. PARAMETERS pa_id TYPE s_conn_id. CONSTANTS gc_id TYPE s_conn_id VALUE '0400'. DATA gv_id LIKE s_conn_id. DATA gv_id TYPE s_conn_id.

Which of the following customer modification options are available in the table maintenance generator? There are 2 correct answers to this question. Events. Search helps. Append searches. Maintenance screens.

What do global types and local types have in common? Please choose the correct answer. Field labels. Search help. Technical information. Documentation.

You define database view A and maintenace view B in the ABAP Dictionary. What restrictions apply to these views? There are 2 correct answers to this question. The tables joined in B must have foreign key relationships. The join type of both A and B is inner join. The tables joined in A must have foreign key relationships. Only A can be used in the FROM clause of a SELECT statement.

You create a domain in the ABAP dictionary.How can you use this domain? Please choose the correct answer. To define technical properties of data elements. To define data objects in ABAP programs. To define the data type of a table field or structure component. To describe the value range of a table field or structure component.

Which of the following are true statements? There are 3 correct answers to this question. Table fields can be assigned to a data element. Search helps can be defined for a table field that is assigned to a predefined data type. A reference table and field are required for fields with the data types QUAN and CURR. Table fields can be assigned to an ABAP Dictionary type directly.

A customer has asked that you improve performance for a small table with frequent read accesses. What buffering type do you recommend? Please choose the correct answer. Single Record. Primary key. Column store. Full table.

How can you maintain documentation for input fields on your screen? Please choose the correct answer. Add documentation to the underlying data element. Add documentation to the SCREEN table at PROCESS BEFORE OUTPUT(PBO). Define text tables for the underlying structure. Add documentation to the SCREEN table at PROCESS AFTER INPUT(PAI).

You have created a screen on which the user enters data that is to be inserted into table T1. How do you ensure that the content of field F in table T1 is checked against table T2? Please choose the correct answer. Create a foreign key for the assigned field of field F of table T1 in table 2 and make table T2 the check table. Create a foreign key for field F of table T1 and make table T2 the foreign key table. Create a foreign key for field F of table T1 and make table T2 the check table. Create a foreign key for the assigned field of field F of table T1 in table T2 and make table T1 the check table.

Which of the following statements are true? There are 2 correct answers to this question. A maintenance view is implemented as an inner join. A database view is implemented as an inner join. A database view is implemented as an outer join. A maintenace view is implemented as an outer join.

When does SAP recommend that you use a full buffering type for a database table? Please choose the correct answer. When the table is small and frequently written. When the table is large and seldom written. When the table is small and seldom written. When the table is large and frequently written.

Which objects are automatically created when you create a new function group? Please choose the correct answer. A function pool and two subroutine pools. A function pool and two module pools. A function pool and two function modules. A function pool and two include programs.

What must a search help do? There are 4 correct answers to this question. Use a table or a view for data selection. Have a dialog with the user. Determine the values for selection by the user. Be used from a screen. Allow the user to select a response.

What data type you can create in the ABAP Dictionary? Please choose the correct answers. Type group. Lock object. Structure. Secondary index.

Why should you bundle database updates in your dialog programs? Please choose the correct answer. To be able to rollback database changes performed in the same dialog step. To allow you to use SAP locks to ensure data consistency. To process the SAP LUW within the database LUW to ensure data consistency. To avoid database locks set by an SQL statement that persists until the end of the program.

What can you create using the ABAP Dictionary? There are 3 correct answers to this question. Internal tables. Type pools. Field symbols. Transparent tables. Domains.

For which of the following purposes can you use the ABAP dictionary? There are 2 correct answers to this question. To create lock objects. To create development classes. To activate logging for transparent tables. To maintain program translations.

What must you do to define a database view using the ABAP Dictionary? There are 3 correct answers to this question. Choose the fields from the tables that should be part of the view. Define selection criteria for the view. Define Buffering settings for the underlying database tables. Choose the database tables from where the view acquires data. Define the join conditions between the tables.

Which of the following ABAP data types are compatible with the generic character-type CLIKE? There are 3 correct answers to this question. STRING. N. C. DECFLOAT. XSTRNG.

Which of the following ABAP dictionary types can you use to define domains? Theare are 3 correct answers to this question. FLOAT. DATE. CHAR. NUMC. DEC.

Where are fixed values for fields stored? Please choose the correct answer. Structure. Domain. Data element. Table. Field.

Which of the following transaction can you use to define transparent tables? Please choose the correct answer. SE16N. SM37. SE11. s38.

When included in a structure, which elementary field types allow the structure to be considered a character-type data object? There are 4 correct answers to this question. F. I. XSTRING. T. N. STRING. D. C. X.

Which of the following ABAP standard types are incomplete? There are 2 correct answers to this question. N. X. STRING. F.

Which pre-defined ABAP data type is deep? Please choose the correct answer. STRING. DECFLOAT34. N. X. None of the above.

Which action on the underlying dictionary objects triggers a database table conversion? Please choose the correct answer. Changing the order of non-key fields. Inserting a field of type reference. Reducing the size of the field. Inserting an APPEND structure.

Which of the following repository objects can you maintain in the ABAP Workbench? There are 3 correct answers to this question. Internal tables. Business functions. Transparent tables. Module Pools. Function modules.