C2090-320

The following definition for COL1 is given by this statement: CREATE TABLE… (COL1 BINARY (05)) Which of the following statements will successfully insert data into the table?A . INSERT INTO… (COL1) VALUES(HEX(‘12345’));B . INSERT INTO… (COL1) VALUES(BLOB(‘12345’));C . INSERT INTO… (COL1) VALUES(CHAR(‘12345’));D . INSERT INTO… (COL1) VALUES(BINARY(‘123456’));View AnswerAnswer: C

If a scrollable cursor is INSENSITIVE, which of the following applies?A . The cursor is read onlyB . WITH ROWSET POSITIONING is not allowedC . The select-statement must not contain an SQL data change statementD . The cursor has sensitivity to changes that are made to the database after the...

Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed? GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;A . BINDB . REORGC . TRIGGERD . EXECUTEView AnswerAnswer: D

You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?A . Bind your application with ISOLATION(UR)B . Bind...

In a unique referential constraint, which type of key does a foreign key reference?A . Child keyB . Collation keyC . Parent keyD . Secondary keyView AnswerAnswer: C

In which address space would a native SQL stored procedure run?A . WLMB . DISTC . DBM1D . The address space of the calling programView AnswerAnswer: C

Which of the following can activate a trigger?A . A row is insertedB . A table or view is createdC . A check constraint is definedD . A referential constraint is violatedView AnswerAnswer: D

Given the following CREATE VIEW statement and sample data; your login id is “ROGER”. What will be the result for this query? A . 6B . 5C . 4D . 2View AnswerAnswer: C

Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?A . PAGEB . TABLEC . PARTITIOND . TABLESPACEView AnswerAnswer: C

You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?A . REALB . BIGINTC . DECIMALD . INTEGERView AnswerAnswer: C