Oracle Linux 8 System Administration — Question 7

Which three statements are true about dynamic performance views? (Choose three.)

Answer options

• A. They are owned by the SYSTEM user.
• B. V$FIXED_TABLE can be queried to display the name of all dynamic performance views.
• C. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.
• D. They can be queried only when the database is open.
• E. Read consistency is not guaranteed.
• F. Data displayed by querying dynamic performance views is derived from memory structures.

Correct answer: B, D, F

Explanation

The correct answers B, D, and F are accurate because V$FIXED_TABLE indeed lists all dynamic performance views, these views can only be accessed when the database is open, and their data originates from memory structures. Options A, C, and E are incorrect as they do not accurately describe the characteristics of dynamic performance views.