Online Access Free C-ABAPD-2507 Exam Questions

Given the following ABAP SQL statement excerpt from an ABAP program:
SELECT SINGLE *
FROM spfli
WHERE carrid = 'LH' AND connid = '0400'
INTO @DATA(wa).
You are given the following information:
* The data source spfli on line #2 is an SAP HANA database table.
* spfli will be a large table with over one million rows.
* This program is the only one in the system that accesses the table.
* This program will run rarely.
Based on this information, which of the following general settings should you set for the spfli database table?
Note: There are 2 correct answers to this question.

• A."Load Unit" to "Column Loadable"
• B."Storage Type" to "Column Store"
• C."Load Unit" to "Page Loadable"
• D."Storage Type" to "Row Store"

In a subclass sub1, you want to redefine a component of a superclass super1.
How do you achieve this?
Note: There are 2 correct answers to this question.

• A.You add the clause REDEFINITION to the component in super1.
• B.You implement the redefined component in sub1.
• C.You implement the redefined component for a second time in super1.
• D.You add the clause REDEFINITION to the component in sub1.

Which of the following rules apply for dividing with ABAP SQL?
Note: There are 3 correct answers to this question.

• A.Numeric function division( numerator, denominator, decimal places ) accepts decimal input.
• B.The division operator "/" accepts floating point input.
• C.Numeric function division( numerator, denominator, decimal places ) accepts floating point input.
• D.Numeric function div( numerator, denominator ) expects only integer input.
• E.The division operator "/" accepts decimal input.

Which of the following pre-defined ABAP data types is a complete data type?

• A.d
• B.p
• C.n
• D.c

Given the following Core Data Service View Entity Data Definition:
@AccessControl.authorizationCheck: #NOT_REQUIRED
DEFINE VIEW ENTITY demo_flight_info_union AS
SELECT FROM scustom {
KEY id,
KEY 'Customer' AS partner,
name,
city,
country
}
UNION
SELECT FROM stravelag {
KEY agencynum AS id,
'Agency' AS partner,
name,
city,
country
}
When you attempt to activate the definition, what will be the response?

• A.Activation error because the field types of the union do not match
• B.Activation error because the field names of the union do not match
• C.Activation successful
• D.Activation error because the key fields of the union do not match