IBM DB2 11.1 Fundamentals for LUW C2090-616 Exam Questions

A portion of your database tables are used for OLTP-type processing and another portion are used for more analytical queries. There is a small subset of tables that are used in both of these usage patterns. What could you use to derive the analytic improvements offered by BLU technology in such an environment?

Consider the following query and the resulting set of data:

SELECT empno, lastname FROM emp WHERE empno BETWEEN '000020' and '000070'

Result:

If the query below is executed, how many rows will be returned?

SELECT empno FROM emp WHERE empno > '000020' AND empno '000070'

If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?

Which of the following SQL statements will update columns C1 to DB2 and C2 to 11 if C3 is 2016?

The DDL statement is used to create table T1:

CREATE TABLEt1 (

c1 INTEGER,

c2 INTEGER NOT NULL,

c1 DECIMAL(11,2),

c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP

)

Which of the following INSERT statements will execute successfully?

The following statements are executed:

GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;

GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;

GRANT ROLE role A to USER db2inst3;

GRANT ROLE role B to USER db2inst3;

Which of the following is TRUE if this statement is executed later?

REVOKE ROLE roleB FROM USER db2inst3;

A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)