C2090-919 Online Practice Questions and Answers

How is the DBSSO group determined on a Unix system with role separation?

A. It is always the groupinformix.

B. It is set using theonsecurity command line tool.

C. It is the group that owns $INFORMIXDIR/dbssodir.

D. It is the group specified in the DBSSOonconfig parameter.

Which of the following privileges is NOT valid for a table fragment?

A. ALL

B. INSERT

C. UPDATE

D. CREATE INDEX

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

Which statement about updating statistics is NOT true?

A. UPDATE STATISTICS HIGH scans the entire table.

B. Data distributions are updated every time UPDATE STATISTICS LOW is executed.

C. UPDATE STATISTICS operations will benefit by tuning the DBUPSPACE environment variable.

D. An UPDATE STATISTICS LOW command will ignore tables and indexes with modifications less than STATCHANGE.

Given the SQL explain output of this star join query, which is the fact table?

A. sales

B. product

C. region

D. customer

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.

Identify a scenario when you CANNOT use in-place migration?

A. When you want to change database locale.

B. When you want to migrate from a 32-bit to a 64-bit port of Informix.

C. When you want to defragment some of the heavily fragmented tables.

D. When you want to use new configuration features in the new Informix version.

Which two statements are true for onbar only but not for ontape? (Choose two.)

A. It can apply external programs using filters.

B. It can restart a restore from the place it failed.

C. It can back up to or restore from cloud storage.

D. It can restore data to a given point in time (PIT).

E. It can execute an external backup and restore.

What is a requirement for online attach/detach of fragments?

A. The table cannot have constraints.

B. The table must have a unique index.

C. The table must have a remainder fragment.

D. The table fragmentation scheme and the index fragmentation scheme must be identical.

Which of the following gives a good initial estimate for the physical log size?

A. 110% ofrootdbs.

B. 110% the default buffer pool.

C. 110% of the logical log space.

D. 110% of combined buffer pool.