IBM IBM Certified System Administrator C2090-919 Questions & Answers

• Question 81:

  Which sbspaces statement is FALSE?

  A. Sbspaces may be recoverable.

  B. Sbspaces can be of varying page size.

  C. Sbspaces may be part of round robin fragmentation.

  D. Sbspaces have read, write and seek properties similar to UNIX functions.

  Correct Answer: B

• Question 82:

  Which list fragmentation statement is true?

  A. It cannot be used for indexes.

  B. It allows overlapping fragments.

  C. It can only be used for numeric columns.

  D. It allows a fragment to be defined as a remainder.

  Correct Answer: D

• Question 83:

  Fragment level statistics are NOT supported with which fragmentation strategy?

  A. List fragmentation.

  B. Interval fragmentation.

  C. Expression fragmentation.

  D. Round-robin fragmentation.

  Correct Answer: D

• Question 84:

  Given the following:

  

  A. Update three rows.

  B. Update one row and insert two rows.

  C. Update two rows and insert one row.

  D. Return a 26095 error - Cannot update or delete a row twice in a MERGE statement.

  Correct Answer: C

• Question 85:

  Given the following SQL statement:

  

  What does the merge statement do?

  A. 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.

  B. For the rows that match the condition col1 = c1, it adds thethe c2 column value to the col2 column value and updates corresponding rows in tab1.

  C. 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.

  D. 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 86:

  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?

  A. The changes cannot be replicated.

  B. The changes are replicated by default.

  C. You have to callifx_set_erstate( ) to replicate changes.

  D. Only changes to primary key columns can be replicated.

  Correct Answer: C

• Question 87:

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

  A. Take a level 0 backup of the primary.

  B. Useoninit -v to bring up the secondary.

  C. Execute a physical restore on the secondary.

  D. Useonmode -d to specify the secondary instance name.

  Correct Answer: B

• Question 88:

  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?

  A. Any available SDS (Shared Disk Secondary) server, thenreport_server.

  B. Report_server, then any available SDS server.

  C. Report_server, then the SDS server with most available resources.

  D. The server with the most available resources in the SLA list, including all SDS servers andreport_server.

  Correct Answer: D

• Question 89:

  Which option would be used with "cdr define replicate" to create a shadow replicate?

  A. --backup

  B. --mirrors

  C. --shadow

  D. --synchronize

  Correct Answer: B

• Question 90:

  How many paging files are required for SD secondary instances?

  A. There should always be two.

  B. It depends on how many CPU VPs you have.

  C. It depends on how many datadbspaces you have.

  D. It depends on how many temporarydbspaces you have.

  Correct Answer: A