IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 61:

  Where must the HA_FOC_ORDER configuration parameter be set?

  A. Any server in the cluster.

  B. The primary server only.

  C. The SDS secondary only.

  D. The HDR secondary only.

  Correct Answer: B

• Question 62:

  Which action can be taken if an instance is down?

  A. A point-in-time mixed restore.

  B. Warm restore of non-critical storage spaces.

  C. Cold restore by onbar using storage space backups taken by ontape on tape devices.

  D. A mixed restore using onbar whole system backup and incremental dbspace level backups.

  Correct Answer: A

• Question 63:

  Several operating-system kernel configuration parameters can affect the use of shared memory by the database server. Which two kernel parameters may need to be configured? (Choose two.)

  A. Memory page size.

  B. Total number of available semaphores.

  C. Lower-boundary address for shared memory.

  D. Total memory presented to the operating system.

  E. Maximum operating-system shared-memory segment size.

  Correct Answer: CE

• Question 64:

  Which statement accurately describes the selective row-level auditing feature in Informix?

  A. Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.

  B. Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.

  C. Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.

  D. Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

  Correct Answer: B

• Question 65:

  Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?

  A. DIRECT_IO

  B. DBUPSPACE

  C. AUTO_AIOVPS

  D. AUTO_READAHEAD

  Correct Answer: D

• Question 66:

  Which value of DRINTERVAL should be used for HDR_TXN_SCOPE configuration parameter to take effect?

  A. -1

  B. 0

  C. 1

  D. 30

  Correct Answer: B

• Question 67:

  Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which statement is true?

  A. The temp table will be created in datadbs1.

  B. The temp table will be created in root dbspace.

  C. The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.

  D. The temp table will be created round-robin across the dbspaces in DBSPACETEMP.

  Correct Answer: B

• Question 68:

  Which two statements are true about Informix OpenAdmin Tool? (Choose two.)

  A. Informix OpenAdmin Tool does not support multiple languages.

  B. Ontape backup can be taken using Informix OpenAdmin Tool.

  C. Informix cluster cannot be managed using Informix OpenAdmin Tool.

  D. Informix OpenAdmin Tool cannot be used to run the equivalent of onstat commands.

  E. SQL explorer feature provides Query Drill Down functionality to analyze SQL statements.

  Correct Answer: BE

• Question 69:

  Which statement is true about log salvaging?

  A. ontape cannot perform salvage of logs.

  B. Log salvaging cannot be avoided if onbar is used for restore.

  C. Log salvaging is the act of restoring logical logs after physical restore, but before logical restore.

  D. Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.

  Correct Answer: D

• Question 70:

  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