IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 51:

  When the server is in administration mode, which users are NOT allowed to connect?

  A. informix

  B. Members of the DBSA group

  C. Members of the DBSSO group

  D. Users specified by ADMIN_MODE_USERS

  Correct Answer: C

• Question 52:

  Given these statements are executed:

  

  which statement is true?

  A. The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.

  B. The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator (IWA).

  C. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and OLAP expressions are evaluated by Informix database server.

  D. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAP expressions are evaluated by Informix Warehouse Accelerator (IWA).

  Correct Answer: C

• Question 53:

  Where are the Primary Storage Manager catalog tables stored?

  A. sysutils database

  B. sysadmin database

  C. sysmaster database

  D. A location as specified by the PSM_CATALOG_PATH configuration parameter

  Correct Answer: D

• Question 54:

  Which two technologies use the ENCRYPT_MAC configuration parameter to control the level of message authentication code (MAC) generation? (Choose two.)

  A. On-disk encryption

  B. Enterprise Replication

  C. Column level encryption

  D. High-Availability Data Replication

  E. Server-to-server distributed query communication

  Correct Answer: BD

• Question 55:

  The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

  A. The user encounters a lock request error.

  B. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.

  C. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.

  D. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.

  Correct Answer: C

• Question 56:

  When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?

  A. LOW_MEMORY_SVR

  B. LOW_MEMORY_MGR

  C. LOW_MEMORY_RESERVE

  D. LOW_MEMORY_PRESERVE

  Correct Answer: C

• Question 57:

  Which two tasks can be performed through an Informix Grid? (Choose two.)

  A. Install Informix products.

  B. Start Informix servers in a grid.

  C. Copy external files to grid servers.

  D. Setup replication automatically in a grid.

  E. Modify replication server attributes for grid servers.

  Correct Answer: CD

• Question 58:

  Which configuration parameter can be set to quickly return rows to a user while a query continues processing?

  A. OPTOFC

  B. OPTMSG

  C. OPT_GOAL

  D. OPTCOMPIND

  Correct Answer: C

• Question 59:

  Which is NOT a valid index fragmentation strategy?

  A. Fragment by Range

  B. Partition by Expression

  C. Fragment by Expression

  D. Fragment by Round Robin

  Correct Answer: D

• Question 60:

  What is the purpose of the GRANT ADMIN privilege?

  A. Grants the admin privilege to create role separation.

  B. Grants the admin privilege to perform DBSA functions.

  C. Grants the admin privilege to use the Open Admin Tool.

  D. Grants the admin privilege to run SQL administration API commands.

  Correct Answer: D