Which SQL statements are available in Autonomous Database Warehouse (ADW)?

Autonomous Database Warehouse (ADW) operates in a cloud environment where many system management tasks are automated. As part of this automation, certain administrative SQL statements that are typically used in traditional relational databases, such as creating, altering, or managing tablespaces, are not available to users.

The SQL statements related to tablespace management, like ALTER TABLESPACE and CREATE TABLESPACE, are generally reserved for the database infrastructure itself. This design ensures that the underlying environment remains optimized and prevents users from inadvertently making changes that could impact performance or stability.

By choosing that none of the options are valid SQL statements in the context of ADW, it reflects an understanding of the platform's architecture and its focus on simplifying database management for users. Users of ADW are encouraged to focus on data analysis and application development without the need to manage hardware or database structure fundamentally, thus enabling faster deployment and greater agility.