What paradigm describes the SQL language? Set-oriented Object-oriented Procedural Application-focused. To what subset of SQL does the SELECT statement belong? DML DDL DCL DQL. True or False: Delimited identifiers are treated as case-sensitive. True False. What is used in SQL to indicate that there is no value? Zero Empty quotes NULL Spaces. You want to use a table to store results for each session but do not want to
recreate the table for every session. What type of table should you create? History column table Global temporary table Local temporary table Virtual table. What character is used to terminate SQL statements? ? (question mark) : (colon) ; (semicolon) . (period). What SELECT statement is not recommended for use with column tables? SELECT * SELECT with a time-travel clause SELECT ALL SELECT in a subquery. True or False: A union returns all values in a result set, even duplicate
records. True False. What character is prepended to a SQLScript variable when it is used as an
input variable? ! (exclamation mark) : (colon) _ (underscore & (ampersand). What should you keep in mind when using imperative logic in SQLScript? It delivers the best possible performance. You can only use if-then logic. You can loop through records. It matches SQL’s set-oriented paradigm. What should you keep in mind when using dynamic SQL? (There are 2 correct answers.) It is always bad for security. It could be used for SQL injection. You can dynamically change your data sources. It delivers the best possible performance. You created a user-defined function with a return type of BIGINT. What type
of function have you created? SQL function Scalar function Table function Window function. In which programming languages can you create procedures in SAP HANA?
(There are 2 correct answers.) SQLScript L JavaScript R. You created a user-defined function with the INVOKER security option.
Which user’s authorizations are checked when the function is executed? The owner of the function The _SYS_REPO user The SYSTEM user The user calling the function. You created a procedure without defining the security option. Which user’s
authorizations are checked when the procedure is executed in production? The user calling the function The system administrator that transported the procedure The _SYS_REPO user The developer that created the procedure. What is the preferred way to create a procedure? Use the CREATE PROCEDURE statement in the SQL Console. Create a .procedure file. Create a .hdbprocedure file. Use the context menu of a package. With which statement can you call a table function? (There are 2 correct
answers.) CALL INSERT INTO SELECT EXEC. What statement is allowed in a user-defined function? COMMIT EXEC INSERT JOIN. You want to call a procedure in a SELECT statement (like a table function).
Which clauses do you have to specify? (There are 2 correct answers.) LANGUAGE SQLSCRIPT WITH RESULTS VIEW SEQUENTIAL EXECUTION READS SQL DATA. What statement do you have to run before you can return table results from
a procedure? CREATE TABLE TYPE CREATE TYPE CREATE TABLE CREATE VIEW. What SQL construct do you use to return multiple result sets from a single
SQL statement? GROUPING SETS SELECT subquery JOIN UNION. What can be used to return multiple result sets? Scalar function Table function Procedure View. What should you keep in mind about user-defined functions? They can use imperative logic. They can commit transactions. They can use dynamic SQL. They can call procedures. What should you keep in mind about procedures? (There are 3 correct answers.) They can call views. They are NOT open to SQL injection. They must return values. They may have input parameters. They can call table functions. What is a new and recommended way to work with SQL and SQLScript? Use CE-functions rather than SQL syntax. Use .procedure files rather than creating SQL and SQLScript via the package
context menu. Use table functions rather than scripted calculation views. Create runtime objects rather than design-time objects. Which tasks are part of the migration tool workflow? (There are 2 correct answers.) The tool requires a graphical calculation view as input. The tool requires a script-based calculation view as input. The tool produces only a table function. The tool produces a table function linked to a graphical calculation view.
