IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 111:

  When the server is in administration mode, which users are NOT allowed to connect?

  A. informix
  B. Members of the DBSA group
  C. Members of the DBSSO group
  D. Users specified by ADMIN_MODE_USERS
  C. Members of the DBSSO group

• Question 112:

  Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)

  A. Byte
  B. Shared
  C. Update
  D. Exclusive
  E. Promotable
  B. Shared
  D. Exclusive

• Question 113:

  How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

  A. Use the 'Committed Read' isolation level.
  B. Use the RETAIN UPDATE LOCKS clause with isolation level.
  C. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.
  D. Use the SET TRANSACTION command to with SERIALIZABLE clause.
  B. Use the RETAIN UPDATE LOCKS clause with isolation level.

• Question 114:

  Click on the exhibit. Which type of join is occurring?

  A. Star Join
  B. ANSI Join
  C. Index Self-Join
  D. Multi Index Join
  A. Star Join

• Question 115:

  Which two logging modes are compatible between two databases participating in a distributed query? (Choose two.)

  A. ANSI and non-ANSI
  B. Buffered and Unbuffered
  C. Buffered and Non-logging
  D. Non-logging and Unbuffered
  E. Non-logging and Non-logging
  B. Buffered and Unbuffered
  E. Non-logging and Non-logging

• Question 116:

  Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer (customer_num); Which catalog table data is NOT updated?

  A. sysdistrib
  B. systables
  C. sysindexes
  D. syscolumns
  A. sysdistrib

• Question 117:

  You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?

  A. stores:sysusers
  B. sysmaster:sysroles
  C. sysuser:sysroleauth
  D. sysmaster:sysusers
  A. stores:sysusers

• Question 118:

  In which table can you find a history of all SQL Administration API functions executed in the last 30 days?

  A. sysadmin:admin_history
  B. sysmaster:admin_history
  C. sysadmin:command_history
  D. sysmaster:command_history
  C. sysadmin:command_history

• Question 119:

  Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?

  A. DELAY_APPLY
  B. HDR_TXN_SCOPE
  C. LOG_INDEX_BUILDS
  D. FAILOVER_TX_TIMEOUT
  B. HDR_TXN_SCOPE

• Question 120:

  The DBA updated the uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands:The DBA updated the ?uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands: UPDATE ph_task SET tk_enable = ?WHERE tk_name = uto_crsd?UPDATE ph_task SET tk_enable = ??WHERE tk_name = ?uto_crsd? UPDATE ph_threshold SET value = ?WHERE name = UTODEFRAG_ENABLED?UPDATE ph_threshold SET value = ??WHERE name = ?UTODEFRAG_ENABLED? UPDATE ph_threshold SET value = ?000?WHERE name = UTOCOMPRESS_ROWS?UPDATE ph_threshold SET value = ?000?WHERE name = ?UTOCOMPRESS_ROWS? What will be the effect of auto_crsd database scheduler task on the tables?

  A. Compress all tables with less than 5000 rows.
  B. Compress and defragment tables with more than 5000 uncompressed rows.
  C. Compress, repack and shrink tables with more than 5000 uncompressed rows.
  D. Do not compress, repack, shrink and defragment any table with more than 5000 rows.
  C. Compress, repack and shrink tables with more than 5000 uncompressed rows.