最新的IBM DB2 11.1 DBA for LUW - C2090-600免費考試真題

A. BLOB

B. XML

C. VARCHAR

D. CLOB

E. DATETIME

A. The routine must return either an integer or a null.

B. The routine must be cross-compatible with Oracle PL/SQL syntax rules.

C. The routine must be generated with IBM Database Conversion Workbench (DCW).

D. The routine cannot contain comments.

E. The routine cannot contain argument lists or variable arguments (varargs).

A. db2exfmt

B. db2advis

C. db21ook

D. db2expln

A. If a user is switched within a trusted connection, the applicable audit policies are re-evaluated for the new user without regard to audit policies for the original user.

B. The audit policy applied to a table is automatically applied to any view based on that table.

C. Multiple audit policies can be associated with the same table at the same time.

D. Audit policy changes are applied instantly and affect all inflight transactions.

A. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1

B. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL

C. ALTER TABLE tab1 DROP COLUMN col1

D. ALTER TABLE tab1 APPEND ON

E. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)

A. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.

B. The insert will succeed as there is no WITH CHECK OPTION on view V3.

C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.

D. The insert will succeed as it passes validation.