IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 101:

  The user 'guest' connected to a local database world@lsys and wants to execute the following query:

  What two permissions does the user 'guest' need to access the remote table? (Choose two.)

  A. User 'guest' must have SELECT permission on 'globe'
  B. User 'guest' must have CONNECT permission on 'globe'
  C. User 'guest' must have SELECT permission on 'globe@rsys:position'
  D. User 'guest' must have CONNECT permission on 'globe@rsys:sadm.position'
  E. User 'guest' must have RESOURCE permission on 'world@lsys'
  B. User 'guest' must have CONNECT permission on 'globe'
  C. User 'guest' must have SELECT permission on 'globe@rsys:position'

• Question 102:

  Which list fragmentation statement is true?

  A. It cannot be used for indexes.
  B. It allows overlapping fragments.
  C. It can only be used for numeric columns.
  D. It allows a fragment to be defined as a remainder.
  D. It allows a fragment to be defined as a remainder.

• Question 103:

  Given the following statement:

  session A. setlock mode to wait;

  select* from tab1;

  ifsession A is blocked, which sysmaster table contains the session id holding the lock blocking session A?

  A. syslocks
  B. sysscblst
  C. syssessions
  D. syslockholders
  A. syslocks

• Question 104:

  Which two onconfig parameters can be set to backup/restore to/from a cloud storage location? (Choose two.)

  A. TAPEDEV
  B. TAPEBLK
  C. LTAPEBLK
  D. LTAPEDEV
  E. BAR_BSALIB_PATH
  A. TAPEDEV
  D. LTAPEDEV

• Question 105:

  Which object can be defragmented?

  A. index
  B. external table
  C. temporary table
  D. system catalog table
  A. index

• Question 106:

  Which statement about mapped user functionality is true?

  A. Mapped users cannot execute distributed operations.
  B. Mapped users are allowed to run with multiple names.
  C. The DBSA can control the access to tables at a row level using security labels.
  D. The DBSA can grant database server access to externally authenticated users with no local account.
  D. The DBSA can grant database server access to externally authenticated users with no local account.

• Question 107:

  Which two corrective actions may be taken if following message is logged in the online message log during a failed attempt to bring an instance online? (Choose two)

  18:15:44

  Size of resident + virtual segments 100000KB + 60000KB > 150000KB

  18:15:44

  total allowed by configuration parameter SHMTOTAL

  A. Decrease SHMADD
  B. Increase SHMTOTAL
  C. Decrease SHMBASE
  D. Increase SHMVIRTSIZE
  E. Decrease buffer pool size
  B. Increase SHMTOTAL
  E. Decrease buffer pool size

• Question 108:

  Most, but not all Virtual Processors, can be modified via the onmode -p command. Which CANNOT be modified?

  A. ADM
  B. BTS
  C. CPU
  D. CSM
  A. ADM

• Question 109:

  Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will temporary tables be created by default? (Choose three.)

  A. The rootdbspace.
  B. The users' home directory.
  C. The $INFORMIXDIR/tmp directory.
  D. Thedbspace in which the active database was created.
  E. The /tmp directory or PSORT_DBTEMP.
  A. The rootdbspace.
  D. Thedbspace in which the active database was created.
  E. The /tmp directory or PSORT_DBTEMP.

• Question 110:

  What is used during Fast Recovery to return pages to the original state?

  A. Logical Log
  B. Physical Log
  C. External Tables
  D. TemporaryDBSpaces
  B. Physical Log