Download Informix 11.70 System Administrator.C2090-919.PassGuide.2015-03-27.110q.vcex

Vendor: IBM
Exam Code: C2090-919
Exam Name: Informix 11.70 System Administrator
Date: Mar 27, 2015
File Size: 485 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
How many paging files are required for SD secondary instances?
  1. There should always be two.
  2. It depends on how many CPU VPs you have.
  3. It depends on how many data dbspaces you have.
  4. It depends on how many temporary dbspaces you have.
Correct answer: A
Question 2
What statement about users accessing a Flexible Grid is true?
  1. Every user can execute commands on the Flexible Grid.
  2. Only user informix can execute commands on a Flexible Grid.
  3. Users have to be authorized to execute Flexible Grid commands.
  4. Commands can only be executed from the node on which the Flexible Grid was created.
Correct answer: C
Explanation:
answer is valid.
answer is valid.
Question 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?
  1. Any available SDS (Shared Disk Secondary) server, then report_server.
  2. Report_server, then any available SDS server. 
  3. Report_server, then the SDS server with most available resources.
  4. The server with the most available resources in the SLA list, including all SDS servers and report_server.
Correct answer: D
Question 4
Which of the following is NOT a step in setting up HDR for the first time?
  1. Take a level 0 backup of the primary.
  2. Use oninit -v to bring up the secondary.
  3. Execute a physical restore on the secondary.
  4. Use onmode -d to specify the secondary instance name.
Correct answer: B
Question 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?  
  1. The changes cannot be replicated.
  2. The changes are replicated by default. 
  3. You have to call ifx_set_erstate( ) to replicate changes.
  4. Only changes to primary key columns can be replicated.
Correct answer: C
Question 6
Given the following:
  
  1. Update three rows.
  2. Update one row and insert two rows.
  3. Update two rows and insert one row.
  4. Return a 26095 error - Cannot update or delete a row twice in a MERGE statement.
Correct answer: C
Explanation:
 
 
Question 7
Given the following SQL statement:
  
What does the merge statement do?
  1. 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.
  2. 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.
  3. 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.
  4. 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 corresponding rows in tab1.
Correct answer: B
Question 8
Which list fragmentation statement is true?
  1. It cannot be used for indexes.
  2. It allows overlapping fragments.
  3. It can only be used for numeric columns.
  4. It allows a fragment to be defined as a remainder. 
Correct answer: D
Question 9
Fragment level statistics are NOT supported with which fragmentation strategy?
  1. List fragmentation.
  2. Interval fragmentation.
  3. Expression fragmentation.
  4. Round-robin fragmentation.
Correct answer: D
Question 10
Given the SQL explain output of this star join query, which is the fact table? 
  
  1. sales
  2. product
  3. region
  4. customer
Correct answer: A
Explanation:
 
 
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!