IBM Informix 11.70 System Administrator - C2090-919 Exam Practice Test

A. Committed Read

B. Committed Read Last Committed

C. Dirty Read

D. Dirty Read Last Committed

A. The Informix implementation of SSO does not support PAM.

B. The user is prompted for a password every time a user action tries to access an Informix database.

C. Authentication for the DBMS happens when a user first logs in to the client computer or domain.

D. You cannot use the Informix DB-Access client with SSO.

A. UPDATE STATISTICS operations will benefit by tuning the DBUPSPACE environment variable.

B. UPDATE STATISTICS HIGH scans the entire table.

C. An UPDATE STATISTICS LOW command will ignore tables and indexes with modifications less than STATCHANGE.

D. Data distributions are updated every time UPDATE STATISTICS LOW is executed.

A. The DBSA can control the access to tables at a row level using security labels.

B. Mapped users are allowed to run with multiple names.

C. The DBSA can grant database server access to externally authenticated users with no local account.

D. Mapped users cannot execute distributed operations.

A. Update one row and insert two rows.

B. Update three rows.

C. Return a 26095 error - Cannot update or delete a row twice in a MERGE statement.

D. Update two rows and insert one row.

A. You can enable auditing row updates for all rows from all tables in the database except for system catalog tables.

B. You can enable auditing row updates for all rows in the table.

C. You can enable auditing row updates for all rows from all tables in the database and for the system catalog tables.

D. You can enable auditing row updates just for a subset of rows in the table.