Multiple choice technology databases

Which of the following does DB2 Configuration Advisor recommend?

  1. SQL statements

  2. New indexes

  3. DDL

  4. Database configuration parameter settings
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The DB2 Configuration Advisor recommends optimal values for database configuration parameters and buffer pools based on system resources and user inputs. It does not design indexes, write SQL, or generate DDL.

Keep practicing — related questions