C2090-619 IBM Exam Questions and Free Practice Test

Which statement is FALSE about dbspace configurable page sizes?

A. Dbspace page size can only be set for non-critical dbspaces.

B. Possible page sizes are multiples of the default page size up to 16 kb.

C. Configure page sizes as close to the backup / restore and network buffer size as possible for efficient data transfer across the wire.

D. Dbspace page size should be configured to accommodate the greatest number of average row sizes with a minimum of remainder pages being used.

Correct Answer:C

Where are the Primary Storage Manager catalog tables stored?

A. sysutils database

B. sysadmin database

C. sysmaster database

D. A location as specified by the PSM_CATALOG_PATH configuration parameter

Correct Answer:D

Which log file CANNOT be rotated using the default "message log rotate" SQL admin command?

A. audit log

B. message log

C. onbar debug log

D. onbar activity log

Correct Answer:A

Which statement about Storage Provisioning is true?

A. Only raw devices can be extended.

B. Only cooked devices can be extended.

C. Only unmirrored spaces can be extended.

D. Mirrored and unmirrored spaces can be extended.

Correct Answer:C

Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer (customer_num); Which catalog table data is NOT updated?

A. sysdistrib

B. systables

C. sysindexes

D. syscolumns

Correct Answer:A

In which table can you find a history of all SQL Administration API functions executed in the last 30 days?

A. sysadmin:admin_history

B. sysmaster:admin_history

C. sysadmin:command_history

D. sysmaster:command_history

Correct Answer:C

START C2090-619 EXAM