DB2 10 for z/OS Database Administrator — Question 12

If the following SQL statements are executed:
CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sg1 ON /data1;
CREATE STOGROUP ibmstogroup ON /data2;
CREATE STOGROUP sg2 ON /data3;
Which storage group is the default storage group for the TESTDB database?

Answer options

Correct answer: C

Explanation

The default storage group for a database is typically the one designated when not specified by the user. In this case, IBMSTOGROUP was explicitly created and serves as the default, while SG1, SG2, and IBMDEFAULTTSG do not fulfill this role as they were not defined as defaults.