IBM C2090-616 Online Practice Questions and Exam Preparation

IBM C2090-616 Online Questions & Answers

• Question 1:

  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
  A. Concurrency may be improved

• Question 2:

  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
  C. Minimize contention due to ascending key or descending key inserts, especially in a pureScale environment

• Question 3:

  A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)

  A. Easy scalability
  B. Management of very large data sets
  C. Continuously available dataset solution
  D. Increased throughput of many concurrent short running queries
  E. Faster response time of long-running or complex queries with I/O spread across many computers
  B. Management of very large data sets
  E. Faster response time of long-running or complex queries with I/O spread across many computers

• Question 4:

  Which of the following SQL statements will update columns C1 to DB2 and C2 to 11 if C3 is 2016?

  A. UPDATE t1 c1 = `DB2, c2' = 11
  B. UPDATE t1 SET c1 = `DB2, c2' = 11
  C. UPDATE t1 c1 = `DB2', c2 = 11 WHERE c3 = 2016
  D. UPDATE t1 SET (c1, c2) = (`DB2', 11) = WHERE c3 = 2016
  C. UPDATE t1 c1 = `DB2', c2 = 11 WHERE c3 = 2016

• Question 5:

  Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?

  A. View
  B. Alias
  C. Table
  D. Schema
  A. View

• Question 6:

  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
  D. Definition of the table Temp1 is stored in database catalog
  E. Rows inserted by one session are visible in other sessions

• Question 7:

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

• Question 8:

  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
  A. Principal standby with SYNC synchronization mode

• Question 9:

  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
  C. DB2 Enterprise Server Edition

• Question 10:

  Which of the following is TRUE regarding user switching in a trusted context?

  A. You cannot switch user id in a trusted context.
  B. You can issue a switch-user request within a transaction.
  C. The new user must have the connect-privilege on the database for it to succeed.
  D. No password is ever required for the new user as an authentication is established in the trusted connection.
  D. No password is ever required for the new user as an authentication is established in the trusted connection.