Oracle
1Z0-047 · Question #185
Which statements are true? (Choose all that apply.)
The correct answer is C. The usernames of all the users including the database administrators are stored in the data dictionary. D. The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a F. Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base tables. See the full explanation below for the reasoning.
Question
Which statements are true? (Choose all that apply.)
Options
- AThe data dictionary is created and maintained by the database administrator.
- BThe data dictionary views can consist of joins of dictionary base tables and user-defined tables.
- CThe usernames of all the users including the database administrators are stored in the data dictionary.
- DThe USER_CONS_COLUMNS view should be queried to find the names of the columns to which a
- EBoth USER_OBJECTS and CAT views provide the same information about all the objects that are owned
- FViews with the same name but different prefixes, such as DBA, ALL and USER, use the same base tables
How the community answered
(42 responses)- A2% (1)
- B7% (3)
- C76% (32)
- E14% (6)
Community Discussion
No community discussion yet for this question.