IBM C2090-320 Online Practice Questions and Exam Preparation

IBM C2090-320 Online Questions & Answers

• Question 51:

  In order to evaluate the real-time relative disorganization of an index, which catalog table would you query?

  A. SYSIBM.SYSINDEXES
  B. SYSIBM.SYSINDEXPART
  C. SYSIBM.SYSINDEXSTATS
  D. SYSIBM.SYSINDEXSPACESTATS
  D. SYSIBM.SYSINDEXSPACESTATS

• Question 52:

  Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

  A. PAGE
  B. TABLE
  C. PARTITION
  D. TABLESPACE
  C. PARTITION

• Question 53:

  In order to run a DB2 program, the user issues the following commands:

  TSO prompt: READY

  USER enters: DSN SYS(SSTR)

  USER enters: RUN PROGRAM(MYPROG)

  USER enters: END

  What is the result?

  A. DB2 does not allow these commands
  B. DSN command can not be used to run a program
  C. Start a DSN session with DB2 subsystem SSTR, run a program and end the DSN session
  D. Start a DSN session with system parameters SSTR, run a program and end the DSN session
  C. Start a DSN session with DB2 subsystem SSTR, run a program and end the DSN session

• Question 54:

  Given the following CREATE VIEW statement and sample data; your login id is "ROGER". What will be the result for this query?

  

  A. 6
  B. 5
  C. 4
  D. 2
  C. 4

• Question 55:

  Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two.)

  A. MAXPARTITIONS
  B. ENDING AT clause on a CREATE INDEX statement for the table
  C. MEMBER CLUSTER
  D. ENDING AT clause on the CREATE TABLE statement
  E. A LOB column specified as a column of the partitioning key
  B. ENDING AT clause on a CREATE INDEX statement for the table
  E. A LOB column specified as a column of the partitioning key

• Question 56:

  Which characteristic best describes a created global temporary table?

  A. Inserts are logged
  B. Rows are locked when they exist in the table
  C. They have permanent, shareable descriptions
  D. Access to rows can be shared across multiple processes
  C. They have permanent, shareable descriptions

• Question 57:

  Which SQL statement can be used to provide diagnostic information about the last SQL statement that was executed?

  A. GET DIAGNOSTICS
  B. DESCRIBE OUTPUT
  C. DECLARE STATEMENT
  D. SET CURRENT DEBUG MODE
  A. GET DIAGNOSTICS

• Question 58:

  We want to increase the salary for each employee (EMP) in the department (WORKDEPT) D11 and we want to see the new salaries(SALARY) for each of them.

  Which single SQL statement will do this?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 59:

  To ensure only positive values are entered into a column, you add a constraint on the SALARY column of a previously populated table. If DB2 cannot guarantee the existing values in the column are positive, it will place the table space or partition that contains the table into which of the following states?

  A. CHECK PENDING
  B. REORG PENDING
  C. REBUILD PENDING
  D. ADVISORY REORG PENDING
  A. CHECK PENDING

• Question 60:

  Consider the following question: "What is the average salary by sex within education level?" An occasional uncommitted record can be tolerated in the average. Which of the following is the most appropriate isolation level for this?

  A. UR
  B. RR
  C. CS
  D. RS
  A. UR