IBM Certified Database Administrator - IBM IMS Sample Questions:
1. What is the role of the DB2 control center?
A) The DB2 control center allows you to administer all your systems, instances, databases, anddatabase objects.
B) DB2 does not have a DB2 control center.
C) The DB2 control center serves as a collection of command-line entry commands that allow theDBA to administer the DB2 database.
D) The DB2 control center is the main table where all metadata about the database is stored in aDB2 database.
2. What are DB2 constraints?
A) A DB2 constraint restricts the tables that can be related together due to database size issues.
B) A DB2 constraint is a limitation in the DB2 Express product designed to make it less powerfulthan the full DB2 product.
C) DB2 constraints are the limits of the database installation when you install and set up your DB2database.
D) DB2 constraints are rules that can be imposed on data values (in a table) so that they conformto a certain property or business rule.
3. When configuring an Optim Directory, which of the following DBMS types are supported?
A) DB2, Oracle, Sybase ASE, SQL Server, and IDMS
B) DB2, Oracle, SQL Server, IMS and IDMS
C) DB2, Oracle, Sybase ASE, SQL Server, and Informix
D) Only DB2 and Oracle
4. What are some of the benefits of DB2 Express?
A) DB2 Express is designed for development and testing. It is not used as a production database.
B) DB2 Express is a tool that allows the DBA to quickly solve (expressly) complex issues with theDB2 version of software.
C) DB2 Express is faster and more powerful than the DB2 product.
D) DB2 Express has affordable licensing terms with all of the features of the DB2 engine.
5. The following are true about the Configuration Advisor, EXCEPT:
A) By default, the Configuration Advisor is automatically executed when you create a new database.
B) It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.
C) To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.
D) It creates database objects such as indexes and MQTs to improve performance.
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: D | Question # 3 Answer: C | Question # 4 Answer: D | Question # 5 Answer: D |
708 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
