New Year Special Sale - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dm70dm

Hot Vendors
  1. Home
  2. IBM
  3. IBM Certified System Administrator
  4. C2090-619
  5. IBM Informix 12.10 System Administrator Questions and Answers
Note! The C2090-619 Exam is no longer available.

C2090-619 IBM Informix 12.10 System Administrator Questions and Answers

Questions 4

Which two parameters are mandatory when running "ifxclone"? (Choose two.)

Options:

A.

Target server instance size.

B.

Target server instance name.

C.

Source server instance sqlhosts.

D.

Target server configuration parameters.

E.

Source server instance TCP/IP address.

Buy Now
Questions 5

Which statement is true regarding default roles?

Options:

A.

The DBSA can define a default role to assign only to the PUBLIC group for a particular database.

B.

The privileges associated with a default role takes precedence over the privileges granted to an individual user.

C.

The DBSA can define a default role to assign to individual users or to the PUBLIC group for a particular database.

D.

When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.

Buy Now
Questions 6

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 7

Where must the HA_FOC_ORDER configuration parameter be set?

Options:

A.

Any server in the cluster.

B.

The primary server only.

C.

The SDS secondary only.

D.

The HDR secondary only.

Buy Now
Questions 8

The sector option for cdr utility is used to perform what operation?

Options:

A.

Dynamically convert ER cluster instances in order to perform rolling upgrades.

B.

Dynamically convert H/A cluster instances in order to perform rolling upgrades.

C.

Dynamically reconfigure Connection Manager SLAs for ER clusters in order to perform rolling upgrades.

D.

Dynamically reconfigure Connection Manager SLAs for H/A clusters in order to perform rolling upgrades.

Buy Now
Questions 9

store1, store2, store3 and store4 are defined as four servers participating in a GRID.

C2090-619 Question 9

Which statement is true?

Options:

A.

The SELECT query is not a GRID query.

B.

The SELECT query will return results from all grid servers.

C.

The SELECT query will return results from store1 and store2.

D.

The SELECT query will return results from store3 and store4.

Buy Now
Questions 10

Which step must be performed to enable Secure Socket Layer (SSL) connections to Informix?

Options:

A.

Configure encrypt virtual processors in the ONCONFIG file.

B.

Configure poll threads for SSL connections in the ONCONFIG file.

C.

Specify the SSL connection protocol in the sqlhosts file or registry entry.

D.

Specify the name of the label of the server digital certificate in the ONCONFIG file.

Buy Now
Questions 11

The 'onstat -k' output is showing '56 lock table overflows'. Which catalog table can be used to display the relevant lock statistics?

Options:

A.

syslocks

B.

systables

C.

sysprofile

D.

sysoverflow

Buy Now
Questions 12

Which fragmentation strategy is capable of generating new fragments automatically?

Options:

A.

Fragment by List

B.

Fragment by Range

C.

Fragment By Expression

D.

Fragment by Round Robin

Buy Now
Questions 13

After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?

Options:

A.

sarah

B.

karin and dave

C.

karin and sarah

D.

karin, dave and sarah

Buy Now
Questions 14

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 15

An Enterprise Replication server is a primary server for shared-disk secondary servers. The DBA wants to reduce the replication latency by reducing the number of transactions that are applied before the logs are flushed to disk. What configuration parameter should the DBA modify?

Options:

A.

CDR_MAX_TXNS

B.

CDR_TSINSTANCEID

C.

CDR_MAX_FLUSH_SIZE

D.

CDR_LOG_LAG_ACTION

Buy Now
Questions 16

Which configuration parameter locks the resident and virtual segments of shared memory in operating-system physical memory?

Options:

A.

SHMSEG

B.

SHMBASE

C.

RESIDENT

D.

INFORMIXSHMLCK

Buy Now
Questions 17

How do the MAX_PDQPRIORITY onconfig parameter and the PDQPRIORITY environment variable work together to constrain access to PDQ resources?

Options:

A.

PDQPRIORITY is the only constraint.

B.

MAX_PDQPRIORITY is the only constraint.

C.

The minimum of the two values is the actual constraint.

D.

The constraint is MAX_PDQPRIORITY / 100 * PDQPRIORITY / 100.

Buy Now
Questions 18

Which two actions can you perform with ontape? (Choose two.)

Options:

A.

Backup to cloud

B.

Restartable restore

C.

Backup specific storage spaces

D.

Restore specific storage spaces

E.

Parallel backup of storage spaces

Buy Now
Questions 19

Which option provides the greatest performance benefit in an Informix warehouse environment?

Options:

A.

Setting lower value of PDQPRIORITY.

B.

Increasing the number of B-Tree cleaners.

C.

Setting higher value of DS_TOTAL_MEMORY.

D.

Setting value of OPT_GOAL configuration variable to 0.

Buy Now
Exam Code: C2090-619
Exam Name: IBM Informix 12.10 System Administrator
Last Update: Mar 13, 2024
Questions: 130
dumpsmate guaranteed to pass
24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 27 Dec 2024