nerdexam
Oracle

1Z0-052 · Question #254

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 _____.

The correct answer is D. data dictionary. Oracle stores view definitions as metadata in the data dictionary, not in any physical data segment.

Managing Schema Objects

Question

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 _____.

Options

  • Auser tables
  • Bview segment
  • Ctable segment
  • Ddata dictionary
  • Eobject segment
  • Fperformance tables

How the community answered

(19 responses)
  • C
    5% (1)
  • D
    89% (17)
  • E
    5% (1)

Why each option

Oracle stores view definitions as metadata in the data dictionary, not in any physical data segment.

Auser tables

User tables store application row data, not database object definitions such as views.

Bview segment

There is no Oracle storage structure called a 'view segment'; views have no segment because they contain no rows.

Ctable segment

Table segments store physical row data for tables in data files; view definitions are not placed in table segments.

Ddata dictionaryCorrect

When a view is created, Oracle records its definition - the underlying SELECT statement and associated metadata - in the data dictionary, accessible through catalog views such as USER_VIEWS and DBA_VIEWS owned by SYS. The data dictionary is the central repository for all database object definitions, and views consume no independent storage segment because they hold no data themselves.

Eobject segment

Object segments hold data for object types such as nested tables or varrays, not view definitions.

Fperformance tables

Performance tables such as V$ dynamic performance views expose runtime instance metrics; they do not store user-created view definitions.

Concept tested: Oracle data dictionary storage of view definitions

Source: https://docs.oracle.com/cd/B19306_01/server.102/b14220/datadict.htm

Topics

#views#data dictionary#schema object storage#Oracle metadata

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice