C2090-616 | IBM C2090-616 Study Guides 2021

NEW QUESTION 1
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 dat
• E. Other applications can read the table
• F. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped

Answer: AE

NEW QUESTION 2
Which of the following SQL statements will update columns C1 to DB2 and C2 to 11 if C3 is 2021?

• A. UPDATE t1 c1 = ‘DB2, c2’ = 11
• B. UPDATE t1 SET c1 = ‘DB2, c2’ = 11
• C. UPDATE t1 c1 = ‘DB2’, c2 = 11 WHERE c3 = 2021
• D. UPDATE t1 SET (c1, c2) = (‘DB2’, 11) = WHERE c3 = 2021

Answer: C

NEW QUESTION 3
With HADR, which of the following configuration and topology choices provides the highest level of protection
from potential loss of data in a pureScale environment?

• A. Principal standby with SYNC synchronization mode
• B. Auxiliary standby with SYNC synchronization mode
• C. Principal standby with NEARSYNC synchronization mode
• D. Auxiliary standby with SUPERSYNC synchronization mode

Answer: A

Explanation: Standby databases are synchronized with the primary database through log data that is generated on the primary and shipped to the standbys. The standbys constantly roll forward through the logs. You can choose from four different synchronization modes. In order of most to least protection, these are SYNC,
NEARSYNC,
ASYNC, and SUPERASYNC.

NEW QUESTION 4
Which edition of DB2 LUW has been discontinued in v11.1?

• A. DB2 Developer Edition
• B. DB2 Express Server Edition
• C. DB2 Enterprise Server Edition
• D. DB2 Connect Enterprise Server Edition

Answer: B

NEW QUESTION 5
Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?

• A. Read Stability
• B. Cursor Stability
• C. Repeatable Read
• D. Uncommitted Read

Answer: C

NEW QUESTION 6
The DDL statement is used to create table T1: CREATE TABLEt1 (
c1 INTEGER,
c2 INTEGER NOT NULL, c1 DECIMAL(11,2),
c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
)
Which of the following INSERT statements will execute successfully?

• A. INSERT INTO t1 VALUES (100)
• B. INSERT INTO t1 (c1, c2) VALUES (100)
• C. INSERT INTO t1 (c1, c3) VALUES (‘100’, ‘100.00’)
• D. INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)

Answer: B

NEW QUESTION 7
Which of the following is TRUE about DB2 OLAP functions?

• A. They return scalar values and not array values
• B. There are no DB2 monitor elements specific to OLAP functions
• C. OLAP functions are not supported in a common table expression (CTE)
• D. OLAP aggregation functions are not supported with column organized tables

Answer: C

NEW QUESTION 8
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

Answer: A

NEW QUESTION 9
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

Answer: A

Explanation: 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

NEW QUESTION 10
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

Answer: AB

NEW QUESTION 11
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

Answer: A

NEW QUESTION 12
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

Answer: A

NEW QUESTION 13
Which of the following statements about triggers are TRUE? (Choose two.)

• A. There is a limit of 8 for the maximum number of cascading trigger activations
• B. Triggers can be activated as a result of changes due to referential constraint enforcement
• C. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
• D. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
• E. The activation of the triggers for a particular table, event and activation time are conducted in descendingorder of trigger creation time

Answer: BD

NEW QUESTION 14
Which operation typically requires a Share (S) lock?

• A. INSERT
• B. SELECT
• C. DELETE
• D. UPDATE

Answer: D

NEW QUESTION 15
Consider the following sequence of events:
Eddie grants SELECT WITH GRANT OPTION privilege to Mike. Mike grants SELECT privilege to Jeff.
Eddie revokes SELECT privilege from Mike. What will happen to Jeff’s SELECT privilege?

• A. Jeff’s SELECT privilege will be revoked
• B. Jeff’s SELECT privilege will be retained
• C. Jeff’s SELECT privilege will be retained only if he has ACCESSCTRL authority
• D. Jeff’s SELECT privilege will be retained only if Eddie has ACCESSCTRL authority

Answer: A

NEW QUESTION 16
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. Shadow Table
• B. Temporal Table
• C. Range-Partitioned Table
• D. Multidimensional Clustered Table

Answer: B

NEW QUESTION 17
If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?

• A. Concurrency may be improved
• B. Lock escalation will be prevented
• C. Query performance will be reduced
• D. The number of locks for the same workload will be reduced

Answer: A