Summer Sale Coupon - 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sbfdisc

Note! C2090-619 has been withdrawn.

C2090-619 Practice Exam Questions with Answers IBM Informix 12.10 System Administrator Certification

Question # 6

The IBM Mobile Database is a mobile-optimized version of which IBM product?

A.

IBM DB2

B.

IBM Informix

C.

IBM solidDB

D.

IBM Cloudscape

Full Access
Question # 7

The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

A.

The user encounters a lock request error.

B.

More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.

C.

More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.

D.

More memory is allocated for additional lock structures in the RESIDENT section of shared memory.

Full Access
Question # 8

Which Informix utility can be used to customize the onconfig file?

A.

ifxdeploy

B.

genoncfg

C.

dbaccess

D.

onparams

Full Access
Question # 9

Which fragmentation strategy is capable of generating new fragments automatically?

A.

Fragment by List

B.

Fragment by Range

C.

Fragment By Expression

D.

Fragment by Round Robin

Full Access
Question # 10

Which parameter can automatically adjust other configuration parameters that are not present in the configuration file?

A.

AUTO_PERF

B.

AUTO_TUNE

C.

AUTO_CONFIG

D.

AUTO_ENABLE

Full Access
Question # 11

The DBA has defined the following configuration parameters in the onconfig file:

C2090-619 question answer

What are the actual values for LMM START THRESHOLD and LMM STOP THRESHOLD computed internally by the database server?

A.

LMM START THRESHOLD = 2MB and LMM STOP THRESHOLD = 3MB

B.

LMM START THRESHOLD = 20MB and LMM STOP THRESHOLD = 30MB

C.

LMM START THRESHOLD = 500MB and LMM STOP THRESHOLD = 333MB

D.

LMM START THRESHOLD = 2% and LMM STOP THRESHOLD = 3% of physical memory in the system

Full Access
Question # 12

Which statement is true for starting Connection Manager?

A.

Only user root and informix.

B.

Any user of the DBSA group.

C.

Any user who is granted privileges to connect to the sysadmin database.

D.

Only a user of the DBSA group with privilege to connect to the sysadmin database.

Full Access
Question # 13

What is the purpose of the GRANT ADMIN privilege?

A.

Grants the admin privilege to create role separation.

B.

Grants the admin privilege to perform DBSA functions.

C.

Grants the admin privilege to use the Open Admin Tool.

D.

Grants the admin privilege to run SQL administration API commands.

Full Access
Question # 14

What is the primary benefit of a Storage Pool?

A.

It allows data to be shared across instances.

B.

It allows data to be shared across dbspaces.

C.

It allows space to automatically be added to dbspaces.

D.

It allows space to be reserved for critical database operations.

Full Access
Question # 15

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.

Full Access
Question # 16

Which ONCONFIG parameter would you use to disable the automatic creation or extension of chunks?

A.

SP_WAITTIME

B.

SP_THRESHOLD

C.

SP_AUTOEXPAND

D.

SP_CHUNKEXTEND

Full Access
Question # 17

When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?

A.

LOW_MEMORY_SVR

B.

LOW_MEMORY_MGR

C.

LOW_MEMORY_RESERVE

D.

LOW_MEMORY_PRESERVE

Full Access
Question # 18

Which Enterprise Replication command CANNOT be used on replicates that include TimeSeries columns?

A.

cdr start

B.

cdr sync

C.

cdr realize

D.

cdr remaster

Full Access
Question # 19

Which statement is FALSE regarding SBSPACES?

A.

They are recoverable.

B.

They do not obey transaction isolation modes.

C.

They have read, write, and seek properties similar to a standard UNIX file.

D.

Smart large objects within table rows are not required to be retrieved in one statement.

Full Access