Online Access Free E-HANAAW-18 Exam Questions

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

• A.Core Data Services (CDS) data definition
• B.Core Data Services (CDS) access control
• C.Open SQL
• D.ABAP Dictionary

Which of the following features were added to the ABAP dictionary to support the SAP HANA database? Note: There are 3 correct answers to this question.

• A.De-pooling and de-clustering
• B.Storage type for tables
• C.Definition of enhancement category
• D.Change of data class
• E.Definition of full-text indexes

You analyze SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its dat a. But the relevant database access is NOT listed in SQLMD. What could be the reason? Note: There are 3 correct answers to this question.

• A.SQL Monitor was activated for a specific application server.
• B.The data has NOT yet been transferred to the SQL Monitor database tables.
• C.Program X was executed in the background.
• D.SQL Monitor was activated with a filter that excludes database table Y.
• E.Database table Y is a buffered table.

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?

• A.Direct access to Table Pools/Cluster
• B.Missing ORDER BY or SORT after SELECT
• C.Existence check for Secondary Indexes
• D.Use of Native SQL and DB Hints

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

• A.One result set
• B.As many result sets as there are table output parameters in the procedure
• C.As many result sets as there are input parameters in the procedure
• D.Two result sets