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

Dumpsbuddy Logo
  1. Home
  2. IBM
  3. IBM Certified System Administrator
  4. C2090-619
  5. IBM Informix 12.10 System Administrator Questions and Answers
Note! IBM has retired the C2090-619 Exam Contact us through Live Chat or email us for more information.

C2090-619 IBM Informix 12.10 System Administrator Questions and Answers

Questions 4

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?

Options:

A.

Mapped users

B.

Role based users

C.

Table level access for users

D.

Label based access for users

Buy Now
Questions 5

Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer (customer_num); Which catalog table data is NOT updated?

Options:

A.

sysdistrib

B.

systables

C.

sysindexes

D.

syscolumns

Buy Now
Questions 6

Several operating-system kernel configuration parameters can affect the use of shared memory by the database server. Which two kernel parameters may need to be configured? (Choose two.)

Options:

A.

Memory page size.

B.

Total number of available semaphores.

C.

Lower-boundary address for shared memory.

D.

Total memory presented to the operating system.

E.

Maximum operating-system shared-memory segment size.

Buy Now
Questions 7

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

Options:

A.

SP_WAITTIME

B.

SP_THRESHOLD

C.

SP_AUTOEXPAND

D.

SP_CHUNKEXTEND

Buy Now
Questions 8

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

Options:

A.

ifxdeploy

B.

genoncfg

C.

dbaccess

D.

onparams

Buy Now
Questions 9

Which Informix utility is used to print information about runtime statistics for all threads in the server?

Options:

A.

onstat -g sta

B.

onstat -g act

C.

onstat -g rea

D.

onstat -g cpu

Buy Now
Questions 10

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 11

Which type of device does Primary Storage Manager support?

Options:

A.

File

B.

Tape

C.

Directory

D.

Named pipe

Buy Now
Questions 12

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 13

The purge policy CANNOT be executed for a rolling window table utilizing which method?

Options:

A.

By calling the syspurge function.

B.

By the purge_tables task of the Scheduler.

C.

By setting up the server to automatically run the purge policy.

D.

By running ALTER FRAGMENT with the PURGE NOW predicate.

Buy Now
Questions 14

What command unlocks the storage catalogs when using the Primary Storage Manager?

Options:

A.

onbar -d unlock

B.

onpsm -C unlock

C.

onmode -C unlock

D.

onsmsync -c unlock

Buy Now
Questions 15

Which statement accurately describes the selective row-level auditing feature in Informix?

Options:

A.

Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.

B.

Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.

C.

Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.

D.

Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

Buy Now
Questions 16

What kinds of Table Level Restores can be done by the archecker utility?

Options:

A.

Only logical restore.

B.

Only physical restore.

C.

Only point in time restore.

D.

Physical, logical, and point in time restores.

Buy Now
Questions 17

Which statement about DataBlade modules is true?

Options:

A.

All DataBlades located in the $INFORMIXDIR/extend are automatically registered.

B.

All built-in extensions are automatically registered when the extension is first accessed.

C.

All built-in extensions are automatically registered each time the database sever is started.

D.

All built-in extensions are automatically registered when the database server is first initialized.

Buy Now
Questions 18

"informix_stores" is an established primary server with a SDS server. What is the effect of running the following command? EXECUTE FUNCTION sysadmin:admin("ha sds clear", "informix_stores");

Options:

A.

Shuts down the primary server and converts the secondary server to be the primary.

B.

Clears the log position of the SDS servers and restarts replication.

C.

Converts the shared disk secondary server to a standard server and shuts down the primary server.

D.

Stops replication to the shared disk secondary servers and converts the primary server to a standard server.

Buy Now
Questions 19

Which statement describes the behavior of an Informix instance when the IFX_EXTEND_ROLE configuration parameter is set to ON.

Options:

A.

All users with the EXTEND role can grant it to other users.

B.

All users with the default role can register external routines.

C.

All users can create external routines in the database server.

D.

All users with the EXTEND role can register external routines.

Buy Now
Exam Code: C2090-619
Exam Name: IBM Informix 12.10 System Administrator
Last Update: Dec 27, 2024
Questions: 130