IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 11:

  During the database server initialization process, a number of environment variables are required. What is the order of precedence if the -file option is used?

  A. User local shell, system global

  B. System global, user local shell

  C. System global, user local shell, onconfig file

  D. Onconfig file, user local shell, system global

  Correct Answer: D

• Question 12:

  Role separation provides checks and balances to improve the security of your event- auditing procedures. Which two roles must be associated with group IDs to enable role separation? (Choose two.)

  A. DBSEC: DB Security Officer

  B. AAO: Auditing Analysis Officer

  C. DBASO: DB Audit and Security Officer

  D. DBAMO: DB Audit Management Officer

  E. DBSSO: Database System Security Officer

  Correct Answer: BE

• Question 13:

  Which two logging modes are compatible between two databases participating in a distributed query? (Choose two.)

  A. ANSI and non-ANSI

  B. Buffered and Unbuffered

  C. Buffered and Non-logging

  D. Non-logging and Unbuffered

  E. Non-logging and Non-logging

  Correct Answer: BE

• Question 14:

  Which of the following is NOT possible during a non-root Informix Server installation?

  A. Role Separation

  B. Create users and groups

  C. Create a database server instance

  D. Secure the Informix installation directory

  Correct Answer: B

• Question 15:

  Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?

  A. DBUPSPACE

  B. DS_POOLSIZE

  C. VP_MEMORY_CACHE_KB

  D. DS_NONPDQ_QUERY_MEM

  Correct Answer: D

• Question 16:

  What does the following SQL administration command do? EXECUTE FUNCTION task("onmode", "wi", "/ tmp/cfg_20130601");

  A. Apply the new values for all configuration parameters in memory.

  B. Reset the values for dynamically updatable configuration parameters to the default values and save them in onconfig.

  C. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/ cfg_20130601" in memory.

  D. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/ cfg_20130601" and save them in onconfig.

  Correct Answer: C

• Question 17:

  An Enterprise Replication server is a primary server for shared-disk secondary servers. The DBA wants to reduce the replication latency by reducing the number of transactions that are applied before the logs are flushed to disk. What configuration parameter should the DBA modify?

  A. CDR_MAX_TXNS

  B. CDR_TSINSTANCEID

  C. CDR_MAX_FLUSH_SIZE

  D. CDR_LOG_LAG_ACTION

  Correct Answer: C

• Question 18:

  Which configuration parameter locks the resident and virtual segments of shared memory in operating-system physical memory?

  A. SHMSEG

  B. SHMBASE

  C. RESIDENT

  D. INFORMIXSHMLCK

  Correct Answer: C

• Question 19:

  Which two DataBlade extensions can be automatically registered? (Choose two.)

  A. Web DataBlade

  B. Spatial DataBlade

  C. TimeSeries DataBlade

  D. Excalibur Text DataBlade

  E. High Performance Loader DataBlade

  Correct Answer: BC

• Question 20:

  In addition to examining the Connection Manager log file, what are two ways to monitor the Connection Manager status? (Choose two.)

  A. onstat

  B. onmode

  C. oncmsm

  D. onmonitor

  E. OpenAdmin Tool

  Correct Answer: AE