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

A. The replication center is a GUI that is used transfer messages that are queued in themiddleware transaction software (such as IBM MQ) to the DB2 database.

B. The replication center is a GUI that is used to administer replication between a DB2 databaseand another relational database (DB2 or non-DB2).

C. DB2 does not have a replication center.

D. The replication center is a GUI that allows you to replicate tables in your current DB2database.

A. a Sun Solaris Server and Multiple Windows Desktops with Rhumba

B. Optim Data Growth with ODM/Optim Connect

C. an AIX Server, Windows Desktop, and Optim DRA

D. Optim TDM, DP, and Archive with ODM/Optim Connect

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

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

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

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. Declared Global Temporary Tables Compression

B. Temporary Tables Compression

C. Adaptive Compression

D. Classic Row Compression

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

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

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

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

A. The SQL SELECT statement is not used in DB2 because DB2 is a hierarchical database.

B. The SQL SELECT statement allows the DBA to create table structures and pre-populate thosetable structures with database metadata.

C. The SQL SELECT statement is used to return rows of data from your database table or tables.

D. The SQL SELECT statement is used to return the status of the health of the database in thehealth DB2 health center application.

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

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

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

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

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

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

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

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

A. SYSIBM, SYSCAT, and SYSSTAT

B. SYSLOAD, SYSALL, and SYSPASS

C. SYSMANAGEMENT, SYSCREATE, and SYSSTORE

D. SYSSTART, SYSBACKUP, and SYSOPEN