IBM IBM Certifications C2090-616 Questions & Answers

• Question 31:

  Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

  A. Sequence

  B. Row Identifier

  C. Identity Column

  D. Insert time clustering table

  Correct Answer: A

• Question 32:

  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

  Correct Answer: AE

• Question 33:

  Which of the following authorities are sufficient for creating a database? (Choose two.)

  A. DBADM

  B. SYSADM

  C. SECADM

  D. SYSCTRL

  E. SYSMAINT

  Correct Answer: BD

• Question 34:

  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

  Correct Answer: A

• Question 35:

  Which of the following statements about stored procedures is TRUE?

  A. Stored procedures can be written in SQL PL, but not in the PL/SQL dialect

  B. The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database

  C. There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures

  D. Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

  Correct Answer: B

• Question 36:

  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

  Correct Answer: B

• Question 37:

  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'

  A.

  B. 0

  C. 1

  D. 3

  E. 5

  Correct Answer: C

• Question 38:

  What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?

  A. 32672 bytes

  B. 65344 bytes

  C. 98016 bytes

  D. 130688 bytes

  Correct Answer: A

• Question 39:

  Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?

  A. Deadlock

  B. Lock timeout

  C. Lock escalation

  D. Lock conversion

  Correct Answer: A

• Question 40:

  The creator of an index or an index specification automatically receives which privilege on the index?

  A. SELECT

  B. DELETE

  C. UPDATE

  D. CONTROL

  Correct Answer: D