IBM Certified Database Administrator - IBM IMS - C9050-548 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What are some of the benefits of DB2 Express?

A. DB2 Express is designed for development and testing. It is not used as a production database. B. DB2 Express is faster and more powerful than the DB2 product. C. DB2 Express has affordable licensing terms with all of the features of the DB2 engine. D. DB2 Express is a tool that allows the DBA to quickly solve (expressly) complex issues with theDB2
version of software.

Discussion 0

Correct Answer: C Vote an answer

Question 2

What is DB2 Express-C?

A. DB2 Express-C is a no-charge data server version of the DB2 Express edition for thecommunity. B. DB2 Express-C is latest version of DB2 Express, which follows the former versions DB2Express-A and
DB2 Express-B. C. DB2 Express-C is the command-line interface for the DB2 Express product. D. DB2 Express-C is not an existing product.

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which DB2 licensing type is based on the number of users allowed to access the data server?

A. Authorized User (AU) licensing B. Sub-capacity licensing C. PVU (Processor Value Unit) licensing D. Per Server licensing

Discussion 0

Correct Answer: A Vote an answer

Question 4

Your IMS System uses dual OLDS logging and the Archive job runs successfully and produces one SLDS
datasets and two RLDS dataset. Archiving will make which changes to RECON Log Records?

A. 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. B. 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. C. 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. D. 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.

Discussion 0

Correct Answer: A Vote an answer

Question 5

Which one of the following statements is true?

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 hierarchical sequence). D. 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.}

Discussion 0

Correct Answer: A Vote an answer

Question 6

What is the DB2 journal?

A. The DB2 journal is a feature that allows for commands in a transaction to be rolled back. All commands
that have been executed in a particular transaction can be undone using the DB2journal. B. The DB2 journal is a free newsletter that is published monthly to subscribers and that has articles of
interest to DBAs. C. DB2 does not have a journal. D. The DB2 journal is a GUI that displays historical information about tasks, database actions and
operations, control center actions, messages, and alerts in your DB2 database.

Discussion 0

Correct Answer: C Vote an answer

Question 7

What is the purpose of the Adaptive, self-tuning memory allocation feature in DB2?

A. The purpose of this feature is for the system to deliver to you a report of tuning specifications for the
database so that you can update the configuration parameters by hand. B. This feature does not exist in DB2. C. This feature will detect memory allocation expansion in the database and deliver a warning to the DBA
to let them know when the database is nearing a threshold space allocation limit. D. This feature will help to reduce the task of configuring your DB2 server by continuously updating
configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory
to be used by the database.

Discussion 0

Correct Answer: D Vote an answer

Question 8

If the user specifies multiple PCBs for a single database in a PSBGEN, which statement is correct?

A. It allows for multiple positions. B. The processing options must be identical. C. It is illegal. D. Only one of them can be used.

Discussion 0

Correct Answer: A Vote an answer

Question 9

What does the DB2 export utility do?

A. The export utility does not exist in DB2. B. The DB2 export utility allows you to import data that was exported from another DB2 database into one
of your specified tables. C. The DB2 export utility exports data from a table or view to a file. D. The DB2 export utility is a command-line interface that allows you to export your entire DB2database
into another vendor database format, which you specify as a command-line option.

Discussion 0

Correct Answer: C Vote an answer