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?
When a database is created with the AUTOMATIC STORAGE NO clause, it does not automatically assign a default storage group. The first storage group created with the CREATE STOGROUP statement becomes the default storage group. In this case, the first storage group created after connecting to the TESTDB database is SG1, thus making SG1 the default storage group for the TESTDB database.
A is correct
the correct answer is A, when a database created with the AUTOMATIC STORAGE NO clause does not have a default storage group. The first storage group created with the CREATE STOGROUP statement becomes the designated default storage group. https://www.ibm.com/support/knowledgecenter/es/SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0059094.html