CSE 232A Graduate Database Systems Arun Kumar Review Discussion - - PowerPoint PPT Presentation

1

Review Discussion

CSE 232A
 Graduate Database Systems

Arun Kumar

2

Review Question

A B C D

Shared-disk Shared-memory Shared-nothing None of the above Which of the following parallelism paradigms is making a “comeback” in the cloud-native RDBMS setting thanks to faster networks?

3

Review Question

A B C D

PL/SQL Streaming queries UDTs and UDFs None of the above Which of the following capabilities help RDBMSs handle more complex objects than simple SQL data types?

4

Review Question

A B C D

Massively parallelizing computations Upsizing and downsizing resources dynamically Tolerating machine failures dynamically None of the above What is resource elasticity?

5

Review Question

Which relational operator’s data access pattern is closest to that of gradient descent?

A B C D

PROJECT JOIN GROUP BY SUM GROUP BY MEDIAN

6

Review Question

Which of the following ML-for-RDBMS capabilities is aimed at reducing user effort to specify database queries?

A B C D

Learned index structures Learned query optimizers Automated configuration tuning Natural language interfaces