Oracle Database 11g: Administration I — Question 14

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

Answer options

• A. Read consistency is not guaranteed for these views
• B. Some of them display data that is useful for SQL statement tuning
• C. They display selected data from data dictionary base tables
• D. They can be queried only by SYS even when the database is open
• E. They contain information that is not available in data dictionary views

Correct answer: A, D, E

Explanation

The correct answers are A, D, and E because dynamic performance views do not guarantee read consistency, can only be accessed by the SYS user, and contain unique information not available in data dictionary views. Option B is incorrect as while some views may assist in SQL tuning, it is not a defining characteristic of all dynamic performance views. Option C is also incorrect since these views derive their data from dynamic performance metrics rather than just the data dictionary.