Jose Bermejo
Quiz von , erstellt am more than 1 year ago

TAW10 - parte 2 - hasta capitulo 7

851
0
0
Jose Bermejo
Erstellt von Jose Bermejo vor fast 5 Jahre
Schließen

ABAP 4

Frage 1 von 30

1

Which of the following statements are true?
There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • You cannot use a pooled or cluster table for a database view.

  • The tables included in the maintenance view should have foreign key relationships.

  • 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.

Erklärung

Frage 2 von 30

1

You want to add a field ZZPRICE to the SAP standard transparent table EKKO.
Which of the following actions result in an enhancement of the SAP standard?
There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Insert ZZPRICE at the end of the table

  • Create an append structure and add ZZPRICE to it.

  • Add ZZPRICE to the customizing include for the table

  • Insert ZZPRICE into an SAP structure for the table

Erklärung

Frage 3 von 30

1

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.

Wähle eine der folgenden:

  • Define an append structure with these two fields and assign this append structure to both database tables.

  • Define the two fields in one database table and copy them to the other database table.

  • Define the two fields in each database table separately.

  • Define a structure with these two fields and include this structure in both database tables

Erklärung

Frage 4 von 30

1

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.

Wähle eine oder mehr der folgenden:

  • XSTRING

  • STRING

  • N

  • T

  • X

  • D

  • C

  • F

Erklärung

Frage 5 von 30

1

Which of the following can you define in the technical settings of a transparent table?
There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Table name

  • Buffering type

  • Data class

  • Size category

  • Delivery class

Erklärung

Frage 6 von 30

1

Which boundary conditions lead to improved access time to an internal table?
There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Fully qualified key for sorted tables

  • Left justified part of key for hashed tables

  • Left justified part of key for sorted tables

  • Index access for standard tables

  • Index access for hashed tables

Erklärung

Frage 7 von 30

1

An executable ABAP program contains a standard selection screen and uses the event blocks AT SELECTION SCREEN, AT SELECTION-SCREEN OUTPUT, INITIALIZATION, START-OFSELECTION.
In which sequence will ABAP runtime call these event blocks?
Please choose the correct answer.

Wähle eine der folgenden:

  • 1. INITIALIZATION
    2. AT SELECTION-SCREEN OUTPUT
    3. AT SELECTION-SCREEN
    4. START-OF-SELECTION

  • 1. INITIALIZATION
    2. AT SELECTION-SCREEN OUTPUT
    3. START-OF-SELECTION
    4. AT SELECTION-SCREEN

  • 1. AT SELECTION-SCREEN OUTPUT
    2. INITIALIZATION
    3. AT SELECTION-SCREEN
    4. START-OF-SELECTION

  • 1. INITIALIZATION
    2. AT SELECTION-SCREEN
    3. AT SELECTION-SCREEN OUTPUT
    4. START-OF-SELECTION

Erklärung

Frage 8 von 30

1

Which of the following can you assign a search help to?
There are 3 correct answers to this question

Wähle eine oder mehr der folgenden:

  • Table type

  • Check table

  • Structure component

  • Data element

  • Domain

Erklärung

Frage 9 von 30

1

Which of the following ABAP standard types are numeric?
There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • F

  • D

  • N

  • I

  • P

Erklärung

Frage 10 von 30

1

You want to add a field type CURR to a transparent table. What else must you do?
Please choose the correct answer.

Wähle eine der folgenden:

  • Add a key fieldof type CUKY.

  • Add a check table that contains a field of type CUKY.

  • Create a reference to a field of type CUKY.

  • Create a new field CUKY as a pre-defined type.

Erklärung

Frage 11 von 30

1

In addition to the primary key of an internal table, how many secondary indexes can you define for an internal table?
Please choose the correct answer.

Wähle eine der folgenden:

  • 1

  • 10

  • 15

  • 0

Erklärung

Frage 12 von 30

1

Which of the following data types are predefined ABAP data types?
There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • XSTRING

  • FLOAT

  • DECIMALS

  • STRING

  • DECFLOAT34

Erklärung

Frage 13 von 30

1

To which ABAP Dictionary definition can you assign fixed values?
Please choose the correct answer.

Wähle eine der folgenden:

  • Field of a transparent table

  • Data element

  • Component of a structure

  • Domain

Erklärung

Frage 14 von 30

1

What is the SAP recommended naming convention for append structures of standard SAPtables?
Please choose the correct answer.

Wähle eine der folgenden:

  • The components of an append structure should start with ZZ or YY.

  • The name of the append structure must start with ZA.

  • The name of the append structure must start with ZZ or YY.

  • The components of an append structure should start with Z or Y.

Erklärung

Frage 15 von 30

1

What are the prerequisites when creating an append structure for a standard SAP table?
There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • The table must be copied before the append structure can be created

  • The fields in the append structure should star with YY or ZZ

  • The enhancement category of the table is NOT set to ‘Not enhacable’

  • The table cannot have any fields of type FLTP

Erklärung

Frage 16 von 30

1

Which ABAP statement using the local type gty_1 correctly defines a data object?
There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • DATA gv_1 TYPE gty_1.

  • DATA gv_1 TYPE gty_1 DEFAULT '1'.

  • CONSTANTS gc_1 TYPE gty_1 VALUE '1'

  • DATA gv_1 LIKE gty_1.

Erklärung

Frage 17 von 30

1

Which of the following can you do with the ABAP debugger?
There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • Compare data objects.

  • Analyze memory usage.

  • Change source code

  • Analyze internal tables

  • Analyze SQL traces.

Erklärung

Frage 18 von 30

1

The order of fields for a transparent table in the database…
Please choose the correct answer.

