IBM IBM Certifications C2090-619 Questions & Answers

• Question 31:

  Which statement is true regarding the selective row-level auditing feature in Informix?

  A. You can create audit masks corresponding to row-level events of a specific table.

  B. Selective row-level auditing must be explicitly turned on using the onshowaudit utility.

  C. When you create a table, you can specify if row-level auditing should be enabled for the table.

  D. When you create a database, you can specify if row-level auditing should be enabled for all the tables within the database.

  Correct Answer: C

• Question 32:

  Which step must be performed to enable Secure Socket Layer (SSL) connections to Informix?

  A. Configure encrypt virtual processors in the ONCONFIG file.

  B. Configure poll threads for SSL connections in the ONCONFIG file.

  C. Specify the SSL connection protocol in the sqlhosts file or registry entry.

  D. Specify the name of the label of the server digital certificate in the ONCONFIG file.

  Correct Answer: C

• Question 33:

  To potentially return unused extent pages to the chunk free list, an Informix administrator would execute which storage optimization operation?

  A. Shrink

  B. Repack

  C. Compress

  D. Defragment

  Correct Answer: A

• Question 34:

  What is the primary benefit of a Storage Pool?

  A. It allows data to be shared across instances.

  B. It allows data to be shared across dbspaces.

  C. It allows space to automatically be added to dbspaces.

  D. It allows space to be reserved for critical database operations.

  Correct Answer: C

• Question 35:

  Which statement about Storage Provisioning is true?

  A. Only raw devices can be extended.

  B. Only cooked devices can be extended.

  C. Only unmirrored spaces can be extended.

  D. Mirrored and unmirrored spaces can be extended.

  Correct Answer: C

• Question 36:

  Which objects can be compressed?

  A. CLOBs

  B. smart BLOBs

  C. partition BLOBs

  D. blobspace BLOBs

  Correct Answer: C

• Question 37:

  Which two statements are true about blobspace? (Choose two.)

  A. The TEXT or BYTE objects are stored in the logical log files.

  B. A blobspace is a logical storage unit that stores only TEXT and BYTE data.

  C. The TEXT or BYTE objects that are assigned to a blobspace are physically logged.

  D. A newly created blobspace is immediately available for storage of TEXT or BYTE data.

  E. The database server writes data stored in a blobspace directly to disk without passing it through the bufferpool.

  Correct Answer: BE

• Question 38:

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

  A. Only newly added rows will be compressed.

  B. Only existing data will be compressed, new data will remain uncompressed.

  C. Row data and partition blobs will be compressed and any free table space will be released.

  D. Row data and partition blobs will be compressed and the space allocated to the table will remain.

  Correct Answer: C

• Question 39:

  Which fragmentation strategy is capable of generating new fragments automatically?

  A. Fragment by List

  B. Fragment by Range

  C. Fragment By Expression

  D. Fragment by Round Robin

  Correct Answer: B

• Question 40:

  The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

  A. The table has a ROWID shadow column.

  B. The table has a Fragment By Range index.

  C. The table has a Unique Key being used by ER.

  D. The Fragment Key is defined with multiple columns.

  E. The Primary Key for the table is referenced by a foreign key constraint.

  Correct Answer: AE