Free IBM A2090-919 Exam Dumps Questions & Answers

When a SELECT statement is executed which statement is true?

• A.  If the SELECT is part of an UPDATE cursor then the database server will place an exclusive lock on the entire dataset.
• B.  Within a transaction the database server will place row or page locks on a nonlogging table.
• C.  The number and duration of the locks is dependent on the ISOLATION LEVEL.
• D.  If COMMITTED READ isolation is in place then the SELECT will never encounter any locking errors.

Which list fragmentation statement is true?

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

Given the following SLA definition:
SLA group_1=HDR+(inst_2+inst_3)+SDS
How will new connections be routed through the SLA?

• A.  The HDR instance first, then inst_2, followed by inst_3, finally to any SD secondary instance.
• B.  Load balanced between inst_2 and inst_3, then either HDR or any SD secondary instance.
• C.  The HDR instance first, load balanced between inst_2 and inst_3, then to any SD secondary instance.
• D.  Load balanced between all secondary instances.

Which command line utility displays real time statistics about the instance?

• A.  dbschema
• B.  onstat
• C.  dbinfo
• D.  onmachinfo

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

• A.  dbimport
• B.  load
• C.  dbload
• D.  onload