Which statement about the scope of UPDATE STATISTICS is true?
A. If the FOR PROCEDURE keywords are included but the name of any SPL routine is not specified, an error will be returned.
B. If the FOR TABLE keywords are used without specifying the name or synonym of a table, the database will not recalculate distributions for any table in the current database.
C. If the FOR TABLE keywords are specified with a table but without specifying a list of columns, the database server will not recalculate distributions on all of the columns of the specified table.
D. If the FOR PROCEDURE specification, Table and Column Scope, and Resolution clauses are NOT included, then the statistics are updated for every table and SPL routine in the current database.
Which two objects are NOT included in a backup? (Choose two.)
A. Tables
B. Indexes
C. External tables
D. Simple blob data stored in simpleblobspaces
E. Basic text search indexes stored in externaldbspaces
Which object can be defragmented?
A. index
B. external table
C. temporary table
D. system catalog table
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.
Which of the following is NOT in the machine notes?
A. Operating system requirements.
B. Critical kernel tuning parameters.
C. A descriptive list of the new features in the port.
D. Featuresthat are not available for the version and O/S.
Which command line utility displays real time statistics about the instance?
A. dbinfo
B. onstat
C. dbschema
D. onmachinfo
Given the following statement:
session A. setlock mode to wait;
select* from tab1;
ifsession A is blocked, which sysmaster table contains the session id holding the lock blocking session A?
A. syslocks
B. sysscblst
C. syssessions
D. syslockholders
Which statement about automatic space management is true?
A. Spaces cannot be extended manually.
B. Onlyunmirrored spaces can be extended.
C. Mirrored andunmirrored spaces can be extended.
D. The time interval for low storage space checks is not user configurable.
Which of the following is NOT a step in setting up HDR for the first time?
A. Take a level 0 backup of the primary.
B. Useoninit -v to bring up the secondary.
C. Execute a physical restore on the secondary.
D. Useonmode -d to specify the secondary instance name.
What two onconfig parameters will help improve performance of new network connections? (Choose two.)
A. NETTYPE
B. VPCLASS
C. NS_CACHE
D. FET_BUF_SIZE
E. NUMFDSERVERS