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

A. STMM allows DBAs to inspect the current memory allocation by buffer pools.

B. The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.

C. This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.

D. This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.

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

B. The health center does not exist in DB2.

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

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

A. DB2 pureScale is only available for DB2 Express-C and DB2 Advanced Enterprise Edition.

B. DB2 pureScale persists data in the cluster caching facilities (CFs).

C. DB2 pureScale uses the same concept of HADR where the data is replicated from a primary database to a standby database.

D. DB2 pureScale reduces the risk and cost associated with growing your distributed database solution by providing extreme capacity and application transparency.

A. The automatic maintenance wizard allows you to create 4GL scripts to query the database using plain English language as a query language.

B. Using the automatic maintenance wizard is one of the quickest ways to set up your own database.

C. The automatic maintenance wizard simplifies your DB accounting activities to justify DB2.

D. Using the automatic maintenance wizard, all DB table relationships will be created automatically based upon the same column attribute naming being used in each table.

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

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

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

A. Database Name

B. Segment Name

C. Status Code

D. Segment Length

A. The DB2 control center is the main table where all metadata about the database is stored in aDB2 database.

B. DB2 does not have a DB2 control center.

C. The DB2 control center allows you to administer all your systems, instances, databases, anddatabase objects.

D. The DB2 control center serves as a collection of command-line entry commands that allow theDBA to administer the DB2 database.

A. The XQuery builder tool allows you to query and retrieve data from external XML documents.

B. The XQuery builder tool allows you to create queries against XML data.

C. The XQuery builder tool does not exist in DB2.

D. The XQuery builder tool builds well-formed XML documents that can be stored in a hierarchicalform within columns of a table.

A. The DB2 Design Advisor is a tool that can help you improve your database workload performance. Given a set of SQL statements in a workload, the Design Advisor can generate recommendations to improve the performance of SQL execution.

B. The DB2 Design Advisor is a tool that automatically analyzes your running database and continuously makes changes to your database to give it peak performance.

C. The DB2 Design Advisor is a help desk facility that is available to all licensed DB2 owners that have paid their maintenance agreements with IBM. The tool is a web site that guides you through the design of your database, with the DBA responding to a series of questions. It produces a database schema that allows for quick database creation.

D. The DB2 Design Advisor is a tool that can be used to automatically create tables based on a physical data diagram.