Multiple choice technology databases

What type of database object does the following DDL statement creates CREATE TEST VOLUMES(ABCD1,ABCD2,ABCD3) VCAT dsn1

  1. Tablespace

  2. Storage group

  3. Index

  4. View
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The statement CREATE STOGROUP TEST VOLUMES(ABCD1,ABCD2,ABCD3) VCAT dsn1 creates a Storage Group (STOGROUP) in DB2, mapping logical volumes to a specific catalog identifier. The syntax defines volumes and VCAT, which are not used directly in creating tablespaces, indexes, or views.

Keep practicing — related questions