If the DBA wishes to describe all tables in the database,which data dictionary view should be accessed in Oracle?
A) dba_tab_privs
B) dba_tab_comments
C) dba_table_label
D) dba_tables

Question

Quizplus · Accepted Answer

The DBA should access the "dba_tables" data dictionary view in Oracle to describe all tables in the database. This view contains information about all tables that exist in the database, including schema name, table name, column names, and other metadata. The other options, "dba_tab_privs", "dba_tab_comments", and "dba_table_label" do not provide information on all tables in the database, but rather focus on specific aspects such as table privileges, comments, and security labels.

If the DBA Wishes to Describe All Tables in the Database,which