C2090-619 無料問題集「IBM Informix 12.10 System Administrator」

（A）Specify the name of the label of the server digital certificate in the ONCONFIG file.

（B）Configure poll threads for SSL connections in the ONCONFIG file.

（C）Specify the SSL connection protocol in the sqlhosts file or registry entry.

（D）Configure encrypt virtual processors in the ONCONFIG file.

（A）The table references or joins specified in the query or query block must be the same as the references in the data mart definition.

（B）The scalar and aggregate functions in the query or query block must be supported by the Informix Warehouse Accelerator.

（C）The query or query block must include at least 2 fact tables.

（D）The query or query block must refer to a subset of the tables in the AQT.

（A）CDR_LOG_LAG_ACTION

（B）CDR_MAX_TXNS

（C）CDR_MAX_FLUSH_SIZE

（D）CDR_TSINSTANCEID

（A）All built-in extensions are automatically registered each time the database sever is started.

（B）All built-in extensions are automatically registered when the extension is first accessed.

（C）All built-in extensions are automatically registered when the database server is first initialized.

（D）All DataBlades located in the $INFORMIXDIR/extend are automatically registered.

（A）Use the RETAIN UPDATE LOCKS clause with isolation level.

（B）Use the 'Cursor Stability' isolation level along the WITH HOLD clause.

（C）Use the SET TRANSACTION command to with SERIALIZABLE clause.

（D）Use the 'Committed Read' isolation level.

（A）cdr sync

（B）cdr realize

（C）cdr start

（D）cdr remaster

（A）All users with the EXTEND role can register external routines.

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

（C）All users with the EXTEND role can grant it to other users.

（D）All users can create external routines in the database server.

（A）The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and
OLAP expressions are evaluated by Informix database server.

（B）The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator (IWA).

（C）The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.

（D）The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAP expressions are evaluated by
Informix Warehouse Accelerator (IWA).

（A）The DBSA can define a default role to assign only to the PUBLIC group for a particular database.

（B）The privileges associated with a default role takes precedence over the privileges granted to an individual user.

（C）The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.

（D）When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.

（A）Compress

（B）Defragment

（C）Repack

（D）Shrink