Write an SQL query to extract the following information from data dictionary:

For each question you need to submit query and screenshot with results.

Start Oracle SQL Developer

Use SELECT * FROM dictionary; to find all available dictionary views.

Find all dictionary views that contain information about indexes.

How many indexes are defined on DVSYS.RULE_SET_RULE$ table? (Hint: all views have meaningful name, just search the page)

For each index you found in #3 how many distinct keys?

Use V$...stat views to find information about "free memory" and "DB time"

Hint: DB time is system parameter free memory is SGA (System Global Area) parameter

From your standpoint what is the most useful Oracle data dictionary view/table/procedure. Describe it and provide examples.

Include your code and results of the execution