157k views
1 vote
In Oracle, the ____ table contains information about the tables known to SQL.​

a.​ ALL_TABLES
b.​ SHOW_TABLES
c.​ SP_TABLES
d.​ DBA_TABLES

User Simon Lenz
by
8.0k points

1 Answer

3 votes
In Oracle, the DBA_TABLES table contains information about the tables known to SQL. Therefore, the answer is d. DBA_TABLES.

The ALL_TABLES table contains information about all tables accessible to the user while the USER_TABLES table contains information about the tables owned by the user. The SHOW_TABLES and SP_TABLES tables are not valid in Oracle.
User Tom Dalton
by
8.5k points