Which statement about block indexes is correct?

The following query is executed frequently against the SALES table: SELECT sales_id,
sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which
statement will create an index for optimal query performance and ensure uniqueness of the
SALES_ID column?

A database named TEST and a storage group named SG_1 were created with these statements:

an error was produced.Why did the error occur?

When defining storage groups for multi-temperature data, storage paths are usually grouped
according to their quality of service characteristics. What are three common quality of service
characteristics used?

If the following commands complete successfully for a single partition database: CREATE
DATABASE mydb; CREATE BUFFERPOOL mybp; Which statement is true?

You recently added more storage to a table space and a rebalance operation was started
automatically. How can you pause the rebalance operation?

The following statement was used to create a table space named TBSP1 in a non-partitioned database:

Which statement(s) will successfully lower the high water mark in table space TBSP1 and return
unused storage space to the operating system?

Which operation can be performed by executing an ALTER STOGROUP statement?

Which statement about SMS table spaces is correct?

Which type of storage is utilized in the implementation of an effective and flexible multitemperature database?