IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 31:

  Which two statements are true about archecker utility? (Choose two.)

  A. Archecker can help developers team to debug procedures.

  B. Archecker can do backup testing, fully integrated with onbar and ontape utilities.

  C. Archecker can copy data from different servers, even restoring from a remote device.

  D. Archecker can use all kind of connections protocols, including shared memory connections.

  E. Archecker can do data restore (physical or logical) of database portions, table portions, or even a set of tables.

  Correct Answer: BE

• Question 32:

  Consider the following Enterprise Replication command: cdr define template temp1 -c g_serv1 -C ignore -a -d testdb. Which statement is TRUE?

  A. The command defines a template to be realized on servers serv4 and serv5.

  B. The command defines a template to exclude database testdb from replication.

  C. The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.

  D. The command defines a template to replicate the entire database testdb by defining replicates for each of the views and system tables in testdb.

  Correct Answer: C

• Question 33:

  Which statement is true about restartable restore?

  A. ontape can perform restartable restores if a backup is taken to disk.

  B. Restartable restore is the ability to restart a failed restore using onbar.

  C. Restartable restore is the ability to restart a failed restore using ontape.

  D. Restartable restore is the ability to restart an instance using a restore from some other computer.

  Correct Answer: B

• Question 34:

  Which storage manager allows specification of a larger size than others for BAR_XFER_BUF_SIZE?

  A. Informix Storage Manager (ISM)

  B. Informix Primary Storage Manager (PSM)

  C. Informix Secondary Storage Manager (ISSM)

  D. Informix Archive Restore Storage Environment (IARSE)

  Correct Answer: B

• Question 35:

  Which Informix utility can be used to customize the onconfig file?

  A. ifxdeploy

  B. genoncfg

  C. dbaccess

  D. onparams

  Correct Answer: B

• Question 36:

  Which two statements are true? (Choose two.)

  A. Logical log files must always reside in rootdbs.

  B. Having too little log space does not affect performance.

  C. Having too much log space does not affect performance.

  D. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.

  E. Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.

  Correct Answer: CD

• Question 37:

  The DBA wants to define a replicate as follows:

  

  Which condition must be true for the command to execute successfully?

  A. The table table1 should have col1 as its primary key.

  B. The table table1 should have CRCOLS shadow columns.

  C. The table table1 should have a constraint on column col1.

  D. The table table1 should have an unique index on column col2.

  Correct Answer: D

• Question 38:

  Which statement is FALSE?

  A. A new index can be created compressed.

  B. Attached indexes cannot be compressed.

  C. A compressed index can be uncompressed.

  D. A compressed index cannot be uncompressed.

  Correct Answer: C

• Question 39:

  Which option maximizes performance in an Informix Warehouse (DSS) environment?

  A. Higher value of LOGBUFF.

  B. Higher value of PHYSBUFF.

  C. Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.

  D. SHMTOTAL set to 0 to allow Informix to access all available physical memory.

  Correct Answer: D

• Question 40:

  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