C2090-919 Online Practice Questions and Answers
Which of the following activities does the Secure-Auditing Facility NOT monitor and record?
A. Specific rows.
B. Specific users.
C. Specific tables.
D. Specific DML operations.
What ONCONFIG parameter can be tuned to increase memory for hash joins?
A. RESIDENT
B. EXTSHMADD
C. VP_MEMORY_CACHE_KB
D. DS_NONPDQ_QUERY_MEM
What is used during Fast Recovery to return pages to the original state?
A. Logical Log
B. Physical Log
C. External Tables
D. TemporaryDBSpaces
When adding space to the storagepool, which correctly describes the type of storage which may be placed in the storagepool?
A. Cooked file only.
B. Raw devices only.
C. Cooked files andRaw devices only.
D. Cooked files,Raw devices and Directories.
Which environment option can rollback transactions using a table involved in an ALTER FRAGMENT ON TABLE operation?
A. FORCE_DML_EXEC
B. FORCE_DDL_EXEC
C. ROLLBACK_DML_EXEC
D. ROLLBACK_DDL_EXEC
Which statement about in-place migration is true?
A. In-place migration is possible when an Informix instance is migrated from a non-Informix database management system.
B. In-place migration is possible when an Informix instance is migrated from an older version of Informix on the same operating system.
C. In-place migration is possible when an Informix instance is migrated from an older version of Informix on a different operating system.
D. In-place migration requires that the DBA copy the database schema, user data, and user objects from the older version to the newer version of Informix.
What does the following SQL statement do? execute function task("reset sysadmin", "admindbs");
A. Renamessysadmin database to admindbs.
B. Purges all "mon_*" tables in sysadmin database as user admindbs.
C. Turns the whole Database Scheduler off and finally dropssysadmin database.
D. Lockssysadmin database in exclusive mode and recreates it in dbspace admindbs.
Which statement regarding the Single Sign-On (SSO) feature is correct?
A. You cannot use the Informix DB-Access client with SSO.
B. The Informix implementation of SSO does not support PAM.
C. Authentication for the DBMS happens when a user first logs in to the client computer or domain.
D. The user is prompted for a password every time a user action tries to access an Informix database.
When executing the following command: execute function sysadmin:task("table compress", "customer") what will happen to the customer table?
A. The rows will be compressed and the table size will decrease.
B. The table will be taken offline and compressed, and the table size will decrease.
C. The rows will be compressed and the space allocated to the table will be the same.
D. The table will be taken offline and compressed, but the space allocated to the table will be the same.
