Free IBM C2090-546 Exam Dumps Questions & Answers

Which two are valid BASED UPON CONNECTION attributes for a trusted context? (Choose two.)

• A.Database role
• B.Date and time
• C.System authorization id
• D.Application program name
• E.Data stream encryption

Which command will activate the statement concentrator?

• A.UPDATE DB CFG FOR mydb USING STMT_CONC YES
• B.UPDATE DB CFG FOR mydb USING STMTCONCENT ON
• C.UPDATE DB CFG FOR mydb USING STMTCONC ENABLED
• D.UPDATE DB CFG FOR mydb USING STMT_CONC LITERALS

If table TAB_A and index TABA_IDX are created as follows:

What can be compressed?

• A.Only data in columns C1 and C2 in table TAB_A and index TABA_IDX.
• B.All data in table TAB_A and index TABA_IDX.
• C.All data in table TAB_
• D.Only data in columns C1 and C2 of table TAB_A.

Which SQL statement will archive the audit log for the connected database?

• A.SELECT * FROM TABLE(SYSPROC.AUDIT_ARCHIVE_LOG(' ', -1)) AS t1
• B.CALL SYSPROC.AUDIT_ARCHIVE_LOG(' ', -1)
• C.CALL SYSPROC.AUDIT_ARCHIVE(NULL, NULL)
• D.SELECT * FROM TABLE(SYSPROAUDIT_ARCHIVE(NULL, NULL)) AS t1

In a partitioned database environment, a table's distribution key can have:

• A.An XML column with unique index defined on it.
• B.An XML column with primary key defined on it.
• C.Only XML columns with no primary key defined on it.
• D.An XML column with other non-XML columns.