C2090-616 Online Practice Questions and Answers

What is the purpose of a role?

A. To define exactly what a specific user can and cannot do within a particular database once they have been authenticated.

B. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges.

C. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users, groups, or other roles.

D. To assign one or more users that need to run local DB2 applications and tools on a particular server to the DB2ADMNS or the DB2USERS group.

Application 1 executes the following statements:

INSERT INTO TAB1 (NAME,AMOUNT) VALUES (`John,100);

COMMIT;

UPDATE TAB1 SET AMOUNT=90 WHERE NAME=`John';

After a few seconds, application 2 executes the following query:

SELECT AMOUNT FROM TAB1 WHERE NAME=`John'

Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of the

following is TRUE?

A. Application 2 will read the amount of 90

B. Application 2 will read the amount of 100

C. Application 2 will receive a warning message

D. Application 2 will enter lock-wait state until application 1 commits or the locktimeout value expires

Which of the following is fundamental to BLU acceleration?

A. pureScale

B. Column organized tables

C. Multidimensional clustering

D. Purchasing new hardware that is compatible with BLU acceleration and compression

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. Shadow tables

B. Range-partitioned tables

C. Materialized query tables

D. Multidimensional clustering tables

Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)

A. No other applications can access the table

B. Only uncommitted read (UR) applications can access the table

C. The lock owner and other applications can read, but not update, the locked table

D. The lock owner can both read and update datA. Other applications can read the table

E. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on

F. the table is dropped

BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)

A. Direct Standard Edition

B. Enterprise Server Edition

C. Workgroup Server Edition

D. DB2 Direct Advanced Edition

E. Advanced Enterprise Server Edition

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?

A. It ranks the rows in each WORKDEPT by SALARY.

B. It groups all rows by WORKDEPT, then ranks all rows in the complete result set by SALARY.

C. It generates a blank output line after each group of rows with the same WORKDEPT, and ranks these groups by SALARY.

D. It tells the optimizer to physically partition the EMPLOYEE table by the WORKDEPT column for runtime execution, and ranks each WORKDEPT by SALARY.

A user executes the following statements:

REATE TABLE t1 (c1 INT, c2 INT);

CREATE ALIAS a1 FOR t1;

What will be the result if the user executes the following statement?

DROP ALIAS a1;

A. The alias A1 will be dropped

B. The table T1 will be dropped

C. Both T1 and A1 will be dropped

D. Nothing, the statement will result in an error

Which operation typically requires a Share (S) lock?

A. INSERT

B. SELECT

C. DELETE

D. UPDATE

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

A. A ROLLBACK command executed just after the COMMIT command cancels that COMMIT.

B. Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command.

C. It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT.

D. It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed.