ABAP on Cloud Certification: Internal Table Types and Secondary Keys

AgreeableBay avatar
AgreeableBay
·
·
Download

Start Quiz

Study Flashcards

22 Questions

What is the correct order of the conditions mentioned in the text?

a is joined with b, b is joined with c

What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key?

Validation

In RESTful Application Programming, which EML statement retrieves an object?

Read entity

According to the provided code, what is the status of the function module 'ZF1' in the SAP SIAHANA Cloud, private edition?

'ZF1' must be released for cloud development to be called

In the statement 'Target_itab = VALUE #( FOR row IN source itab( Field1 = row-field1 Field2 = row-field2 Fieldn = row-fieldn ) )', what is the purpose of 'FOR'?

To define a loop running over 'source_itab'

What happens to the visibility of 'source_itab' outside the loop in the given statement?

It remains visible only within the loop

Which ABAP function call will return 0?

Count(val - 'ABAP ABAP abap' sub - 'AB')

Which statement can be used to change the contents of a row of data in an internal table?

Modify table

Which RESTful Application Programming object is used to organize the display of fields in an app?

Projection view

In which scenario would an exception be raised based on the given patterns?

Extracting a string segment that exceeds the length of the string

Which internal table type allows both unique and non-unique keys?

Standard

Which of the following statements about secondary keys for internal tables is correct?

Multiple secondary keys are allowed for any table type.

What is an advantage of using Core Data Services over the classical approach to data modeling?

They implement code pushdown.

Which ABAP SQL clause allows the use of inline declarations?

INTO CORRESPONDING FIELDS OF

Which of the following is a valid syntax for accessing the connid field of the demo_ods_assoc_spfli internal table?

demo_ods_assoc_spfli-connid

In which order are tables joined in a multi-table join operation?

From left to right in the order of the tables.

What is the purpose of using Access Controls with CDS Views?

All of the above

Which statements are valid regarding the use of interfaces in classes?

All of the above are valid statements

In the provided code snippet, what is the purpose of the RAISE EXCEPTION statement?

The code creates an exception object and raises an exception

Which of the following ON conditions should be used in the provided code snippet?

ON $projection.Carrier = _Source2.carrier_id

In the context of ABAP programming, what is the purpose of the sy-subrc system field?

It represents the return code of the most recently executed ABAP statement

What is the purpose of the AUTHORITY CHECK statement in ABAP programming?

To check if the current user has the required authorization for a specific action

Study Notes

Assignment and Data Declarations

  • gv_target can be assigned without truncation or rounding if gv_source is of type string and gv_target is of type c.
  • gv_target can be assigned without truncation or rounding if gv_source is of type d and gv_target is of type string.
  • gv_target can be assigned without truncation or rounding if gv_source is of type p length 8 decimals 3 and gv_target is of type p length 16 decimals 2.

RESTful Application Programming

  • Validation is a feature used to ensure the uniqueness of a semantic key.
  • The EML statement that retrieves an object is Get entity.

ABAP SQL

  • An alias can be assigned to a field from a field list.
  • An alias can be assigned to a group criterion from a group by clause.

Inheritance in ABAP

  • To redefine a component of a superclass in a subclass, add the REDEFINITION clause to the component in the subclass.
  • The redefined component must be implemented in the subclass.

Access Controls with CDS Views

  • Access Controls with CDS Views ensure that only data corresponding to the user's authorization is transferred from the database to the application layer.
  • Access Controls with CDS Views eliminate the need to implement AUTHORITY CHECK statements.

Interfaces in ABAP

  • A class can use an interface.
  • A class can implement an interface.
  • In a class, an interface method can be named if1-ml.

Exception Handling

  • RAISE EXCEPTION TYPE can be used to raise an exception.
  • A dictionary structure can be used to pass parameters to an exception.
  • The code creates an exception object and raises an exception.

Join Conditions

  • ON conditions can be used to specify join conditions.
  • ON $projection Carrier = _Source2.Carrier is a valid join condition.
  • ON Z_Sourcel.carrier_id = _Source2.carrier_id is a valid join condition.

ABAP Types

  • String is an incomplete ABAP type.
  • P is an incomplete ABAP type.

CDS Views

  • They store information in two dimensions.
  • They can have key fields.

Class Definition

  • A class can be defined with a method.
  • A method can call a function.

Internal Tables

  • Target_itab = VALUE #( FOR row IN source_itab ( Field1 = row-field1 Field2 = row-fiel2 Fieldn = row-fieldn ) ) is a valid statement.
  • FOR defines a loop that runs over the content of source_itab.
  • row is only visible within the loop.

Function Calls

  • Count_any_of returns the number of occurrences of a substring.
  • Count returns the number of characters in a string.
  • Find_any_of returns the position of the first occurrence of a substring.

Data Modification

  • MODIFY TABLE can be used to change the contents of a row in an internal table.

RESTful Application Programming

  • A Data model view can be used to organize the display of fields in an app.
  • A Projection view can be used to organize the display of fields in an app.

Exception Patterns

  • Assigning a date value to a decimal variable raises an exception.
  • Assigning a string value to a char variable raises an exception.
  • Dividing by zero raises an exception.

Internal Tables

  • A hashed internal table allows unique and non-unique keys.
  • A sorted internal table allows unique and non-unique keys.

Secondary Keys

  • Secondary keys must be chosen explicitly when reading from an internal table.
  • Multiple secondary keys are allowed for any kind of internal table.
  • Hashed secondary keys do not have to be unique.

Core Data Services

  • They implement code pushdown.
  • They avoid data transfer completely.

ABAP SQL

  • The INTO clause allows the use of inline declarations.
  • The INTO CORRESPONDING FIELDS OF clause allows the use of inline declarations.
  • The FIELDS clause allows the use of inline declarations.

Test your knowledge of ABAP on Cloud certification topics with questions about internal table types and secondary keys. Questions cover unique and non-unique keys, characteristics of secondary keys, and more.

Make Your Own Quizzes and Flashcards

Convert your notes into interactive study material.

Get started for free

More Quizzes Like This

ABAP CDS and SAP List Viewer Quiz
5 questions
ABAP Programming Language
5 questions
SAP Cloud Platform ABAP Environment Essentials
30 questions
Use Quizgecko on...
Browser
Browser