IBM C2090-616 Software 2021

NEW QUESTION 1
What of the following is TRUE about triggers?

• A. Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements
• B. Triggers can be used to perform data manipulation operations against complex views
• C. Triggers can only be used to execute logic before or after appropriate SQL statements
• D. Only one trigger for a particular event and activation time can be created for a particular table

Answer: A

NEW QUESTION 2
DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)

• A. Oracle
• B. Sybase
• C. Netezza
• D. MongoDB
• E. Microsoft SQL Server

Answer: AB

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

Answer: B

NEW QUESTION 4
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 5
Which of the following editions of DB2 include support for Federation with Oracle database?

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

Answer: C

NEW QUESTION 6
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 7
Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

• A. COMMIT
• B. SAVEPOINT
• C. ROLLBACK WORK
• D. UPDATE TERMINATE

Answer: C

NEW QUESTION 8
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 9
You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data size on disk to a minimum is a priority?
Which of the following editions would be best meet the described needs?

• A. DB2 Express-C
• B. DB2 Enterprise Server Edition
• C. DB2 Workgroup Server Edition
• D. DB2 Advanced Enterprise Server Edition

Answer: D

NEW QUESTION 10
Which of the following set operators can be used to find all rows that are common in 2 queries?

• A. UNION
• B. UNION ALL
• C. EXCEPT ALL
• D. INTERSECT ALL

Answer: B

NEW QUESTION 11
What is the primary use case for creating an index with the RANDOM option on a table?

• A. Maximize performance with OLTP random key queries
• B. Maximize performance when inserting into an expression based index containing the RAND() function
• C. Minimize contention due to ascending key or descending key inserts, especially in a pureScale environment
• D. Minimize hashing skew on a table in a multiple database partition environment, especially with column organized tables

Answer: C

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

Answer: A

NEW QUESTION 15
Given the following statement:
DECLARE GLOBAL TEMPORARY TABLE TEMP1 ( ID INTEGER NOT NULL,
ITEM CHAR(30), AMOUNT DECIMAL (10,2)
ON COMMIT DELETE ROWS NOT LOGGED;
Which of the following statements are TRUE? (Choose two.)

• A. Temp1 table is accessed under schema SESSION
• B. Temp1 definition is available for use by other sessions
• C. At the end of a transaction, data is deleted automatically
• D. Definition of the table Temp1 is stored in database catalog
• E. Rows inserted by one session are visible in other sessions

Answer: DE

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

Answer: D

NEW QUESTION 17
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 revoke
• E. DB2INST3 willretain both roles

Answer: D

NEW QUESTION 18
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 frommultiple 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 theDB2ADMNS or the DB2USERS group

Answer: A

NEW QUESTION 19
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 20
Which operation typically requires a Share (S) lock?

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

Answer: D

NEW QUESTION 21
What type of function is created using the following command? CREATE FUNCTION TAN (X DOUBLE)
RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL
NO EXTERNAL ACTION DETERMINISTIC RETURN SIN(X)/COS(X)

• A. Row
• B. Table
• C. Scalar
• D. External

Answer: C

NEW QUESTION 22
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 23
......