Introducing SQLScript for SAP HANA
Analyzing Queries
Expanding Queries
Creating and Populating Tables and Views
Identifying the Purpose of Database Transactions and Isolation Requirement
Implementing Imperative and Declarative Logic
Describing Functions and Procedures
Analyzing Temporal Tables and SAP HANA Hierarchies
Using Tools and Views for Analysis and Optimization

Knowledge quiz

It's time to put what you've learned to the test, get 4 right to pass this unit.

1.

When altering a table to add a column, which of the following is true?

There are two correct answers.
2.

If a view is defined on a join of tables, then an INSERT or DELETE on the view will modify each of the underlying tables.

Choose the correct answer.
3.

Like the INSERT command without a subquery, the UPDATE and DELETE commands can only act on one row at a time.

Choose the correct answer.
4.

You wish to create a unique index on a column that contains duplicate values. Which of the following is true?

Choose the correct answer.
5.

A user initially has no access to a given table, and is the grantee of following permission commands in the order shown: GRANT SELECT ON ‹table_name› TO ‹user›; GRANT SELECT, INSERT ON ‹table_name› TO ‹user›; REVOKE SELECT, INSERT, DELETE, UPDATE ON ‹table_name› FROM ‹user›;. Which of the following is true?

Choose the correct answer.
Learning

SAP FacebookSAP YoutubeSAP LinkedIn