When defining a foreign key on a table, which statement is true?

If a ROWID column is defined on a table as GENERATED BY DEFAULT, what must also be
done?

On what type of index would an ALTER INDEX ADD COLUMN be allowed?

In a normalized design, in third normal form, the entity defined in the logical design is often
transformed in the physical design to which of the following?

If SEGSIZE 64 and MAXPARTITIONS 10 are specified in a CREATE TABLESPACE statement,
what type of table space is created?

A single table should allow for up to 100 Terabytes of application data. How do you design your
table space?

For which table type could you specify ALTER TABLE tb1 DATA CAPTURE CHANGES?

When a table space defined as both partitioned-by-growth (PBG) and MEMBER CLUSTER YES is
altered to MEMBER CLUSTER NO by the ALTER TABLESPACE command. Which statement is
correct?

Given the following statements have been run successfully and the buffer pools BP1 and BP2 both
have the same page size: CREATE TABLESPACE TS1 IN DB1 DEFINE YES BUFFERPOOL
BP1 MAXPARTITIONS 15 MEMBER CLUSTER ; CREATE TABLE TB1 (COL1 INT NOT NULL

WITH DEFAULT) IN DB1.TS1 ; COMMIT ; ALTER TABLESPACE TS1 BUFFERPOOL BP2
MAXPARTITIONS 20 ; What is the next logical step in the sequence to CREATE an index IX1 on
COL1 on TB1?

The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The
following results are received: 1111 AAAA Which statement is true?