SAP_ABAP_PA题例（1~15）

Exam A

QUESTION 1

Table USER has the following fields: ID, FIRST_NAME, LAST_NAME. FIRST_NAME and LAST_NAME have a same basic type and length. You want to compare fields FIRST_NAME and LAST_NAME to each other. Which of the following SELECT statements can you use?

1. SELECT * FROM users INTO TABLE lt_users AS a WHERE first_name = users~last_name.
2. SELECT * FROM users INTO TABLE lt_users WHERE first_name = users~last_name.
3. SELECT * FROM users INTO TABLE lt_users WHERE first_name = users~last-name.

Answer: BC

Section: ( none )

QUESTION 2

tableA and tableB are partially buffered. Which of the following SELECT statements always access tha database?

1. SELECT SINGLE CLIENT SPECIFIELD a b FROM tableA INTO CORRESPONDING FIELDS OF Is_A_B
2. SELECT abed FROM tableA JOIN tableB ON tableA~a = tableB~e INTO CORRESPONDING FIELDS OF TABLE It_A_B
3. SELECT SINGLE FOR UPDATE a b FROM tableA INTO CORRESPONDING FIELDS OF Is_A_B WHERE c EQ'1234'.
4. SELECT a b FROM tableA INTO CORRESPONDING FIELDS OF TABLE It_A_B

Answer: BC

Section: ( none )

QUESTION 3

When are changes to the VB* tables transferred to the database?

1. When the main program is executed
2. When the enqueuer work process is executed
3. When an update function module is executed
4. When the update work process is executed

Answer: D

Section: ( none )

QUESTION 4

You want to select all record from a database table where field City contains substring 'BIT in any position. Which WHERE clause can you use in an Open SQL statement?

1. WHERE city LIKE '*BU*'
2. WHERE city LIKE '+BU+'
3. WHERE city LIKE '_BU_'
4. WHERE city LIKE '%BU%'

Answer: D

Section: ( none )

QUESTION 5

You count all customers within the same country and city. You want to display only the cities where three ar more customers exist. Which of the following SQL statements should you use?

1. SELECT country city COUNT(*) AS number FROM customers INTO TABEL it_customers GROUP BY country city HAVING number GE 3.
2. SELECT country city FROM customers INTO TABEL it_customers GROUP BY country city HAVING COUNT(*) >=

3.

1. SELECT country city cust_name COUNT(*) AS number FROM customers INTO TABEL it_customers GROUP BY country city HAVING number >= 3.
2. SELECT country city cust_name FROM customers INTO TABEL it_customers GROUP BY country city HAVING COUNT(*) GE 3.

Answer: AB

Section: ( none )

QUESTION 6

You want to create a transparent table in the ABAP dictionary. When is the table physically created in the database?

1. When you activate the table
2. When you run the database utility transaction (SE14)
3. When you insert the table name ans select Create
4. Whe you save the table

Answer: A

Section: ( none )

QUESTION 7

Which view types can you to join two tables with an outer join?

1. Maintenance view
2. Database view
3. Projection view
4. Help view

Answer: AD

Section: ( none )

QUESTION 8

When does SAP recommended that you use a hashed table?

1. When a table must to sorted automatically by key in ascending order
2. When a table is very large and you want to access the table by key only
3. When a table is very large and you want to access the table by index only
4. When a table must be accessible by both index and key

Answer: B

Section: ( none )

QUESTION 9

How can you define an internal table in a private method of a class?

1. DATA It_itab TYPE TABLE OF .
2. DATA It_itab TYPE TABLE OF .
3. DATA It_itab TYPE .
4. DATA It_itab TYPE < Table Type>.
5. DATA It_itab TYPE TABLE OF WITH HEADER LIN

Answer: ABD

Section: ( none )

QUESTION 10

You want to create a transparent table. Which of the followih=ng must you define to activate the table?

1. A delivery class
2. A foreign key
3. The primary key
4. The MANDT field
5. A short description

Answer: ACE

Section: ( none )

QUESTION 11

Which of the following are valid control level changes within a loop over an internal table?

1. COLLECT
2. LAST
3. END OF
4. SUM

Answer: BC

Section: ( none )

QUESTION 12

In an ABAP Program, you want to assign an initial value to an elementary data object when you define it. Which addition must you use?

1. VALUE
2. DEFAULT
3. OBLIGATORY
4. READ-ONLY

Answer: A

Section: ( none )

QUESTION 13

Which of the following structures is created when you use a table type to define one of its components?

1. Deep structure
2. Nested structure
3. Flat structure
4. Append structure

Answer: A

Section: ( none )

QUESTION 14

You created the following ABAP code: DATA x TYPE REF TO DATA. DATA y TYPE REF TO OBJECT. ASSIGN x TO < fs>. ASSIGN y TO <fs>. You want to add a declaration of <fs> to the code. Which of the following declarations are valid?

1. FIELD-SYMBOLS TYPE REF TO DAT
2. FIELD-SYMBOLS TYPE any.
3. FIELD-SYMBOLS .
4. FIELD-SYMBOLS TYPE REF TO ANY.

Answer: BC

Section: ( none )

QUESTION 15

Which of the following are fully-specified internal table types?

1. Standard
2. Any
3. Index
4. Hashed

Answer: AD

Section: ( none )