Every Oracle database uses a number of system tables and views to keep track of database objects in the database. This collection of system objects (tables and views) is called data dictionary or system catalog. Data dictionary is an effective tool to find out about information on database objects in the database.

This week's discussion focuses on applications of data dictionary.

1. If you want to know which tables exist in PRACTICE07 schema after you complete the study of chapter 7, which data dictionary view will be the best to query?
2. Provide a SQL query to find out the names of existing tables?
3. What is the difference between DBA_TABLES, ALL_TABLES and USER_TABLES?
4. What is the difference between USER_TABLES and USER_OBJECTS?

Please make sure to answer each of the question.

School of Technology
College of Business & Applied Sciences
Eastern Illinois University