IBM Certified Database Administrator - IBM IMS - C2090-548 FREE EXAM DUMPS QUESTIONS & ANSWERS

A. DB2 has no design advisor tool. B. The DB2 design advisor is a help desk facility that is available to all licensed DB2 owners thathave paid their maintenance agreements with IBM. The tool is a Web site that guides youthrough the design of your database, with the DBA responding to a series of questions. Itproduces a database schema that allows for quick database creation. C. The DB2 design advisor is a tool that can help you improve your workload performance. Thetool asks you questions about your workload and other options it should take into account, and then recommends performance changes to your database. D. The DB2 design advisor is a tool that automatically analyzes your running database andcontinuously makes changes to your database, so that the database is running at peakperformance.

A. SYSMANAGEMENT, SYSCREATE, and SYSSTORE B. SYSIBM, SYSCAT, and SYSSTAT C. SYSSTART, SYSBACKUP, and SYSOPEN D. SYSLOAD, SYSALL, and SYSPASS

A. HADR allows up to five HADR standby databases. B. HADR allows up to three HADR standby databases. C. HADR allows up to four HADR standby databases. D. HADR allows up to two HADR standby databases.

A. LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and columns. 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. 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. D. 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.

A. The last segment successfully retrieved is returned in the IOArea. B. The GB status code is repeated. C. A GE status code (segment not found) is returned. D. The first segment in the database is retrieved.

A. An access plan is part of the security audit that is performed by the DBA, with assistance fromthe network administrator, to list who will have access to database from the point of view of theoperating system. B. An access plan is a plan that is created for each table, describing which users or queries willhave access to the data that is contained in that particular table. C. An access plan is one that specifies an order of operations for accessing data in a SQL query.It lets you view statistics for selected tables, indexes, or columns; properties for operators;global information, such as table space and function statistics; and configuration parametersrelevant to optimization. D. An access plan is the result of the planning phase for the installation of the DB2 product. Ittakes into account who will access the database and which permissions they will have.

A. DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment. B. DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature. C. DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server. D. DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.

A. Only DB2 and Oracle B. DB2, Oracle, SQL Server, IMS and IDMS C. DB2, Oracle, Sybase ASE, SQL Server, and IDMS D. DB2, Oracle, Sybase ASE, SQL Server, and Informix

A. Multi-Temperature Data Management B. Table Partitioning C. INGEST utility D. Temporal Tables