What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT
database configuration parameter is set to ON?
Which of the following DB2 objects in an efficient way of representing data without the need to
maintain it and requires no permanent storage?
Consider the following SQL statement:
SELECT workdept, empno, lastname, salary,
RANK() OVER (PARTITION BY workdept ORDER BY salary) AS rank_salary
ORDER BY workdept, lastname
What does the RANK() OVER (PARTITION BY workdept ORDER BY salary) clause do?
Which of the following features can provide significant benefits in storage savings, performance of
analytic workloads, and time to value?
Which of the following isolation levels most reduces concurrency and is most likely to cause lock
Which of the following is TRUE regarding user switching in a trusted context?
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?
Which of the following is TRUE about DB2 OLAP functions?
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?
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
Consider the following query and the resulting set of data:
SELECT empno, lastname FROM emp WHERE empno BETWEEN 000020 and 000070
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?
Which of the following set operators can be used to find all rows that are common in 2 queries?
Which optional NPS compatibility features will be activated by executing the following? (Choose