IBM IBM Certified System Administrator C2090-919 Questions & Answers

• Question 21:

  A storage pool entry can be used to do what?

  A. Increase the size of a chunk.

  B. Increase the size of the logical logs.

  C. Increase the size of the physical log.

  D. Increase the size of a storage space.

  Correct Answer: D

• Question 22:

  Which statement about compression is NOT true?

  A. If you use High-Availability clusters, data that is compressed on the primary will not be compressed on the secondary(s).

  B. If you use Enterprise Replication, compressing data on one replication server does not affect the data on any other replication server.

  C. You cannot perform compression operations on a High-Availability cluster secondary.

  D. The query optimizer may choose different query plans because compressed data covers fewer pages and has more rows per page than uncompresseddata.

  Correct Answer: A

• Question 23:

  Which statement about Informix data compression is NOT true?

  A. It can compress, repack and shrink a table in one command.

  B. There is no Admin API (sysadmin) interface to automatically compress tables.

  C. The 'onstat -g dsk' command can be used to find the progress of currently running compression operations.

  D. The compress, repack,repack_offline, uncompress, and uncompress_offline operations can consume large amounts of logs.

  Correct Answer: B

• Question 24:

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

  A. List fragmentation.

  B. Interval fragmentation.

  C. Expression fragmentation.

  D. Round-robin fragmentation.

  Correct Answer: D

• Question 25:

  Which storage space should be used to store columns defined as a BLOB or a CLOB?

  A. sbspace

  B. dbspace

  C. extspace

  D. blobspace

  Correct Answer: A

• Question 26:

  When executing the following command: execute function sysadmin:task("table compress", "customer") what will happen to the customer table?

  A. The rows will be compressed and the table size will decrease.

  B. The table will be taken offline and compressed, and the table size will decrease.

  C. The rows will be compressed and the space allocated to the table will be the same.

  D. The table will be taken offline and compressed, but the space allocated to the table will be the same.

  Correct Answer: C

• Question 27:

  The following shrink command has what effect on the customer table? execute function sysadmin:task("table shrink","customer")

  A. Moves all rows to the beginning of the table while users can modify the table.

  B. Locks the table in exclusive mode and moves all rows to the beginning of the table.

  C. Locks the table in exclusive mode and releases all free space at the end of the table.

  D. Releases all free space at the end of the table to thedbspace while users can modify the table.

  Correct Answer: D

• Question 28:

  Consider the following selective row-level auditing example:

  

  How many entries will be added to the audit file?

  A. 0

  B. 3

  C. 5

  D. 8

  Correct Answer: C

• Question 29:

  Which is a valid PAM mode supported by Informix in a UNIX platform?

  A. Login mode

  B. Client mode

  C. Server mode

  D. Password mode

  Correct Answer: D

• Question 30:

  Which of the following schema privileges allows you to rename a fragment?

  A. ALTER

  B. AMEND

  C. MODIFY

  D. RENAME

  Correct Answer: A