IBM IBM Certified System Administrator C2090-919 Questions & Answers

• Question 71:

  Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based on remaining free space?

  A. SP_AUTOGROW

  B. SP_THRESHOLD

  C. SP_AUTOEXPAND

  D. SP_CHUNKEXTEND

  Correct Answer: B

• Question 72:

  What does the SP_WAITTIME variable control?

  A. The maximum time allowed for distributed stored procedures to complete.

  B. The maximum amount ofwait time for a reply from an H/A cluster secondary.

  C. The maximum time a user session will wait for a space extension to complete.

  D. The maximum amount ofwait time permitted before an automatic space allocation will begin.

  Correct Answer: C

• Question 73:

  When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.) executefunction sysadmin:task("defragment table","customer"); executefunction sysadmin:task("table repack", "customer");

  A. Fragments of a table will be combined.

  B. Rows will be moved to the beginning of table.

  C. Given sufficient resources the number of extents in the table will be reduced.

  D. Free space at the end of the table will be released to thedbspace for other tables to use.

  E. The table will be locked preventing inserts from happening for the duration of the commands.

  Correct Answer: BC

• Question 74:

  Which CANNOT be used to move compressed data from one database to another?

  A. dbload

  B. dbexport

  C. onunload

  D. High-Performance Loader

  Correct Answer: C

• Question 75:

  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 76:

  Which object can be defragmented?

  A. index

  B. external table

  C. temporary table

  D. system catalog table

  Correct Answer: A

• Question 77:

  Which statement about Informix data compression is true?

  A. Compressing data on one Enterprise Replication (ER) node affects the data on the other ER nodes.

  B. I/O-bound tables, for example, those with bad cache hit ratios, are good candidates for compression.

  C. Compression operations can be executed on a HDR secondary, RS secondary, or SD secondary server.

  D. Compressing data on a primary instance will not compress data on the High-Availability Data Replication (HDR) secondary instance.

  Correct Answer: B

• Question 78:

  Under which condition can table fragments NOT be eliminated during query processing?

  A. Tables with non-overlapping fragments and an equality query predicate.

  B. Tables with round-robin distribution scheme and a range query predicate.

  C. Tables with non-overlapping fragments on a single column and a range query predicate.

  D. Tables with overlapping or non-contiguous fragments on a single column and an equality query predicate.

  Correct Answer: B

• Question 79:

  When adding space to the storagepool, which correctly describes the type of storage which may be placed in the storagepool?

  A. Cooked file only.

  B. Raw devices only.

  C. Cooked files andRaw devices only.

  D. Cooked files,Raw devices and Directories.

  Correct Answer: D

• Question 80:

  Given the SQL explain output of this star join query, which is the fact table?

  

  A. sales

  B. product

  C. region

  D. customer

  Correct Answer: A