Wähle eine der folgenden:

  • Is created in the order of the Data Dictionary.

  • Is created in the order of the ABAP Dictionary.

  • Needs to match the ABAP Dictionary.

  • Is allowed to be different than the ABAP Dictionary.

Erklärung

Frage 19 von 30

1

In the technical settings for a transparent table, buffering is switched on and single record buffering is selected.
Which statement uses the buffered data assuming that the WHERE clause contains restrictions for all key fields?
Please choose the correct answer.

Wähle eine der folgenden:

  • SELECT … . ENDSELECT.

  • SELECT SINGLE …

  • SELECT … INTO TABLE …

  • SELECT SINGLE … FOR UPDATE

Erklärung

Frage 20 von 30

1

What do you have to take into account before you decide to buffer a table?
Please choose the correct answer.

Wähle eine der folgenden:

  • The entire table content must be loaded into the table buffer

  • The database server must allow table buffering

  • The data read from the buffer may NOT be current

  • The data must always be read from the buffer

Erklärung

Frage 21 von 30

1

What will happen at runtime when accessing a buffered table?
Please choose the correct answer.

Wähle eine der folgenden:

  • Following an update to a buffered record, all table buffers in the system will be updated.

  • If table data is read using indexes, the table buffer will not be filled.

  • All SELECT statements will read data from the buffer.

  • If data is read from the table buffer, the existing indexes are not used.

Erklärung

Frage 22 von 30

1

In which circumstances is a table considered to be a text table?
There are 3 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • The ABAP runtime system determines that the relationship exists.

  • This table has a foreign key to the data table as a text table.

  • This table only has one character-based data field.

  • The entire key of this data table is included as the key to this table.

  • This table has an additional language key field.

Erklärung

Frage 23 von 30

1

A transport company keeps track of this availability in two tables, table VEHICLES and table TRANSPORT. To accept a new transport of a certain capacity must be found in table VEHICLES. If a record is found, a record is created in table TRANSPORT. The capacity is then adjusted in table VEHICLES.\

You have four function modules at your disposal.

UPD_VEHI_A and UPD_VEHI_B update a matching report in table VEHICLES. If an error occurs both issue a message of type X. If no error occurs only UPD_VEHI_A issues a message of type X. If no error occurs UPD_VEHI_A issues a message of type I.

UPD_TRAN_A and UPD_TRAN_B create a single record in table TRANSPORT. If an error occurs both issues a message of type X. If no error occurs only UPD_TRAN_A issues a message of type I.

Which of the following function module calls ensures a single logical unit of work?
Please choose the correct answer.

Wähle eine der folgenden:

  • 1.UPD_VEHI_A
    2.UPD_TRAN_B

  • 1. UPD_TRAN_A
    2. UPD_VEHI_B

  • 1. UPD_TRAN_B
    2. UPD_VEHI_B

  • 1.UPD_VEHI_A
    2.UPD_TRAN_A

Erklärung

Frage 24 von 30

1

You run an executable program which contains the following code:

DATA: gv_var1 TYPE n LENGTH 3,
Gv_var2 TYPE n LENGTH 3 VALUE ‘456’.
START-OF-SELECTION
CLEAR gv_var2
Gv_var2 = gv_var1.
Gv_var1 = ‘123’.

At what point does the system reserve memory for the data object gv_var1?

Please choose the correct answer.

Wähle eine der folgenden:

  • At the beginning of the START-OF-SELECTION event block

  • When the assignment to gv_var2 is executed

  • When the value ‘123’ is assigned to the data object

  • As soon as the program is loaded into thie internal session

Erklärung

Frage 25 von 30

1

You created a transparent table and during activation got a warning message "Enhancement category for table missing".
What do you have to do to eliminate the warning message?
Please choose the correct answer.

Wähle eine der folgenden:

  • Change the Data Class and Size category in the technical settings.

  • Provide the correct reference field for the Currency or Quantity field.

  • Select the option Not Classified from the enhancement category.

  • Select any option other than Not Classified from the enhancement category

Erklärung

Frage 26 von 30

1

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

Wähle eine oder mehr der folgenden:

  • A database view can be buffered

  • An outer join can only be implemented in a database view

  • A secondary index can be created for a database view

  • A database view can be reused in other programs

Erklärung

Frage 27 von 30

1

Which elementary field types are considered a character type?
There are 5 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • N

  • T

  • I

  • X

  • XSTRING

  • C

  • D

  • STRING

  • F

Erklärung

Frage 28 von 30

1

Table A and table B are partially buffered.
Which of the following SELECT statements always access the database?
There are 2 correct answers to this question.

Wähle eine oder mehr der folgenden:

  • SELECT SINGLE FOR UPDATE a b FROM table A INTO CORRESPONDING FIELDS OF ls_A WHERE c EQ ‘1234’.

  • SELECT a b c d FROM table A JOIN table B ON table A~a EQ table B~
    eINTO CORRESPONDING FIELDS OF TABLE lt_A_B.

  • SELECT a b FROM table A INTO CORRESPONDING FIELDS OF TABLE lt_AB

  • SELECT SINGLE CLIENT SPECIFIED a b FROM table A
    INTO CORRESPONDING FIELDS OF ls_AB.

Erklärung

Frage 29 von 30

1

Where are fixed values for fields stored?
Please choose the correct answer.

Wähle eine der folgenden:

  • Data element

  • Field

  • Domain

  • Structure

  • Table

Erklärung

Frage 30 von 30

1

What do you need to consider when creating a secondary index on a table?
There are 2 correct answers to this question

Wähle eine oder mehr der folgenden:

  • The most frequently selected fields should be at the first positions in the index

  • The index can be created for specific database systems only

  • The table will be updated more quickly if you create more indexes

  • The index must always be unique

Erklärung