C2090-919 - Informix 11.70 System Administrator Exam
Go back to IBM
Which CANNOT be used to move compressed data from one database to another?
How does the Deployment Assistant enable you to reduce the size of the installation to be deployed?
By removing specific product features.
How many paging files are required for SD secondary instances?
There should always be two.
Given the following statement: session A: set lock mode to wait; select * from tab1; if session A is blocked, which sysmaster table contains the session id holding the lock blocking session A?
What two conditions must be met for direct I/O to occur? (Choose two.)
When the I/O is to cooked disk space.
When the DIRECT_IO configuration parameter is set to 1.
Which command line utility displays real time statistics about the instance?
What two parameters can affect how often checkpoints occur? (Choose two.)
Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based on remaining free space?
When executing the SQL Admin API "defragment table" and "table repack" commands on the customer table, what will happen to the table? (Choose two.) execute function sysadmin:task("defragment table","customer"); execute function sysadmin:task("table repack", "customer");
Rows will be moved to the beginning of table.
Given sufficient resources the number of extents in the table will be reduced.
Which statement about automatic space management is true?
Only unmirrored spaces can be extended.
Which of the following is NOT a step in setting up HDR for the first time?
Use oninit -v to bring up the secondary.
Which statement about in-place migration is true?
In-place migration is possible when an Informix instance is migrated from an older version of Informix on the same operating system.
What does the SP_WAITTIME variable control?
The maximum time a user session will wait for a space extension to complete.
Which utilities CANNOT be used to migrate an Informix instance from one hardware vendor to a different hardware vendor?
onunload and onload
Which sbspaces statement is FALSE?
Sbspaces can be of varying page size.
What two conditions must be met in order to use Kernel-asynchronous I/O (KAIO)? (Choose two.)
When the I/O is to raw disk space.
When the operating system supports it.
Under which condition can table fragments NOT be eliminated during query processing?
Tables with round-robin distribution scheme and a range query predicate.
Which Windows utility is used to configure the SQLHOSTS registry key?
Identify a scenario when you CANNOT use in-place migration?
When you want to change database locale.
When running an onstat -u, what does a 'Y' in the first column of the flags signify?
The userthread is waiting on a condition.
If SQLTRACE is enabled, what information is displayed by this statement? select max(sql_runtime) from syssqltrace;
The SQL statement with the most execution time.
Which user isolation level may cause concurrency problems with SELECT statements?
Which of the following is NOT in the machine notes?
A descriptive list of the new features in the port.
Which onstat command returns an accurate free count of blobspace pages?
onstat -d update
Which list fragmentation statement is true?
It allows a fragment to be defined as a remainder.
If the DYNAMIC_LOGS onconfig parameter is set to 1 and logical log backups are not occurring, what will happen in the instance when the last logical-log file fills?
The instance suspends all processing until the next logical-log file is manually added.
When adding space to the storagepool, which correctly describes the type of storage which may be placed in the storagepool?
Cooked files, Raw devices and Directories.
Which environment option can rollback transactions using a table involved in an ALTER FRAGMENT ON TABLE operation?
Assuming you have a table with a replicate defined. A Flexible Grid procedure is executed changing data in that table. What statement about replication of the changes is true?
You have to call ifx_set_erstate( ) to replicate changes.
Which object can be defragmented?
What statement about users accessing a Flexible Grid is true?
Users have to be authorized to execute Flexible Grid commands.
A Connection Manager is started with the following Service Level Agreement: SLA report=(SDS+report_server) Where will a connection to the report SLA be redirected?
The server with the most available resources in the SLA list, including all SDS servers and report_server.
Which statement about Informix data compression is true?
I/O-bound tables, for example, those with bad cache hit ratios, are good candidates for compression.
Which statement is NOT true for interval fragmentation?
A remainder fragment is allowed.
What does the following SQL statement do? execute function task("reset sysadmin", "admindbs");
Locks sysadmin database in exclusive mode and recreates it in dbspace admindbs.
Which connection type can be used for network connections?
Which utility requires database logging be turned off to load a table?
Assuming the DBSPACETEMP onconfig and environment variables are set to valid dbspace names, where is the first location the instance will attempt to create a temporary non logged table?
One of the dbspaces listed in the DBSPACETEMP environment variable.
By default, the alarm program gets executed for which event(s)?
Only for events with Severity code greater than 1.
Which is NOT valid information in the SQLHOSTS connectivity file (or on windows the SQLHOSTS registry key)?
Number of listener threads.
Fragment level statistics are NOT supported with which fragmentation strategy?
Which storage space should be used to store columns defined as a BLOB or a CLOB?