IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 81:

  The Rolling Window clause of the ALTER FRAGMENT MODIFY INTERVAL statement CANNOT define a purging policy on a table that has which two attributes? (Choose two.)

  A. The table has a ROWID shadow column.

  B. The table has a Fragment By Range index.

  C. The table has a Unique Key being used by ER.

  D. The Fragment Key is defined with multiple columns.

  E. The Primary Key for the table is referenced by a foreign key constraint.

  Correct Answer: AE

• Question 82:

  "informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear", "informix_stores");

  A. Shuts down the primary server and converts the secondary server to be the primary.

  B. Clears the log position of the SDS servers and restarts replication.

  C. Converts the shared disk secondary server to a standard server and shuts down the primary server.

  D. Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

  Correct Answer: D

• Question 83:

  Which two statements are true?

  A. Temporary dbspaces can have different page sizes.

  B. Separate temporary dbspaces are required for each buffer pool.

  C. DBSPACETEMP dbspaces can be temporary or standard dbspaces.

  D. If rootdbs is mirrored then all the temporary spaces must be mirrored.

  E. If DBSPACETEMP is not configured then temporary space will never be used.

  Correct Answer: AC

• Question 84:

  Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to- end secure connection?

  A. On-disk encryption

  B. Enterprise Replication

  C. High-Availability Data Replication

  D. Server-to-server distributed query communication

  Correct Answer: A

• Question 85:

  Which Enterprise Replication command CANNOT be used on replicates that include TimeSeries columns?

  A. cdr start

  B. cdr sync

  C. cdr realize

  D. cdr remaster

  Correct Answer: D

• Question 86:

  In which table can you find a history of all SQL Administration API functions executed in the last 30 days?

  A. sysadmin:admin_history

  B. sysmaster:admin_history

  C. sysadmin:command_history

  D. sysmaster:command_history

  Correct Answer: C

• Question 87:

  When configuring Informix server for DRDA connection, which statement is true?

  A. The connection protocol must be drsoctcp.

  B. The database server name for DRDA connection must correspond to the DBSERVERNAME onconfig parameter.

  C. The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.

  D. The database server name should correspond to either the DBSERVERNAME or the DBSERVERALIASES onconfig parameter.

  Correct Answer: C

• Question 88:

  You are running an UPDATE statement on a table using dbaccess. What kind of lock type is expected?

  A. Byte

  B. Update

  C. Shared

  D. Exclusive

  Correct Answer: D

• Question 89:

  When using the deployment assistant, which two statements are true? (Choose two.)

  A. A java environment must be configured.

  B. The Informix user account must be used.

  C. Chunks can be raw devices or buffered files.

  D. The user must have connect permission to all databases.

  E. The user must have connect privilege to sysadmin database.

  Correct Answer: AE

• Question 90:

  Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?

  A. STATAUTO

  B. STATFORCE

  C. FORCE AUTO

  D. STATCHANGE

  Correct Answer: D