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

A. Database authorities is a DB2 toolkit application that allows the DBA to set up privileges for thesuperusers who will administer the database.

B. Database authorities are the main DBAs that control schema development in DB2.

C. Database authorities do not exist in DB2.

D. Database authorities provide a way both to group privileges and to control maintenance andutility operations for instances, databases, and database objects.

A. HADR allows up to four HADR standby databases.

B. HADR allows up to five HADR standby databases.

C. HADR allows up to three HADR standby databases.

D. HADR allows up to two HADR standby databases.

A. Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.

B. In order to take advantage of this feature, applications must be changed to work with the RCAC feature.

C. Row and column level access control allows the creation of column masks that can control what column values a user is permitted to see.

D. Table data is protected against direct access to the table. Access using views is unrestricted.

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

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

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

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

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

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

C. DB2 does not have a DB2 control center.

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

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

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

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

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

A. A PRISLD RECON record is created; the PRILOG record will be updated to include the primarySLDS dataset name and the SECLOG record will be updated to include the secondary RLDSdataset name.

B. A PRISLD, a PRIRLDS and a SECRLDS RECON record are created; the PRILOG record willbe updated to include the primary RLDS dataset name and the SECLOG record will beupdated to include the Secondary RLDS dataset name.

C. A PRISLD RECON record is created; the PRILOG record will be updated to include the primaryRLDS dataset name and the SECLOG record will be updated to include the secondary RLDSdataset name.

D. A PRISLD and a SECSLD RECON record are created; the PRILOG record will be updated toinclude the primary RLDS dataset name and the SECLOG recordwill be updated to include thesecondary RLDS dataset name.

A. DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.

B. DB2 LBAC lets you decide exactly who has write/read access to individual rows and columns by comparing the security labels between database objects and users.

C. DB2 LBAC monitors table data access and tables modifications made by database users.

D. DB2 LBAC allows you to use labels to reference database objects by a short name instead of the full qualified name.

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

B. DB2 has no design advisor tool.

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

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.