Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

• A.Data Manipulation Language (DML)
• B.The Data Control Language (DCL)
• C.Data Evaluation Language(DEL)
• D.Data Transferring Language(DTL)
• E.The Data Definition Language (DDL)

Comment: *

Name: *

Email: *

Verification: *

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

• A.All arithmetic expressions can be used for all type of variables
• B.All Keywords are case sensitive.
• C.All fields in the GROUP BY clause must be separated by commas.
• D.All ABAP variables must be escaped with a proceeding @ sign.

Comment: *

Name: *

Email: *

Verification: *

You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential.
Which Code Inspector check variant can you use?

• A.FUNCTIONAL_DB
• B.PERFORMANCE_DB
• C.PERFORMANCE_OPT
• D.CHECK_PERFORMANCE

Comment: *

Name: *

Email: *

Verification: *

You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

• A.:it_books
• B.it_books
• C.{it.books}
• D.@it_books

Comment: *

Name: *

Email: *

Verification: *

You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node:

• A.AT Vienna 11
  AT Vienna 15
  DE Berlin 13
• B.AT Vienna 26
  DE Berlin 26
• C.AT Vienna 11
  DE Berlin 13
• D.AT Vienna 11
  AT Vienna 15
  DE Berlin 13
  DE Berlin 13

Comment: *

Name: *

Email: *

Verification: *