Labour Day Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia
  1. Home
  2. IBM
  3. IBM Certified System Administrator
  4. C2090-619
  5. IBM Informix 12.10 System Administrator Questions and Answers

C2090-619 Sample Questions Answers

Questions 4

Which configuration parameter can toggle the automatic expansion of storage spaces?

Options:

A.

SP_AUTOGROW

B.

SP_AUTO_SPACE

C.

SP_AUTOEXPAND

D.

SP_EXPAND_ENABLE

Buy Now
Questions 5

Which is NOT a feature of onbar backups?

Options:

A.

The ability to parallelize backups.

B.

The ability to do a point-in-time restore.

C.

The ability to backup without a storage manager.

D.

The ability to do an external backup using a Storage Area Network.

Buy Now
Questions 6

Which is NOT a valid index fragmentation strategy?

Options:

A.

Fragment by Range

B.

Partition by Expression

C.

Fragment by Expression

D.

Fragment by Round Robin

Buy Now
Questions 7

You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?

Options:

A.

stores:sysusers

B.

sysmaster:sysroles

C.

sysuser:sysroleauth

D.

sysmaster:sysusers

Buy Now
Questions 8

When KAIO is available and raw disk is used, which statement is true?

Options:

A.

Logical Log IO is performed by the LIO VP.

B.

Physical Log IO is performed by the PIO VP.

C.

Logical Log IO is performed by the KAIO VP.

D.

Physical Log IO is performed by the CPU VP.

Buy Now
Questions 9

When configuring Informix server for DRDA connection, which statement is true?

Options:

A.

The connection protocol must be drsoctcp.

B.

The database server name for DRDA connection must correspond to the DBSERVERNAME onconfig parameter.

C.

The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.

D.

The database server name should correspond to either the DBSERVERNAME or the DBSERVERALIASES onconfig parameter.

Buy Now
Questions 10

Which HDR configuration parameter provides three synchronization modes to control when transaction commits are returned to client applications?

Options:

A.

DELAY_APPLY

B.

HDR_TXN_SCOPE

C.

LOG_INDEX_BUILDS

D.

FAILOVER_TX_TIMEOUT

Buy Now
Questions 11

Which two technologies use the ENCRYPT_MAC configuration parameter to control the level of message authentication code (MAC) generation? (Choose two.)

Options:

A.

On-disk encryption

B.

Enterprise Replication

C.

Column level encryption

D.

High-Availability Data Replication

E.

Server-to-server distributed query communication

Buy Now
Questions 12

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

Options:

A.

audit log

B.

message log

C.

onbar debug log

D.

onbar activity log

Buy Now
Questions 13

Which communication protocol needs additional configuration besides onconfig and sqlhosts?

Options:

A.

TLITCP

B.

IPCSTR

C.

IPCSHM

D.

SOCSSL

Buy Now
Questions 14

Which object can be compressed?

Options:

A.

dictionary table

B.

temporary table

C.

attached b-tree index

D.

detached b-tree index

Buy Now
Questions 15

Which table attribute defines the percentage of changes (insert/update/delete) threshold to consider the statistics as stale?

Options:

A.

STATAUTO

B.

STATFORCE

C.

FORCE AUTO

D.

STATCHANGE

Buy Now
Questions 16

What is the purpose of the GRANT ADMIN privilege?

Options:

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.

Buy Now
Questions 17

Role separation provides checks and balances to improve the security of your event-auditing procedures. Which two roles must be associated with group IDs to enable role separation? (Choose two.)

Options:

A.

DBSEC: DB Security Officer

B.

AAO: Auditing Analysis Officer

C.

DBASO: DB Audit and Security Officer

D.

DBAMO: DB Audit Management Officer

E.

DBSSO: Database System Security Officer

Buy Now
Questions 18

Which SQL statement is used to remove detailed statistical information from the sysdistrib catalog table?

Options:

A.

UPDATE STATISTICS DISTRIBUTIONS ONLY

B.

UPDATE STATISTICS LOW DROP DISTRIBUTIONS

C.

UPDATE STATISTICS LOW REMOVE DISTRIBUTIONS

D.

UPDATE STATISTICS MEDIUM REMOVE DISTRIBUTIONS

Buy Now
Questions 19

An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?

Options:

A.

Increase the value of MAX_INCOMPLETE_CONNECTIONS.

B.

Increase the value of NUMFDSERVERS and add more poll threads.

C.

Increase the value of NUMFDSERVERS and increase the number of MSC VPs.

D.

Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.

Buy Now
Status:
Expired
Exam Code: C2090-619
Exam Name: IBM Informix 12.10 System Administrator
Last Update: Mar 14, 2024
Questions: 130
$64  $159.99
$48  $119.99
$40  $99.99
buy now C2090-619