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?
SELECT * FROM users INTO TABLE lt_users AS a WHERE first_name = users~last_name.SELECT * FROM users INTO TABLE lt_users WHERE first_name = users~last_name.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?
SELECT SINGLE CLIENT SPECIFIELD a b FROM tableA INTO CORRESPONDING FIELDS OF Is_A_BSELECT abed FROM tableA JOIN tableB ON tableA~a = tableB~e INTO CORRESPONDING FIELDS OF TABLE It_A_BSELECT SINGLE FOR UPDATE a b FROM tableA INTO CORRESPONDING FIELDS OF Is_A_B WHERE c EQ'1234'.SELECT a b FROM tableA INTO CORRESPONDING FIELDS OF TABLE It_A_BAnswer: BC
Section: ( none )
QUESTION 3
When are changes to the VB* tables transferred to the database?
When the main program is executedWhen the enqueuer work process is executedWhen an update function module is executedWhen the update work process is executedAnswer: 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?
WHERE city LIKE '*BU*'WHERE city LIKE '+BU+'WHERE city LIKE '_BU_'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?
SELECT country city COUNT(*) AS number FROM customers INTO TABEL it_customers GROUP BY country city HAVING number GE 3.SELECT country city FROM customers INTO TABEL it_customers GROUP BY country city HAVING COUNT(*) >=3.
SELECT country city cust_name COUNT(*) AS number FROM customers INTO TABEL it_customers GROUP BY country city HAVING number >= 3.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?
When you activate the tableWhen you run the database utility transaction (SE14)When you insert the table name ans select CreateWhe you save the tableAnswer: A
Section: ( none )
QUESTION 7
Which view types can you to join two tables with an outer join?
Maintenance viewDatabase viewProjection viewHelp viewAnswer: AD
Section: ( none )
QUESTION 8
When does SAP recommended that you use a hashed table?
When a table must to sorted automatically by key in ascending orderWhen a table is very large and you want to access the table by key onlyWhen a table is very large and you want to access the table by index onlyWhen a table must be accessible by both index and keyAnswer: B
Section: ( none )
QUESTION 9
How can you define an internal table in a private method of a class?
DATA It_itab TYPE TABLE OF .DATA It_itab TYPE TABLE OF .DATA It_itab TYPE .DATA It_itab TYPE < Table Type>.DATA It_itab TYPE TABLE OF WITH HEADER LINAnswer: ABD
Section: ( none )
QUESTION 10
You want to create a transparent table. Which of the followih=ng must you define to activate the table?
A delivery classA foreign keyThe primary keyThe MANDT fieldA short descriptionAnswer: ACE
Section: ( none )
QUESTION 11
Which of the following are valid control level changes within a loop over an internal table?
COLLECTLASTEND OFSUMAnswer: 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?
VALUEDEFAULTOBLIGATORYREAD-ONLYAnswer: A
Section: ( none )
QUESTION 13
Which of the following structures is created when you use a table type to define one of its components?
Deep structureNested structureFlat structureAppend structureAnswer: 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 . You want to add a declaration of to the code. Which of the following declarations are valid?
FIELD-SYMBOLS TYPE REF TO DATFIELD-SYMBOLS TYPE any.FIELD-SYMBOLS .FIELD-SYMBOLS TYPE REF TO ANY.Answer: BC
Section: ( none )
QUESTION 15
Which of the following are fully-specified internal table types?
StandardAnyIndexHashedAnswer: AD
Section: ( none )