Free Cram & Latest Exams Dumps

Q16. Which of the following tools and programming techniques use the SQL Data Definition Language? Note: There are 2 correct answers to this question.

Q17. You use ABAP Database Connectivity (ADBC) to issue native SQL calls to the database. Which method of class CL_SQL_RESULT_SET retrieves the entire result set of the native SQL call?

Q18. What is the purpose of an ABAP project in ABAP Development Tools for Eclipse? Note: There are 2 correct answers to this question.

Q19. You have created a CDS view as follows: define view zha400 as
select from spfli association^] to sflight as_flights on
spfli.carrid = _flights.carrid and spfli.connid = _flights.connid { … } Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?

Q20. What are some of the features available for SAP List Viewer with Integrated Data Access (ALV IDA)? Note: There are 3 correct answers to this question.

Q21. You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

Q22. Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA? Note: There are 2 correct answers to this question.

Q23. You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? Note: There are 2 correct answers to this question.

Q24. Which of the following repository objects can you edit only in ABAP Development Tools in Eclipse, and NOT in the classical ABAP Workbench? Note: There are 3 correct answers to this question.

Q25. You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? Note: There are 2 correct answers to this question.

Q26. Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer? Note: There are 2 correct answers to this question.

Q27. User STUDENT_A creates and activates a design-time object. In which schema is the runtime object generated?

Q28. You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? Note: There are 3 correct answers to this question.

Q29. Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? Note: There are 3 correct answers to this question.

Q30. How many result sets are returned when an SAP HANA database procedure is called using the CALL…WITH OVERVIEW statement?

Q31. You import an ABAP workbench request into an SAP system P81. The ABAP workbench request contains a single SAP HANA view CA_CUSTOMER that belongs to SAP HANA content package ZHA400_00. Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database? Note: There are 2 correct answers to this question.