最新的IBM Certified Database Administrator - IBM IMS - C2090-548免費考試真題

A. Temporal Tables

B. Multi-Temperature Data Management

C. Table Partitioning

D. INGEST utility

A. Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.

B. Temporal tables provide a quick and easy way to track and record data changes in the table.

C. Temporal tables allow better data management by letting the application control data integrity and uniqueness.

D. Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.

A. HADR allows up to four HADR standby databases.

B. HADR allows up to three HADR standby databases.

C. HADR allows up to two HADR standby databases.

D. HADR allows up to five HADR standby databases.

A. DB2 Express is a tool that allows the DBA to quickly solve (expressly) complex issues with theDB2 version of software.

B. DB2 Express has affordable licensing terms with all of the features of the DB2 engine.

C. DB2 Express is designed for development and testing. It is not used as a production database.

D. DB2 Express is faster and more powerful than the DB2 product.

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

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

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

D. DB2 does not have wizard functionality.

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

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

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. The database being copied by IC2 cannot be HISAM.

B. The database being copied by IC2 cannot be an Index database.

C. The databases copied by IC2 must be registered to DBRC.

D. The control statements used for IC2 are the same as those for Batch Image Copy.

A. You can only execute PL/SQL statements using the CLPPIus interface.

B. DB2 requires third party software to execute PL/SQL statements.

C. PL/SQL support is only enabled when using federation to access other vendor databases.

D. The DB2 compiler can process PL/SQL statements and create the required objects in the database. The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.

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

B. 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.

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

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