A2090-619 Online Practice Questions and Answers

You have started a violations table for a target table with a non default name. (For example: "START VIOLATIONS TABLE FOR customer USING exceptions, reasons;"). How can you determine the relationship between the violations table and the target table later?

A. Using dbschema utility

B. Using 'oncheck -pT' command

C. Querying sysdepends system catalog table

D. Querying sysviolations system catalog table

Which statement is FALSE regarding SBSPACES?

A. They are recoverable.

B. They do not obey transaction isolation modes.

C. They have read, write, and seek properties similar to a standard UNIX file.

D. Smart large objects within table rows are not required to be retrieved in one statement.

Which two statements are true about blobspace? (Choose two.)

A. The TEXT or BYTE objects are stored in the logical log files.

B. A blobspace is a logical storage unit that stores only TEXT and BYTE data.

C. The TEXT or BYTE objects that are assigned to a blobspace are physically logged.

D. A newly created blobspace is immediately available for storage of TEXT or BYTE data.

E. The database server writes data stored in a blobspace directly to disk without passing it through the bufferpool.

store1, store2, store3 and store4 are defined as four servers participating in a GRID.

Which statement is true?

A. The SELECT query is not a GRID query.

B. The SELECT query will return results from all grid servers.

C. The SELECT query will return results from store1 and store2.

D. The SELECT query will return results from store3 and store4.

The DBA updated the uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands:The DBA updated the ?uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands: UPDATE ph_task SET tk_enable = ?WHERE tk_name = uto_crsd?UPDATE ph_task SET tk_enable = ??WHERE tk_name = ?uto_crsd? UPDATE ph_threshold SET value = ?WHERE name = UTODEFRAG_ENABLED?UPDATE ph_threshold SET value = ??WHERE name = ? UTODEFRAG_ENABLED? UPDATE ph_threshold SET value = ?000?WHERE name = UTOCOMPRESS_ROWS?UPDATE ph_threshold SET value = ?000?WHERE name = ? UTOCOMPRESS_ROWS? What will be the effect of auto_crsd database scheduler task on the tables?

A. Compress all tables with less than 5000 rows.

B. Compress and defragment tables with more than 5000 uncompressed rows.

C. Compress, repack and shrink tables with more than 5000 uncompressed rows.

D. Do not compress, repack, shrink and defragment any table with more than 5000 rows.

What security role is required for you to create trusted-context objects?

A. AAO

B. DBSA

C. DBSSO

D. DBSECADM

How can you ensure to hold the an update lock until the end of a transaction when fetching rows from a cursor?

A. Use the 'Committed Read' isolation level.

B. Use the RETAIN UPDATE LOCKS clause with isolation level.

C. Use the 'Cursor Stability' isolation level along the WITH HOLD clause.

D. Use the SET TRANSACTION command to with SERIALIZABLE clause.

Which command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?

A. onbar -E

B. dbexport

C. onsmsync

D. ontape -exp

What kinds of Table Level Restores can be done by the archecker utility?

A. Only logical restore.

B. Only physical restore.

C. Only point in time restore.

D. Physical, logical, and point in time restores.

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.

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)

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.

What data migration tool(s) should be used to load data from a non-Informix data source?

A. dbimport

B. onload and dbload

C. dbload and High Performance Loader

D. onload and High Performance Loader

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

Which statement describes the behavior of an Informix instance when the IFX_EXTEND_ROLE configuration parameter is set to ON.

A. All users with the EXTEND role can grant it to other users.

B. All users with the default role can register external routines.

C. All users can create external routines in the database server.

D. All users with the EXTEND role can register external routines.