Глава восьмая 8

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.