C2090-320 Table Practice Questions

In order to evaluate the real-time relative disorganization of an index, which catalog table would you query?

• AA. SYSIBM.SYSINDEXES
• BB. SYSIBM.SYSINDEXPART
• CC. SYSIBM.SYSINDEXSTATS
• DD. SYSIBM.SYSINDEXSPACESTATS

To ensure only positive values are entered into a column, you add a constraint on the SALARY column of a previously populated table. If DB2 cannot guarantee the existing values in the column are positive, it will place the table space or partition that contains the table into which of the following states?

• AA. CHECK PENDING
• BB. REORG PENDING
• CC. REBUILD PENDING
• DD. ADVISORY REORG PENDING

For a partition-by-range table, which data types can be used to define the key columns that are used to partition the data? (Choose two)

Select 2 answers.

• AA. XML
• BB. BINARY
• CC. DECIMAL
• DD. VARCHAR
• EE. DECFLOAT

Which of the following statements will create an application-period temporal table?

• AA. CREATE TABLE POLICY_ATT(BANK VARCHAR(4), SYS_BEGIN TIMESTAMP, SYS_END TIMESTAMP, CLIENT CHAR(4), TYPE CHAR(5), PAY INT, PERIOD SYSTEM_TIME(SYS_BEGIN, SYS_END));
• BB. CREATE TABLE POLICY_ATT(BANK VARCHAR(4), SYS_BEGIN TIMESTAMP NOT NULL, SYS_END TIMESTAMP NOT NULL, CLIENT CHAR(4), TYPE CHAR(5), PAY INT, PERIOD SYSTEM_TIME(SYS_BEGIN, SYS_END));
• CC. CREATE TABLE POLICY_ATT(BANK VARCHAR(4), BUS_BEGIN TIMESTAMP, BUS_END TIMESTAMP, CLIENT CHAR(4), TYPE CHAR(5), PAY INT, PERIOD BUSINESS_TIME(BUS_BEGIN, BUS_END));
• DD. CREATE TABLE POLICY_ATT(BANK VARCHAR(4), BUS_BEGIN TIMESTAMP NOT NULL, BUS_END TIMESTAMP NOT NULL, CLIENT CHAR(4), TYPE CHAR(5), PAY INT, PERIOD BUSINESS_TIME(BUS_BEGIN, BUS_END));