Which three statements are true regarding views? (Choose three.)

The correct answer is B. Views can be created from tables or other views. D. Both simple and complex views can use indexes existing on the underlying tables. F. Complex views can be created on multiple tables that exist in the same or different schemas. Creating a Sequence (continued) CYCLE | NOCYCLE Specifies whether the sequence continues to generate values after reaching its maximum or minimum value (NOCYCLE is the default option.) CACHE n | NOCACHE Specifies how many values the Oracle server preallocates and keeps in…

Creating Other Schema Objects

Question

Options

AViews can be created only from tables.
BViews can be created from tables or other views.
COnly simple views can use indexes existing on the underlying tables.
DBoth simple and complex views can use indexes existing on the underlying tables.
EComplex views can be created only on multiple tables that exist in the same schema.
FComplex views can be created on multiple tables that exist in the same or different schemas.

How the community answered

(25 responses)

A
12% (3)
B
84% (21)
E
4% (1)

Explanation

Creating a Sequence (continued) CYCLE | NOCYCLE Specifies whether the sequence continues to generate values after reaching its maximum or minimum value (NOCYCLE is the default option.) CACHE n | NOCACHE Specifies how many values the Oracle server preallocates and keeps in memory (By default, the Oracle server caches 20 values.)

Topics

#views#complex views#simple views#indexes on views

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice