A2090-619 Online Practice Questions and Answers

What are two requirements for the "ifxclone" utility? (Choose two.)

A. All databases must use logging.

B. The source server must be a secondary server.

C. Only one server clone process can occur at a time.

D. Both the source and target servers must be part of a trusted network environment.

E. Both the source and target servers must use the same type of disk space (raw or cooked).

"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.

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.

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.

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).

Which two parameters must be set to a valid value before starting a Shared Disk (SD) Secondary server? (Choose two.)

A. SDS_PAGING

B. SDS_TIMEOUT

C. SDS_TEMPDBS

D. SDS_LOGCHECK

E. SDS_ALTERNATE

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.

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.

Which statement is true for starting Connection Manager?

A. Only user root and informix.

B. Any user of the DBSA group.

C. Any user who is granted privileges to connect to the sysadmin database.

D. Only a user of the DBSA group with privilege to connect to the sysadmin database.

Which is NOT a feature of onbar backups?

A. The ability to parallelize backups.

B. The ability to do a point-in-time restore.

C. The ability to backup without a storage manager.

D. The ability to do an external backup using a Storage Area Network.