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

Certensure Logo
  1. Home
  2. IBM
  3. IBM Certified System Administrator
  4. C2090-619 - IBM Informix 12.10 System Administrator

IBM C2090-619 IBM Informix 12.10 System Administrator Exam Practice Test

Demo: 19 questions
Total 130 questions
Get C2090-619 Full Access Download C2090-619 PDF

IBM Informix 12.10 System Administrator Questions and Answers

Question 1

Which option is available through ifx_grid_connect()?

Options:

A.

Rename a replicated database.

B.

Enable use of TimeSeries columns in tables.

C.

Enable automatic creation of templates in a grid.

D.

Defer propagation of DDL statements to other servers in the grid.

Question 2

Which OpenAdmin Tool feature is used to analyze the state of the Informix database server and can alert the DBA through email?

Options:

A.

SQL Toolbox

B.

Health Advisor

C.

Server Administration

D.

Performance Analysis

Question 3

Which type of device does Primary Storage Manager support?

Options:

A.

File

B.

Tape

C.

Directory

D.

Named pipe

Question 4

Which Enterprise Replication command CANNOT be used on replicates that include TimeSeries columns?

Options:

A.

cdr start

B.

cdr sync

C.

cdr realize

D.

cdr remaster

Question 5

Given these statements are executed:

which statement is true?

Options:

A.

The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.

B.

The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator(IWA).

C.

The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), and

OLAP expressions are evaluated by Informix database server.

D.

The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAPexpressions are evaluated by Informix Warehouse Accelerator (IWA).

Question 6

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

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.

Question 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

Question 8

Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1 int); Which statement is true?

Options:

A.

The temp table will be created in datadbs1.

B.

The temp table will be created in root dbspace.

C.

The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.

D.

The temp table will be created round-robin across the dbspaces in DBSPACETEMP.

Question 9

Which statement is true regarding the selective row-level auditing feature in Informix?

Options:

A.

You can create audit masks corresponding to row-level events of a specific table.

B.

Selective row-level auditing must be explicitly turned on using the onshowaudit utility.

C.

When you create a table, you can specify if row-level auditing should be enabled for the table.

D.

When you create a database, you can specify if row-level auditing should be enabled for all the tables within the database.

Question 10

What data migration tool(s) should be used to load data from a non-Informix data source?

Options:

A.

dbimport

B.

onload and dbload

C.

dbload and High Performance Loader

D.

onload and High Performance Loader

Question 11

Which statement is FALSE about Informix Automatic checkpoint Feature?

Options:

A.

Automatic checkpoints cause less logical log activity.

B.

Automatic checkpoints try to avoid transaction blocking.

C.

Automatic checkpoints cause the database server to trigger more frequent checkpoints.

D.

Automatic checkpoints can be dynamically enabled or disabled by using onmode -wm or onmode -wf.

Question 12

When free memory is limited, which configuration parameter should be set to allow critical database activities to complete successfully?

Options:

A.

LOW_MEMORY_SVR

B.

LOW_MEMORY_MGR

C.

LOW_MEMORY_RESERVE

D.

LOW_MEMORY_PRESERVE

Question 13

Assuming network connectivity between two Informix instances, which file may need additional configuration to allow distributed queries?

Options:

A.

sqlhosts

B.

/etc/services

C.

$ONCONFIG

D.

/etc/hosts.equiv

Question 14

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

Question 15

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

Options:

A.

ifxdeploy

B.

genoncfg

C.

dbaccess

D.

onparams

Question 16

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

Question 17

Which option maximizes performance in an Informix Warehouse (DSS) environment?

Options:

A.

Higher value of LOGBUFF.

B.

Higher value of PHYSBUFF.

C.

Higher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.

D.

SHMTOTAL set to 0 to allow Informix to access all available physical memory.

Question 18

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.

Question 19

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

Options:

A.

HA_FOC_ORDER

B.

FAILOVER_CALLBACK

C.

CLUSTER_TXN_SCOPE

D.

FAILOVER_TX_TIMEOUT

Load More C2090-619 Questions
Demo: 19 questions
Total 130 questions
Get C2090-619 Full Access Download C2090-619 PDF