When the base table is dropped what gets deleted automaticallya.All Tablesb.normalized tablesc.Materialized Viewd.View

When a base table is dropped, the dependent objects such as Views and Materialized Views get deleted automatically.

Here's a step-by-step explanation:

1. A base table is the main table in the database. It holds the data that other database objects (like views and materialized views) refer to.

2. A View is a virtual table based on the result-set of an SQL statement. It contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

3. A Materialized View, on the other hand, is a physical copy, snapshot or a replica of the base table. It contains the result set of a query, not just the SQL.

4. When you drop the base table, the views and materialized views that depend on it become invalid because they refer to a table that no longer exists. Therefore, they are automatically deleted.

5. Normalized tables and all other tables are not automatically deleted when a base table is dropped. They are independent objects and their existence does not depend on the base table.

So, the correct answer to your question is: When the base table is dropped, the Materialized View and View get deleted automatically.