Dictionary-managed tablespaces have a problem that causes slower performance of ____ commands.
A) SQL
B) PL / SQL
C) UML
D) DML

Question

Quizplus · Accepted Answer

Dictionary-managed tablespaces store metadata information in the data dictionary, which can cause slower performance of DML (data manipulation language) commands such as INSERT, UPDATE, and DELETE. This is because the database has to query the data dictionary every time a DML command is executed. Using locally-managed tablespaces can improve the performance of DML commands as they do not rely on the data dictionary. SQL, PL/SQL, and UML are not affected by the type of tablespace used.

Dictionary-Managed Tablespaces Have a Problem That Causes Slower Performance of ____