최신IBM Certified Database Administrator - IBM IMS - C2090-548무료샘플문제

A. DB2, Oracle, SQL Server, IMS and IDMS

B. Only DB2 and Oracle

C. DB2, Oracle, Sybase ASE, SQL Server, and IDMS

D. DB2, Oracle, Sybase ASE, SQL Server, and Informix

A. A KSDS and an ESDS

B. A single KSDS only

C. A KSDS and an OSAM dataset

D. Multiple KSDSs

A. PVU (Processor Value Unit) licensing

B. Per Server licensing

C. Sub-capacity licensing

D. Authorized User (AU) licensing

A. Table partitioning allows you to create very large tables that are divided across multiplestorage objects and attach/detach large quantities of data quickly.

B. Table partitioning allows you to create result set tables from a join query, which automaticallysplits the data into smaller chucks, thereby increasing the performance of your DB2 database.

C. Table partitioning allows you to make smaller tables automatically from large tables, therebyincreasing the performance of your DB2 database.

D. Table partitioning is not a feature in DB2.

A. Change online and batch applications.

B. Modify PSBs.

C. Start an MVS address space to catch the changes.

D. Modify DBDs.

A. DB2 does not have a journal.

B. The DB2 journal is a feature that allows for commands in a transaction to be rolled back. Allcommands that have been executed in a particular transaction can be undone using the DB2journal.

C. The DB2 journal is a free newsletter that is published monthly to subscribers and that hasarticles of interest to DBAs.

D. The DB2 journal is a GUI that displays historical information about tasks, database actions andoperations, control center actions, messages, and alerts in your DB2 database.

A. DB2 does not have wizard functionality.

B. DB2 wizards programs are automated in DB2. They run as background processes of thedatabase and they automatically configure database parameters.

C. DB2 wizards are DBAs that are considered the top of their field in DB2.

D. DB2 wizards are programs that assist you in completing a single task by stepping you throughthe task.

A. The initial primary authorization ID remains the primary ID, the SQL ID is set equal to theRACF ID of the DB2 subsystem.

B. The initial primary authorization ID is unchanged as the DB2 primary ID, and the SQL ID ismade equal to the DB2 primary ID, and one secondary ID exists and is the name passed byCICS or IMS.

C. The initial primary authorization ID is set to the same value as the first secondary ID.

D. The initial primary authorization ID remains the primary ID, the SQL ID is set equal to theprimary ID, and the list of DB2 secondary IDs is set to the list of group names to which theRACF user ID is connected.

A. It allows for multiple positions.

B. It is illegal.

C. Only one of them can be used.

D. The processing options must be identical.