IBM Certified Database Administrator - IBM IMS - C9050-548 Exam Practice Test

A. Database Name

B. Segment Length

C. Status Code

D. Segment Name

A. DB2 Workload Management allows you to assign resources to different workloads, which leads to a
stable and predictable execution environment.

B. DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.

C. DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs,
REORGs, or RUSTATS.

D. DB2 Workload Management requires several application changes in order to make the application
aware of the WLM feature.

A. A PRISLD RECON record is created; the PRILOG record will be updated to include the primary SLDS
dataset name and the SECLOG record will be updated to include the secondary RLDS dataset name.

B. A PRISLD, a PRIRLDS and a SECRLDS RECON record are created; the PRILOG record will be
updated to include the primary RLDS dataset name and the SECLOG record will be updated to include
the Secondary RLDS dataset name.

C. A PRISLD and a SECSLD RECON record are created; the PRILOG record will be updated to include
the primary RLDS dataset name and the SECLOG record will be updated to include the secondary RLDS
dataset name.

D. A PRISLD RECON record is created; the PRILOG record will be updated to include the primary RLDS
dataset name and the SECLOG record will be updated to include the secondary RLDS dataset name.

A. DB2 can only be purchased pre-installed on an IBM server. There is no need to ever installDB2.

B. DB2 can only be installed from a command prompt using command-line entries.

C. DB2 can be installed using the DB2 installation wizard.

D. DB2 must be installed on RAM drive on the server to speed up performance of the database.

A. Temporal tables require constant changes to the operating system timestamp in order to navigate
through time in the database.

B. Temporal tables are used to model data in the past, present, and future.

C. Temporal tables are complex to maintain and require major application changes.

D. Temporal tables are used to model data in the past and present. They cannot be used to model data in
the future.

A. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the
root (in hierarchical sequence) for which there is space. The remainingsegments of the database record
are put in the overflow dataset.

B. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the
root (in insertion sequence).

C. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the
root (in insertion sequence) for which there is space. The remainingsegments of the database record are
put in the overflow dataset.}

D. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the
root (in hierarchical sequence).

A. LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and
columns.

B. With RCAC users do not get an error when accessing protected data, while with LBAC users can get
an error if they don't have the necessary credentials to access a LBAC protected column.

C. RCAC returns the data based on what is being asked (data centric), while LBAC returns data based on
who is asking what (user centric). Users with DATAACCESS authority are exempt from the Row and
Column Access Control rules.

D. RCAC is a fixed label security model designed for the US government while LBAC is a general purpose
security model best suited for commercial customers.

A. The DB2 load utility is a tool that stores all scripts that are required to create the database. Itdoes not
load data, but just loads the database metadata that was exported for a site backup.

B. The DB2 load utility is a high-speed, low-level, data loading utility that loads data into a DB2database
in four phases.

C. The DB2 load utility is a tool that allows you to directly transfer data from one database into theone you
are currently working with.

D. The DB2 load utility does not exist in the DB2 product.

A. Verification can be done by successfully creating a SAMPLE database and running SQL commands to
retrieve sample data.

B. Verification is completed by the DBA using the database verification toolkit.

C. Verification is performed by running the VERIFY INSTALL command.

D. Verification is automatically performed by the AUTO_CONFIGURE feature.