Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

C2090-619 Questions and Answers

Note! Following C2090-619 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

C2090-619 Questions and Answers

Question # 6

Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)

A.

Byte

B.

Shared

C.

Update

D.

Exclusive

E.

Promotable

Full Access
Question # 7

In an organization, all employees are authenticated via domain wide Kerberos single sign-on. The DBSA wants to provide access to the database server for an employee without requesting the Operating System (OS) administrator to create a OS level user account. Which Informix feature does the DBSA need to leverage?

A.

Mapped users

B.

Role based users

C.

Table level access for users

D.

Label based access for users

Full Access
Question # 8

What does the following SQL administration command do? EXECUTE FUNCTION task("onmode", "wi", "/tmp/cfg_20130601");

A.

Apply the new values for all configuration parameters in memory.

B.

Reset the values for dynamically updatable configuration parameters to the default values and save them in onconfig.

C.

Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" in memory.

D.

Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" and save them in onconfig.

Full Access
Question # 9

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

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 # 10

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.)

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

Full Access
Question # 11

Which parameter is used to enable transactions to complete after failover of the primary server?

A.

HA_FOC_ORDER

B.

FAILOVER_CALLBACK

C.

CLUSTER_TXN_SCOPE

D.

FAILOVER_TX_TIMEOUT

Full Access
Question # 12

What is the purpose of the ifx_getMartStat() function?

A.

To display status information about the data mart.

B.

To display update statistics information about the data mart and its tables.

C.

To display statistics about the workers and coordinators defined for the accelerator.

D.

To display status information about the Informix Warehouse Accelerator and all the data marts.

Full Access
Question # 13

Which statement is true about log salvaging?

A.

ontape cannot perform salvage of logs.

B.

Log salvaging cannot be avoided if onbar is used for restore.

C.

Log salvaging is the act of restoring logical logs after physical restore, but before logical restore.

D.

Log salvaging allows for recovery of data up to the last available and uncorrupted logical-log file and the last complete transaction.

Full Access
Question # 14

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 # 15

Which storage manager allows specification of a larger size than others for BAR_XFER_BUF_SIZE?

A.

Informix Storage Manager (ISM)

B.

Informix Primary Storage Manager (PSM)

C.

Informix Secondary Storage Manager (ISSM)

D.

Informix Archive Restore Storage Environment (IARSE)

Full Access
Question # 16

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

A.

syslocks

B.

systables

C.

sysprofile

D.

sysoverflow

Full Access
Question # 17

Which two logging modes are compatible between two databases participating in a distributed query? (Choose two.)

A.

ANSI and non-ANSI

B.

Buffered and Unbuffered

C.

Buffered and Non-logging

D.

Non-logging and Unbuffered

E.

Non-logging and Non-logging

Full Access
Question # 18

Which two tasks can be performed through an Informix Grid? (Choose two.)

A.

Install Informix products.

B.

Start Informix servers in a grid.

C.

Copy external files to grid servers.

D.

Setup replication automatically in a grid.

E.

Modify replication server attributes for grid servers.

Full Access
Question # 19

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

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.

Full Access