IBM Certified Database Administrator - IBM IMS - C2090-548무료 덤프문제 풀어보기

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

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

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

D. DB2 does not have a journal.

A. DEDBs

B. KSDSs

C. OSAM datasets

D. HALDBs

A. The DB2 health center is the name for the support desk for the DB2 product. If you have avalid DB2 license and maintenance agreement, you may contact the heath center and havethe center monitor your DB2 installation remotely.

B. The health center does not exist in DB2.

C. The DB2 health center is a command-line interface to the health of the DB2 installation. Youcan make corrective changes to the DB2 installation using command line entries and query the heath of the DB2 database.

D. The DB2 health center is a GUI tool that allows you to monitor the state of the databaseenvironment and make any necessary changes to the environment.

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

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

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

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

A. A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.

B. A buffer pool is a logical storage grouping composed of one or more containers.

C. A buffer pool is a DB2 component that manages connections to databases.

D. A buffer pool is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data asit is read from the physical media.

A. SYSSTART, SYSBACKUP, and SYSOPEN

B. SYSLOAD, SYSALL, and SYSPASS

C. SYSIBM, SYSCAT, and SYSSTAT

D. SYSMANAGEMENT, SYSCREATE, and SYSSTORE

A. Tables are comprised of main attributes called platform and legs.

B. Tables are comprised of 3 attributes in DB2. These are the top, the bottom, and the sides.

C. Tables are made up attributes called columns and rows.

D. Tables exist outside of the DB2 database with a single attribute called the table diagonal.

A. Verification is automatically performed by the AUTO_CONFIGURE feature.

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

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

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

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 programs that assist you in completing a single task by stepping you throughthe task.

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

D. DB2 does not have wizard functionality.