The customer and order tables are often used in joins, thereby resulting in complex queries.
You created views to simplify the writing of queries. These views are stored in _____.
A.
user tables
B.
view segment
C.
table segment
D.
data dictionary
E.
object segment
F.
performance tables
https://docs.oracle.com/cd/B28359_01/server.111/b28318/datadict.htm#CNCPT1209
The data dictionary consists of the following:
Base Tables: The underlying tables that store information about the associated database. Only Oracle Database should write to and read these tables. Users rarely access them directly because they are normalized, and most of the data is stored in a cryptic format.
User-Accessible Views: The views that summarize and display the information stored in the base tables of the data dictionary. These views decode the base table data into useful information, such as user or table names, using joins and WHERE clauses to simplify the information. Most users are given access to the views rather than the base tables.
D