IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 41:

  Which statement regarding the Single Sign-On (SSO) feature is correct?

  A. You cannot use the Informix DB-Access client with SSO.
  B. The Informix implementation of SSO does not support PAM.
  C. Authentication for the DBMS happens when a user first logs in to the client computer or domain.
  D. The user is prompted for a password every time a user action tries to access an Informix database.
  C. Authentication for the DBMS happens when a user first logs in to the client computer or domain.

• Question 42:

  Which of the following is NOT a step in setting up HDR for the first time?

  A. Take a level 0 backup of the primary.
  B. Useoninit -v to bring up the secondary.
  C. Execute a physical restore on the secondary.
  D. Useonmode -d to specify the secondary instance name.
  B. Useoninit -v to bring up the secondary.

• Question 43:

  Which environment option can rollback transactions using a table involved in an ALTER FRAGMENT ON TABLE operation?

  A. FORCE_DML_EXEC
  B. FORCE_DDL_EXEC
  C. ROLLBACK_DML_EXEC
  D. ROLLBACK_DDL_EXEC
  B. FORCE_DDL_EXEC

• Question 44:

  Which user isolation level may cause concurrency problems with SELECT statements?

  A. Dirty Read
  B. Committed Read
  C. Dirty Read Last Committed
  D. Committed Read Last Committed
  B. Committed Read

• Question 45:

  Which SQL Administration API command will merge non-contiguous table extents?

  A. shrink
  B. defragment
  C. table repack
  D. merge extents
  B. defragment

• Question 46:

  When creating an index, which type of fragmentation is NOT allowed?

  A. List fragmentation.
  B. Interval fragmentation.
  C. Expression fragmentation.
  D. Round-robin fragmentation.
  D. Round-robin fragmentation.

• Question 47:

  Which statement about updating statistics is NOT true?

  A. UPDATE STATISTICS HIGH scans the entire table.
  B. Data distributions are updated every time UPDATE STATISTICS LOW is executed.
  C. UPDATE STATISTICS operations will benefit by tuning the DBUPSPACE environment variable.
  D. An UPDATE STATISTICS LOW command will ignore tables and indexes with modifications less than STATCHANGE.
  B. Data distributions are updated every time UPDATE STATISTICS LOW is executed.

• Question 48:

  If SQLTRACE is enabled, what information is displayed by this statement? select max(sql_runtime) from syssqltrace;

  A. The SQL statement with the least wait time.
  B. The SQL statement with the least I/O wait time.
  C. The SQL statement with the most I/O wait time.
  D. The SQL statement with the most execution time.
  D. The SQL statement with the most execution time.

• Question 49:

  Given the following:

  

  A. Update three rows.
  B. Update one row and insert two rows.
  C. Update two rows and insert one row.
  D. Return a 26095 error - Cannot update or delete a row twice in a MERGE statement.
  C. Update two rows and insert one row.

• Question 50:

  Given the following SQL statement:

  

  What does the merge statement do?

  A. For each row that matches the condition col1 = c1, it inserts a new row in tab1 with the sum of corresponding c2 and col2 column values.
  B. For the rows that match the condition col1 = c1, it adds thethe c2 column value to the col2 column value and updates corresponding rows in tab1.
  C. For the rows that match the condition, col1 = c1, it adds the col2 column value to the c2 column value and updates corresponding rows in tab2.
  D. Deletes rows from tab2 and updates rows in tab1 that match the condition col1 = c1 by adding the c2 column value to the col2 column value of corresponding rows in tab1.
  B. For the rows that match the condition col1 = c1, it adds thethe c2 column value to the col2 column value and updates corresponding rows in tab1.