IBM DB2 10.1 Fundamentals — Question 1

How can you determine which databases are created in an instance?

Answer options

• A. use dbschema utility
• B. inspect ONCONFIG file
• C. List reserved pages with oncheck -pr
• D. run SELECT name FROM sysmaster:sysdatabases

Correct answer: D

Explanation

The correct answer is D because executing the SQL command SELECT name FROM sysmaster:sysdatabases directly queries the system database for a list of databases in the instance. Option A is incorrect as dbschema is used for schema-related information, not for listing databases. Option B is not a suitable method since the ONCONFIG file contains configuration settings, not a list of databases. Option C, while related to database maintenance, does not provide direct information about existing databases.