IBM IBM Certified System Administrator C2090-919 Questions & Answers

• Question 51:

  Assuming the DBSPACETEMP onconfig and environment variables are set to valid dbspace names, where is the first location the instance will attempt to create a temporary non logged table?

  A. rootdbs.

  B. Thedbspace the database was created in.

  C. One of thedbspaces listed in the DBSPACETEMP environment variable.

  D. One of thedbspaces listed in the DBSPACETEMP configuration parameter.

  Correct Answer: C

• Question 52:

  Which of the following is NOT in the machine notes?

  A. Operating system requirements.

  B. Critical kernel tuning parameters.

  C. A descriptive list of the new features in the port.

  D. Featuresthat are not available for the version and O/S.

  Correct Answer: C

• Question 53:

  What two parameters can affect how often checkpoints occur? (Choose two.)

  A. LOGSIZE

  B. PHYSFILE

  C. LTAPEDEV

  D. BUFFERPOOL

  E. BAR_PROGRESS_FREQ

  Correct Answer: AB

• Question 54:

  Given the following SQL statement:

  

  WHEN MATCHED THEN DELETE What does the merge statement do?

  A. Deletes rows in tab2 that match the condition col1 = c1.

  B. Deletes rows in tab1 that match the condition col1 = c1.

  C. Deletes rows in tab1 that match the condition col1 = c1 and deletes rows in tab2 that do not match the condition col1 = c1.

  D. Deletes rows in tab1 that match the condition col1 = c1 and insert rows in tab1 from those in tab2 that do not match the condition.

  Correct Answer: B

• Question 55:

  Which utility requires database logging be turned off to load a table?

  A. load

  B. dbload

  C. onload

  D. dbimport

  Correct Answer: C

• Question 56:

  How does the Deployment Assistant enable you to reduce the size of the installation to be deployed?

  A. By limiting the size ofdbspaces.

  B. By removing specific databases.

  C. By removing specific product features.

  D. By removing all free space at the end of a chunk.

  Correct Answer: C

• Question 57:

  Which is NOT valid information in the SQLHOSTS connectivity file (or on windows the SQLHOSTS registry key)?

  A. Connection type.

  B. Number of listener threads.

  C. Host name and service name.

  D. Database server name or alias.

  Correct Answer: B

• Question 58:

  Which statement is NOT true for interval fragmentation?

  A. A NULL fragment is allowed.

  B. A remainder fragment is allowed.

  C. Fragments cannot be overlapping.

  D. A fragment key can have only a single column.

  Correct Answer: B

• Question 59:

  Given the two indexes defined on table tab1:

  

  Which optimization method may be used?

  A. STAR_JOIN

  B. MULTI_INDEX

  C. OUTER_INDEX

  D. INDEX_SELFJOIN

  Correct Answer: B

• Question 60:

  Given the following table, what happens if you insert a row with an id of 450?

  

  A. The new row will be placed in the fragment p1.

  B. An error is returned stating that there is no suitable fragment.

  C. A new fragment is automatically added to store values >= 400 and < 500.

  D. A new fragment is automatically added to store values >= 200 and < 500.

  Correct Answer: C