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 6 right to pass this unit.

1.

What is the difference between GROUP BY CUBE and GROUP BY ROLLUP?

Choose the correct answer.
2.

Which of the following is correct when combining the result sets of multiple queries using UNION?

There are three correct answers.
3.

In a left outer join, what happens to the rows in the left table without a matching row in the right table?

Choose the correct answer.
4.

In a SELECT with an OVER() clause, which of the following statements are true?

There are two correct answers.
5.

What kind of subquery can be evaluated independently of the outer query?

Choose the correct answer.
6.

If the current row has a value of 5000 and the three preceding rows have a value (in order) of 1000, 1500, and 3000, which rows would be included in RANGE BETWEEN 3500 PRECEDING AND CURRENT ROW?

Choose the correct answer.
7.

If the current row has a value of 5000 and the three preceding rows have a value (in order) of 1000, 1500, and 3000, which rows would be included in ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING?

Choose the correct answer.
Learning
SAP FacebookSAP YoutubeSAP LinkedIn