Black Friday Special Sale - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: spcl70

Note! C2090-619 has been withdrawn.

Practice Free C2090-619 IBM Informix 12.10 System Administrator Exam Questions Answers With Explanation

We at Crack4sure are committed to giving students who are preparing for the IBM C2090-619 Exam the most current and reliable questions . To help people study, we've made some of our IBM Informix 12.10 System Administrator exam materials available for free to everyone. You can take the Free C2090-619 Practice Test as many times as you want. The answers to the practice questions are given, and each answer is explained.

Get Full 130 Questions Search Other IBM Exam
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

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.

Question # 8

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

A.

ifxdeploy

B.

genoncfg

C.

dbaccess

D.

onparams

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

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

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

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.

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.

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.

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.

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

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

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

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.