Oracle Database Administration from Zero to Hero - Introducing Data Dictionary

This lecture covers dynamic performance and data dictionary views in Oracle databases. It explains how dynamic performance views provide real-time data from virtual tables in memory, while data dictionary views store metadata in base tables. The lecture details naming conventions, access levels, and practical examples of querying these views. Understanding these views is crucial for DBA tasks, as they provide essential information about database operations, performance, and configuration.

What is the primary purpose of dynamic performance reviews in Oracle databases?

• To store user data permanently

• To provide live information about database operations

• To manage user access rights

• To backup database files

How do dynamic performance views differ from conventional tables?

• They are constructed from memory structures

• They are stored in the database files

• They are only available when the database is open

• They can be modified by the DBA

Which prefix is commonly used for dynamic performance view names?

• ALL

• DBA

• USER

• V$

What type of information can data dictionary views provide?

• Temporary session data

• Real-time performance metrics

• User data and constraints

• Backup status

Where are data dictionary views stored in Oracle databases?

• In temporary tablespaces

• In the user tablespaces

• In the memory

• In the SYSTEM and SYS auxiliary tablespaces

Which prefix indicates a global view of all objects in the database?

• DBA

• SYS

• ALL

• USER

What does the ALL prefix in data dictionary views represent?

• Objects owned by the current user

• System-level objects only

• All objects in the database

• Objects the user is privileged to see

Which view prefix shows only the objects owned by the current user?

• USER

• ALL

• DBA

• SYS

What additional column do DBA and ALL views have compared to USER views?

• Database ID

• Owner

• Timestamp

• Session ID

Which of the following is an exception to the typical data dictionary view naming convention?

• AUDIT_ACTIONS

• USER_VIEWS

• ALL_USERS

• DBA_TABLES