October 02, 2008
Here's the latest in this series of sample questions to help you prepare for the DB2 9 DBA certification exam. After you've mastered these, you can browse past questions here.
All questions are from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, and are reprinted with permission. Check back each week for more.
QUESTION 47
Which of the following is NOT a requirement for an HADR environment?
A. The operating system on the primary server and the standby server must be the same (including fix pack level).
B. The database path on the primary server and the standby server must be the same.
C. The DB2 software version and bit size (32 or 64) used on the primary server and the standby server must be the same.
D. Table spaces and table space containers on the primary server and the standby server must be identical.
QUESTION 48
Which of the following statements is NOT true about DB2 security?
A. A custom security plug-in must be created if Microsoft Active Directory will be used to validate users.
B. Only users with Security Administrator authority are allowed to grant and revoke SETSESSIONUSER privileges.
C. Users and groups must exist before they can be granted privileges.
D. If a user holding SELECT privilege on a table creates a view based on that table and their SELECT privilege is later revoked, the view will become inoperative
Answers
QUESTION 47
The correct answer is B. Both the primary and the standby database must be a single-partition database and they both must have the same database name; however, they do not have to be stored on the same database path.
IBM recommends that you use identical host computers for the HADR primary and standby databases. (If possible, they should be from the same vendor and have the same architecture.) Furthermore, the operating system on the primary and standby database servers should be the same version, including patch level. You can violate this rule for a short time during a rolling upgrade, but use extreme caution when doing so. A TCP/IP interface must also be available between the HADR host machines, and a high-speed, high-capacity network should be used to connect the two.
The DB2 software installed on both the primary and the standby database server must have the same bit size (32 or 64) and the version of DB2 used for the primary and standby databases must be identical; for example, both must be either version 8 or version 9. During rolling upgrades, the modification level (for example, the fix pack level) of the database system for the standby database can be later than that of the primary database for a short while. However, you should not keep this configuration for an extended period of time. The primary and standby databases will not connect to each other if the modification level of the database system for the primary database is later than that of the standby database. Therefore, fix packs must always be applied to the standby database system first.
The amount of storage space allocated for transaction log files should also be the same on both the primary and the standby database server; the use of raw devices for transaction logging is not supported. (Archival logging is only performed by the current primary database.) Table space properties such as table space name, table space type (DMS, SMS, or Automatic Storage), table space page size, table space size, container path, container size, and container type (raw device, file, or directory) must be identical on the primary and standby databases.
When you issue a table space statement such as CREATE TABLESPACE, ALTER TABLESPACE, or DROP TABLESPACE on the primary database, it is replayed on the standby database. Therefore, you must ensure that the table space containers involved such statements exist on both systems before you issue the table space statement on the primary database. (If you create a table space on the primary database and log replay fails on the standby database because the containers are not available, the primary database does not receive an error message stating that the log replay failed.) Automatic storage databases are fully supported, including replication of ALTER DATABASE statements. Similar to table space containers, the storage paths specified must exist on both the primary and the standby server.
QUESTION 48
The correct answer is C. The GRANT statement does not check to ensure that the names of users and/or groups that are to be granted authorities and privileges are valid. Therefore, it is possible to grant authorities and privileges to users and groups that do not exist.
« Scripted Detach/Attach Partition with Informix Dynamic Server | Main | DB2 LUW Performance: An IDUG Ed Seminar Case Study »
This is a public forum. CMP Media and its affiliates are not responsible for and do not control what is posted herein. CMP Media makes no warranties or guarantees concerning any advice dispensed by its staff members or readers.
Community standards in this comment area do not permit hate language, excessive profanity, or other patently offensive language. Please be aware that all information posted to this comment area becomes the property of CMP Media LLC and may be edited and republished in print or electronic format as outlined in CMP Media's Terms of Service.
Important Note: This comment area is NOT intended for commercial messages or solicitations of business.