IBM IBM Certifications C2090-616 Questions & Answers

• Question 41:

  What is the maximum precision for the DECIMAL data type?

  A. 7

  B. 15

  C. 23

  D. 31

  Correct Answer: D

  A decimal number is a packed decimal number with an implicit decimal point. The position of the decimal point is determined by the precision and the scale of the number. The scale, which is the number of digits in the fractional part of the number, cannot be negative or greater than the precision. The maximum precision is 31 digits.

  Reference https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/ db2z_numericdatatypes.html__

• Question 42:

  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

  Correct Answer: B

• Question 43:

  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. This statement will succeed and DB2 INST3 will still be able to create in the database.

  B. This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database.

  C. This statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time.

  D. This statement will succeed with a warning since CREATETAB cannot be totally revoked. DB2INST3 will retain both roles.

  Correct Answer: D

• Question 44:

  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?

  A. SYSCAT.DBAUTH

  B. SYSIBMADM.GRANTS

  C. SYSIBMADM.PRIVILEGES

  D. SYSCAT.USER_TAB_PRIVS

  Correct Answer: A

• Question 45:

  Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?

  A. Read Stability

  B. Cursor Stability

  C. Repeatable Read

  D. Cursor Stability with WAIT FOR OUTCOME clause

  Correct Answer: A

  Read stability (RS) locks only those rows that an application retrieves within a unit of work. It ensures that any qualifying row read during a unit of work is not changed by other application processes until the unit of work completes, and that any row changed by another application process is not read until the change is committed by that process

• Question 46:

  Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)

  A. Shadow tables cannot be queried directly

  B. Shadow tables do not store their data on disk

  C. Shadow tables must be organized by column

  D. Shadow tables must be maintained by replication

  E. You cannot join shadow tables to other kinds of tables

  Correct Answer: CD

• Question 47:

  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.

  Correct Answer: A

• Question 48:

  Which database object can be locked explicitly?

  A. Row

  B. View

  C. Index

  D. Table

  Correct Answer: D

• Question 49:

  Which of the following SQL statements will remove all rows from the table T1? (Choose two.)

  A. DELETE FROM t1

  B. DELETE* FROM t1

  C. DELETE* TABLE t1

  D. TRUNCATE TABLE t1 IMMEDIATE

  E. TRUNCATE TABLE t1

  Correct Answer: AB

• Question 50:

  Which three facilities are used to control authorization in DB2?

  A. privileges, db2ssh, LBAC credentials

  B. privileges, authority levels, certificates

  C. db2ssh, trusted contexts, authority levels

  D. privileges, authority levels, LBAC credentials

  Correct Answer: D