Question

1. The example of an SQL statement that cannot be “rollback’ed” is ________________________.

2. _________ partitioning of a relation corresponds to distributing the tuples across disks.

Answer 1

1.
The example of an SQL statement that cannot be “rollback’ed” is commit
COMMIT statement makes all the modification made by the current transaction become permanent
Answer:
COMMIT

2.
Data partitioning of a relation corresponds to distributing the tuples across disks.
Answer:
Data 

Answer 2

• The example of an SQL statement that cannot be "rollback'ed" is a DDL (Data Definition Language) statement. DDL statements are used to define or modify the structure of a database, such as creating or altering tables, indexes, or constraints. Once a DDL statement is executed, it cannot be rolled back, and any changes made by the statement are permanent.

• Horizontal partitioning of a relation corresponds to distributing the tuples across disks. Horizontal partitioning, also known as row partitioning, involves dividing a table into multiple smaller tables based on rows. Each smaller table contains a subset of the original table's rows. The purpose of horizontal partitioning is to distribute the data across different disks or servers to improve performance and scalability.