nerdexam
IBM

C2090-600 · Question #33

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…

The correct answer is C. IBMSTOGROUP. See the full explanation below for the reasoning.

Question

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?

Options

  • ASG1
  • BSG2
  • CIBMSTOGROUP
  • DIBMDEFAULTTSG

How the community answered

(34 responses)
  • A
    9% (3)
  • B
    3% (1)
  • C
    74% (25)
  • D
    15% (5)

Community Discussion

No community discussion yet for this question.

Full C2090-600 Practice