C2090-919 Online Practice Questions and Answers

To enable network encryption, what two steps must the administrator complete? (Choose two.)

A. Enter the CSM name in thesqlhosts file.

B. Set the IFX_ENCCSMonconfig parameter to 1.

C. Define the CSM in the concsm.cfg configuration file.

D. Enter the CSM name in theonconfig NETTYPE parameter.

E. Set the environment variable ENCCSMCFG to the name of the CSM.

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

Under which condition can table fragments NOT be eliminated during query processing?

A. Tables with non-overlapping fragments and an equality query predicate.

B. Tables with round-robin distribution scheme and a range query predicate.

C. Tables with non-overlapping fragments on a single column and a range query predicate.

D. Tables with overlapping or non-contiguous fragments on a single column and an equality query predicate.

Which CANNOT be used to move compressed data from one database to another?

A. dbload

B. dbexport

C. onunload

D. High-Performance Loader

What two conditions must be met in order to use Kernel-asynchronous I/O (KAIO)? (Choose two.)

A. When AIO is not available.

B. When the I/O is to raw disk space.

C. When the I/O is to buffered file chunks.

D. When the operating system supports it.

E. When the KAIOON parameter in ONCONFIG file is set to1.

Given the two indexes defined on table tab1:

Which optimization method may be used?

A. STAR_JOIN

B. MULTI_INDEX

C. OUTER_INDEX

D. INDEX_SELFJOIN

If SQLTRACE is enabled, what information is displayed by this statement? select max(sql_runtime) from syssqltrace;

A. The SQL statement with the least wait time.

B. The SQL statement with the least I/O wait time.

C. The SQL statement with the most I/O wait time.

D. The SQL statement with the most execution time.

What does the following task function do?

EXECUTE FUNCTION task("storagepool add", "/region2/dbspaces", "0", "0", "20000", "1");

A. Creates a secondstoragepool.

B. Createsdbspace at /region2/dbspaces.

C. Invalid offset and total size forstoragepool add command.

D. Add the directory /region2/dbspaces to the storagepool with a beginning offset of 0, a total size of 0, initial chunk size of 20 MB, and a high priority.

Which action will NOT occur when the following command is executed? UPDATE STATISTICS HIGH

A. Recompile all stored procedures.

B. Update statistics low on all tables.

C. Update statistics high on all tables.

D. Update statistics medium on all tables.

Which two actions will occur when the following command is executed? (Choose two.) UPDATE STATISTICS HIGH AUTO

A. Stored Procedures will be recompiled.

B. Update statistics will run high on the table named AUTO.

C. Update statistics will run high only on the first column of an index.

D. Update statistics will run high only after the optimizer decides the statistics are too old.

E. Update statistics will run high only on columns which meet the STATSCHANGE threshold.