What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT
database configuration parameter is set to ON?
A
None
Which of the following DB2 objects in an efficient way of representing data without the need to
maintain it and requires no permanent storage?
A
None
Consider the following SQL statement:
SELECT workdept, empno, lastname, salary,
RANK() OVER (PARTITION BY workdept ORDER BY salary) AS rank_salary
FROM employee
ORDER BY workdept, lastname
What does the RANK() OVER (PARTITION BY workdept ORDER BY salary) clause do?
B
None
Which of the following features can provide significant benefits in storage savings, performance of
analytic workloads, and time to value?
C
None
Which of the following isolation levels most reduces concurrency and is most likely to cause lock
escalations?
C
None
Which of the following is TRUE regarding user switching in a trusted context?
D
None
The current user wants to produce a list of all user privileges she has been granted. Which table or
view can be queried to produce the desired result?
C
None
Which of the following is TRUE about DB2 OLAP functions?
C
None
The application owners say they need to be able to query a table and previous versions of that table.
Which type of table is appropriate to satisfy this requirement?
B
None
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?
A
None
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
C
None
If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?
A
None
Which of the following SQL statements will update columns C1 to DB2 and C2 to 11 if C3 is 2016?
D
None
: 40
Which of the following set operators can be used to find all rows that are common in 2 queries?
D
None
Which optional NPS compatibility features will be activated by executing the following? (Choose
two.)
SET SQL_COMPAT=NPS
C,E
None