Online Access Free C2090-612 Exam Questions

Thefollowing DDL statements are executed to create the following objects: CREATE TABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1 INTEGER, COL2 VARCHAR(10) ) IN DB1.TS1; CREATE INDEX USER1.IX1 ON USER1.TB1 ( COL2 ) BUFFERPOOL BP0 COPY YES;Next, the following ALTER statements are done (in order): 1) ALTER TABLESPACE DB1.TS1 BUFFERPOOL BP8K0 MAXPARTITIONS 20; 2) ALTER TABLESPACE DB1.TS1 SEGSIZE 64; 3) ALTER INDEX USER1.IX1 BUFFERPOOL BP16K0; Which of the following will materialize all of thechanges with the least amount of work?

• A.REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE
  REORG INDEX USER1.IX1 SHRLEVEL CHANGE
• B.Nothing needs to be done.
• C.REORG INDEX USER1.IX1 SHRLEVEL CHANGE
• D.REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE

When modeling data to provide for a physical design, which of the following defines the data types for the columns in the DB2 physical table?

• A.Primary Key
• B.Attributes
• C.Domain
• D.Entities

In which situation does adding a referential constraint place a table space containing data into check-pending status?

• A.When a primary key is defined on a table with no unique index.
• B.When a foreign key is defined on a table with NOT ENFORCED option and a unique index has not been defined.
• C.When a foreign key is defined on a table and a corresponding primary key has not been defined.
• D.When a foreign key isdefined on a table with the ENFORCED option.

Objects DB1.TS1 .... DB1.TS10 are in copy pending status. Which of the following actions removes the copy pendingstate AND creates an entry in SYSIBM.SYSCOPY?

• A.Run the BACKUP SYSTEM utility.
• B.Run the REPAIR SET NOCOPYPEND utility.
• C.Issue command -START DB(DB1) SP(TSx) ACCESS(FORCE) for each of the 10 table spaces where x = 1 - 10.
• D.Run the COPY TABLESPACE utility with option FULL YES for each of the 10 table spaces.

Which of the following types of SQL statements are NOT eligible to be stored in the dynamic SQL statement cache?

• A.OPEN
• B.SELECT
• C.MERGE
• D.INSERT