This Oracle document describes the Oracle Data Dictionary. It may be a bit dated but it provides the basics of the Oracle DD.

https://docs.oracle.com/cd/B10501_01/server.920/a96524/c05dicti.htm

Name the 8 important parts of the Oracle DD.

1.

2.

3.

4.

5.

6.

7.

8.

What are the two main structures used in the Oracle DD?

1.

2.

How does Oracle use the DD?

1.

2.

3.

What are the prefixes to three Oracle DD views?

1.

2.

3.

The Oracle DD consists of dozens or hundreds of tables/views.

Run this query in the APEX SQL Commands Tool.

select count(*) from dictionary;

How many tables/views are there?

We are only concerned about the USER views.

Run this query in APEX to see how many there are:

select * from dictionary where table_name like 'USER_%';

Using the USER_OBJECTS view, write a query to list counts of Object_Types.

List: Object Type name and Count.

Place your query here.

Using the USER_TABLES view, list the tables in our database. Sort by table name.

Place your query here.

Using the USER_COL_COMMENTS view, determine how many columns are in our DB.

Place your query here.

Select two other USER_ views, describe what they do and select some rows from them.

Place your queries here.

2