IBM Informix 11.70 System Administrator Set 1

1.

How many paging files are required for SD secondary instances?

There should always be two. It depends on how many CPU VPs you have. It depends on how many data dbspaces you have. It depends on how many temporary dbspaces you have.

2.

What statement about users accessing a Flexible Grid is true?

Every user can execute commands on the Flexible Grid. Only user informix can execute commands on a Flexible Grid. Users have to be authorized to execute Flexible Grid commands. Commands can only be executed from the node on which the Flexible Grid was created.

3.

A Connection Manager is started with the following Service Level Agreement: SLA report=(SDS+report_server) Where will a connection to the report SLA be redirected?

Any available SDS (Shared Disk Secondary) server, then report_server. Report_server, then any available SDS server. Report_server, then the SDS server with most available resources. The server with the most available resources in the SLA list, including all SDS servers and report_server.

4.

Which of the following is NOT a step in setting up HDR for the first time?

Take a level 0 backup of the primary. Use oninit -v to bring up the secondary. Execute a physical restore on the secondary. Use onmode -d to specify the secondary instance name.

5.

Assuming you have a table with a replicate defined. A Flexible Grid procedure is executed changing data in that table. What statement about replication of the changes is true?

The changes cannot be replicated. The changes are replicated by default. You have to call ifx_set_erstate( ) to replicate changes. Only changes to primary key columns can be replicated.

6.

Given the following:

Update three rows. Update one row and insert two rows. Update two rows and insert one row. Return a 26095 error - Cannot update or delete a row twice in a MERGE statement.

7.

Given the following SQL statement: What does the merge statement do?

For each row that matches the condition col1 = c1, it inserts a new row in tab1 with the sum of corresponding c2 and col2 column values. For the rows that match the condition col1 = c1, it adds the the c2 column value to the col2 column value and updates corresponding rows in tab1. For the rows that match the condition, col1 = c1, it adds the col2 column value to the c2 column value and updates corresponding rows in tab2. Deletes rows from tab2 and updates rows in tab1 that match the condition col1 = c1 by adding the c2 column value to the col2 column value of correspondingrows in tab1.

8.

Which list fragmentation statement is true?

It cannot be used for indexes. It allows overlapping fragments. It can only be used for numeric columns. It allows a fragment to be defined as a remainder.

9.

Fragment level statistics are NOT supported with which fragmentation strategy?

List fragmentation. Interval fragmentation. Expression fragmentation. Round-robin fragmentation.

10.

Given the SQL explain output of this star join query, which is the fact table?

sales product region customer

IBM Informix 11.70 System Administrator Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Informix 11.70 System Administrator Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner