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

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

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

Question 2

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.

Question 3

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 4

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.

Question 5

Which two parameters must be set to a valid value before starting a Shared Disk (SD) Secondary server? (Choose two.)

Options:

A.

SDS_PAGING

B.

SDS_TIMEOUT

C.

SDS_TEMPDBS

D.

SDS_LOGCHECK

E.

SDS_ALTERNATE

Question 6

Click on the exhibit. Which type of join is occurring?

Options:

A.

Star Join

B.

ANSI Join

C.

Index Self-Join

D.

Multi Index Join

Question 7

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 8

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

Question 9

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?

Options:

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.

Question 10

The following message is received: Lock table overflow - user id user32, session id 54. What action should be taken to prevent this problem in the future?

Options:

A.

Run onclean utility to clear the lock table.

B.

Increase the LOCKS configuration parameter.

C.

Turn on the AUTO_TUNE configuration parameter.

D.

Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.

Question 11

What is the primary benefit of a Storage Pool?

Options:

A.

It allows data to be shared across instances.

B.

It allows data to be shared across dbspaces.

C.

It allows space to automatically be added to dbspaces.

D.

It allows space to be reserved for critical database operations.

Question 12

Consider the following Enterprise Replication command: cdr define template temp1 -c g_serv1 -C ignore -a -d testdb. Which statement is TRUE?

Options:

A.

The command defines a template to be realized on servers serv4 and serv5.

B.

The command defines a template to exclude database testdb from replication.

C.

The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.

D.

The command defines a template to replicate the entire database testdb by defining replicates for each of the views and system tables in

testdb.

Question 13

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.

Question 14

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 15

What is the earliest version you can migrate / upgrade directly to Informix 12.10?

Options:

A.

7.30

B.

8.0

C.

9.40

D.

10.0

Question 16

When the server is in administration mode, which users are NOT allowed to connect?

Options:

A.

informix

B.

Members of the DBSA group

C.

Members of the DBSSO group

D.

Users specified by ADMIN_MODE_USERS

Question 17

In which table can you find a history of all SQL Administration API functions executed in the last 30 days?

Options:

A.

sysadmin:admin_history

B.

sysmaster:admin_history

C.

sysadmin:command_history

D.

sysmaster:command_history

Question 18

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 19

During the database server initialization process, a number of environment variables are required. What is the order of precedence if the -file option is used?

Options:

A.

User local shell, system global

B.

System global, user local shell

C.

System global, user local shell, onconfig file

D.

Onconfig file, user local shell, system global

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