Oracle Database Administration from Zero to Hero - Practice - Querying Data Dictionary

This video tutorial covers how to interact with Oracle databases using dynamic performance and data dictionary views. It explains the process of connecting to a database, mounting it, and the limitations of accessing certain views in mount mode. The tutorial also demonstrates querying dynamic performance views, exploring tablespace structures, and linking views for comprehensive data retrieval. It concludes with a comparison of user and system views and encourages further exploration of additional dictionary views.

What is a limitation of accessing data dictionary views when the database is in mount mode?

• They can only be accessed by the system user.

• They provide limited information.

• They are not available because the database data files are not open.

• They are fully accessible.

Which information can be retrieved from dynamic performance views when the database is open?

• The Sid, serial number, and status of the current session.

• The list of all database users.

• The number of users connected to the database.

• The structure of the database tablespaces.

What is a key difference between DBA_tables and user_TABLES views?

• DBA_tables is accessible to all users.

• user_TABLES includes a column for the table owner.

• user_TABLES retrieves only tables owned by the system user.

• DBA_tables retrieves fewer rows than user_TABLES.

Why does the HR user have fewer rows in user_TABLES compared to all TABLES?

• HR user has access to all database tables.

• all TABLES view is restricted to system users.

• user_TABLES includes tables owned by all users.

• HR user can only access tables they own.

Which of the following views is not accessible to the HR user?

• user_indexes

• DBA_tables

• user_sequences

• user_views